I'm having trouble with this. I created a page and I keep getting Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/www/loria.freehostia.com/test/staff.php on line 19 This is my code... 9 //If cmd has not been initialized 10 if(!isset($cmd)) 11 { 12 //display only admin users 13 $result = mysql_query("select * from users and order by admin"); 14 15 echo "<center><table border='1'> 16 <tr> 17 <th>Staff</th> 18 </tr>"; 19 while($row=mysql_fetch_array($result)) 20 { 21 //grab the user stats 22 $username=$row["username"]; 23 $id=$row["id"]; 24 $gender=$row["gender"]; 25 $race=$row["race"]; 26 $hair=$row["hair"]; 27 $skin=$row["skin"]; 28 $eyes=$row["eyes"]; 29 30 //make the title a link 31 echo "<td><a href='staff.php?cmd=show&id=$id'>".$row['$username']." </a></td>"; 32 echo "</tr></center>"; 33 34 } 35 } 36 if($_GET["cmd"]=="show") 37 { 38 $result = mysql_query($sql); 39 echo "$username is $gender 'and' a $race, with $hair, $skin 'and' $eyes."; 40 } 41 ?> 42 <center><a href="staff.php">Back to staff</a></center>

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.

Sign In

[SOLVED] mysql_fetch_array help?

Recommended Posts

wsantos

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information