[SOLVED] Invalid array ?

[ambo]

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/content/d/e/c/decuralogin/html/profile.php on line 126

      <?
include("Process/dbconnect.php");
$sql="SELECT * FROM userinfo ORDER BY id DESC LIMIT 1";
// OREDER BY id DESC is order result by descending 
$result=mysql_query($sql);
while($rows=mysql_fetch_array($result)){
?>
<table width="269" cellspacing="0" cellpadding="0">
  <tr>
    <td width="76"><div align="right">First Name:</div></td>
    <td width="191"><?php echo $rows['fname']; ?> </td>
  </tr>
  <tr>
    <td><div align="right">Last Name:</div></td>
    <td><?php echo $rows['lname']; ?> </td>
  </tr>
  <tr>
    <td><div align="right">State:</div></td>
    <td><?php echo $rows['state']; ?> </td>
  </tr>
  <tr>
    <td><div align="right">Steamid:</div></td>
    <td><?php echo $rows['steamid']; ?> </td>
  </tr>
</table>


<?
}
mysql_close();
?>

[phpdragon]

in that query you are only asking for the last id result by setting LIMIT 1, try removing this limit

 

the only other thing from that I can see would be to check the table name is called userinfo and there is a column called id, these are usually also case sensitive. I am also assuming that the code there is also from around line 126

[xerodefect]

It seems like you have a mysql query error. Try this

 

Find:

$result=mysql_query($sql);

Replace with:

$result=mysql_query($sql) or die(mysql_error());

 

and see if any errors show up...

 

also your second mistake is mysql_fetch_array keys are put in numbers so it would really be $rows[0]; but there is a way to fix that

 

from changing

while($rows=mysql_fetch_array($result)){

to

while($rows=mysql_fetch_array($result, MYSQL_ASSOC)){

 

or

 

changing fetch_array to fetch_assoc =)