Any clues?

[Phpfr3ak]

Hi, fairly new to php, can't seem to figure out why this isn't working, it did before i added the $level_type aspect in... which i need to work with the way ive changed my script, any ideas as to why its not working?

 

  if ($token == $_SESSION['token']){
      $sql = "SELECT * FROM skills WHERE id=$sid";
      $que = mysql_query($sql) or die(mysql_error());
      $res = mysql_fetch_array($que);
      //code goes here
      if ($playerdata['$level_type'] < $res['level_req']) {
          echo "You don't have the required level to learn this skill<br><br><a href='doresearch.php?sid=$res[id]'>Return to skill points!</a>";
      }
      else {

[Pikachu2000]

You've neglected to say what the actual problem is.

[Phpfr3ak]

It's echoing You don't have the required level to learn this skill, but i don't see as why...

[optikalefx]

its echoing because

 

the value of $playerdata['$level_type'] is less than the value of $res['level_req']

Most likely those values aren't what you are expecting them to be.  Check those guys separately.

 

 

[kenrbnsn]

Lose the single quotes from

 

<?php$playerdata['$level_type']?>

 

just use

 

<?php$playerdata[$level_type]?>

 

 

Variables contained in strings delimited by single quotes are not expanded.

 

Ken

[Phpfr3ak]

I think ive found the issue i think its something along the lines of;

 

if ($playerdata($res[$level_type]) < $res['level_req']) {

 

Yet its not working any ideas? :s sorry im really crummy at php atm trying to gather the basics

[aleX_hill]

$sql = "SELECT * FROM skills WHERE id='$sid'";  --> include quotes around '$sid' and see if that changes things.

[kenrbnsn]

If the id field is numeric, you shouldn't have quotes around the value.

 

Ken

[BlueSkyIS]

i prefer to quote EVERY value. that way, there is never a question to quote or not. is there a reason to not quote numbers?