Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Have you tested the queries actually work with the values you are giving them? ie, use phpMyAdmin or similar and try the query manually?</p> <p>I have had situations where I thought my PHP was incorrect but a small error in my SQL was the problem. </p> <p>You might also want to set PHP's error mode to E_ALL. You can do that in php.ini or through the code by having</p> <pre><code>ini_set("display_errors","2"); ERROR_REPORTING(E_ALL); </code></pre> <p>at the start of your script. It should [hopefully] give you an error that identifies your problem.</p> <hr> <p><strong>EDIT</strong></p> <p>I just noticed something with your conditions that may be the problem...</p> <p>You have:</p> <pre><code>if (!$playerLEVEL ==13) { levelUPSTATS (); $playerLEVEL = 13; //etc } </code></pre> <p>I rather suspect that if block will never run and there will be no call to levelUPSTATS(). </p> <p>You are asking <strong>if NOT $playerLEVEL is EQUAL to 13</strong> when you really want <strong>if $playerLEVEL is NOT EQUAL to 13</strong> which would make the condition:</p> <pre><code>if($playerLEVEL != 13) </code></pre> <p>Note where the <strong>!</strong> (NOT) goes.</p> <p>As an aside, you have a situation with your inequalities where certain edge cases would mean the player is two levels.</p> <p>For example, for level 2 you need between 100 and 200 EXP inclusive. But level 3 needs 200 and 400 EXP inclusive. If your player has 200EXP he is technically level 2 and 3. When the code runs it will match the 200 in the Level 2 section of code and not the Level 3 section...</p> <p>Your code:</p> <pre><code>if($playerEXPERIENCE &gt;= 100 &amp;&amp; $playerEXPERIENCE &lt;= 200) //code to make them 2 if($playerEXPERIENCE &gt;= 200 $$ $playerEXPERIENCE &lt;= 400) //code to make them 3 </code></pre> <p>That to me seems wrong - though it might be what you intended, I don't know. If it wasn't intended you should change it to:</p> <pre><code>if($playerEXPERIENCE &gt;= 100 &amp;&amp; $playerEXPERIENCE &lt; 200) </code></pre> <p>Notice the use of <strong>&lt;</strong> [LESS THAN] instead of <strong>&lt;=</strong> [LESS THAN OR EQUAL TO].</p> <p>I hope this solves your problem :)</p>
    singulars
    1. This table or related slice is empty.
    1. POphp mysql gaming levelup script issues
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USEtzeitet
    1. USEtzeitet
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POphp mysql gaming levelup script issues
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThank for the reply, I have inf act tested all my sql statements and everything seems to be running perfect. I honestly think it is a php mistake that i am overlooking but cannot see so I was looking for outside supportive eyes to help
      singulars
      1. PO
      1. USJesse
    2. COI started looking at my code just before you posted and i figure out the !=, lol what a stupid but simple mistake. and thank you for your input on the the level checking, I will most definitely make the proper adjustments. And lastly thank you for the php error display code it allowed me to find some of my variables weren't defined properly.
      singulars
      1. PO
      1. USJesse
    3. COIt is very easy to make little mistakes that go unnoticed! Done a few myself :P When you have a large amount of code that does something similar, you should write just a small portion of it and see if it works. Once you know it works, then add the rest. For example you probably should have just started with Levels 1, 2 and 3. Once you know the code works then you can expand it to cover more levels. It is easier to test and there is less code to change if/when there is a mistake ;)
      singulars
      1. PO
      1. USEtzeitet
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload