[Resolved] mysql_fetch_array() - supplied argument is not a valid MySQL result resource

[aa-true-vicious]

Okay, I get the error:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/vicious/public_html/void/login.php on line 13

when I use the code:

  $passcode = md5($password);
  $query = mysql_query("SELECT * FROM users WHERE username=$username");
  $r = mysql_fetch_array($query);
  $true = $r['password'];
  $id = $r['id'];

can anyone see whats wrong???

[stolzyboy]

this

$r = mysql_fetch_array($query);
$true = $r['password'];
$id = $r['id'];

needs to be this

$query = "SELECT * FROM users WHERE username='$username';";
$r = mysql_query($query);
$row = mysql_fetch_array($result);
$true = $row['password'];
$id = $row['id'];

[Kinsbane]

Try the following:

  $passcode = md5($password);
  $query = mysql_query("SELECT * FROM users WHERE username='$username'");
  $r = mysql_fetch_array($query);
  $true = $r['password'];
  $id = $r['id'];

[aa-true-vicious]

thanks