mysql_fetch_array(): ERROR :(

[helz]

not fully sure why i get this error. i would understand if in the sql syntax there was a variable that has not been defined but they all have been. hes a snippet of the code:

the error is the 3rd line of code below:

$sql = " SELECT * FROM ".$membertable." WHERE username = ".$username."";
   $result = mysql_db_query($db,$SQL,$cid);  

   $row = mysql_fetch_array($result); 
   $password = $row["password"];  

   $id = $row["id"];  

echo "<form name='profile' method='post' action='profile.php'>
<table>
	<tr><td colspan=2><input name='id' type='hidden' value='".$id."'></td></tr>
	<tr><td>Username</td><td><input name='username' type='hidden' value=".$username.">".$username."</td></tr>
    <tr><td>Email Address</td><td><input name='email' type='text'></td></tr>
    <tr><td>Website URL</td><td><input name='www' type='text'></td></tr>
    <tr><td>Highest Game</td><td><input name='hg' type='text'></td></tr>
    <tr><td>Highest Series</td><td><input name='hs' type='text'></td></tr>
    <tr><td>Current Password:</td><td>".$password."</td></tr>
	<tr><td>New Password</td><td><input name='newpass' type='text'></td></tr>
</table>
</form>";

basically it is the edit profile stage of a login script i am working with. login and things works perfectly. only thing left is to get this to grab info from the db into the textboxes.
only thing really is the id and password as the other things have not been edited in yet.

[drawmack]

$sql = " SELECT * FROM ".$membertable." WHERE username = ".$username."";

shouldn't this be

$sql = " SELECT * FROM ".$membertable." WHERE username = \"$username\"";

often it helps if you echo the sql to the screen so you can see exactly what the interpreter is seeing.

[helz]

same error :-/

i did the echo $sql; thing and here is what it says:

SELECT * FROM site_members WHERE username = "test"

[drawmack]

and what is the error you're receiving?

[helz]

this is what i get:

SELECT * FROM site_members WHERE username = test
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in profile.php on line 45
line 45 is line 3 in the code above

[helz]

no idea how it worked but it did. if any of you guys can help me understand why it did then thanks in advance...
heres what i changed the code to:

		$sql = "SELECT * FROM ".$membertable." WHERE username = '".$username."' ";
        $result = mysql_query($sql);

if(mysql_num_rows($result)) {
   while ($row = mysql_fetch_array($result)) {
      $password = $row["password"];
      $id = $row["id"];
	  $email = $row["email"];
      $hg = $row["hg"];
	  $hs = $row["hs"];
	  $www = $row["www"];
   } // while
} // if

[tekky]

here is why it worked...

//original query
$sql = " SELECT * FROM ".$membertable." WHERE username = ".$username.""; 
$result = mysql_db_query($db,$SQL,$cid);
//note one variable is lowercase $sql and the other is uppercase $SQL

//new query
$sql = "SELECT * FROM ".$membertable." WHERE username = '".$username."' ";
$result = mysql_query($sql);
//note both variables are lowercase...

PHP is case sensitive on EVERYTHING (unless specifically mentioned as in the case of eregi() and strcasecmp() )

[helz]

thanks a shedload tekky.
that would explain it because in all my other php files the sql is SQL not sql like in this one.

thanks again

[tekky]

yup yup, suprized that survived so many posts w/o being pointed out yet... 🙂

[superwormy]

And use mysql_query ($query) or die (mysql_error()); so you can see errors when the happen.