Is there anythign wrong with this code?

[gibigbig]

$datagib = mysql_query("SELECT * FROM sotw ORDER BY id DESC") 
or die(mysql_error()); 
$infogibs = mysql_fetch_array( $datagib );
echo "<table>";
foreach ($infogibs as $infogib) {
	echo "<tr>
<td>".$infogib->id."</td>
<td>".$infogib->username."</td>
<td>".$infogib->profile_link."</td>
<td>".$infogib->category."</td>
<td>".$infogib->week."</td>
<td>".$infogib->link."</td>
<td>edit</td>
<td>delete</td>
</tr>";
}
echo "</table>";
?>

 

is the anything wrong with this, the output is :

edit delete

edit delete

edit delete

edit delete

edit delete

edit delete

edit delete

edit delete

edit delete

edit delete

edit delete

edit delete

[leehanken]

mysql_fetch_array only reads one row at a time, rather than all the rows at once

 

also the result is an array rather than an object so [ ] are used rather than ->

 

I think you mean...

 

$datagib = mysql_query("SELECT * FROM sotw ORDER BY id DESC") 
or die(mysql_error()); 
echo "<table>";
while($infogib = mysql_fetch_array( $datagib ))
{
	echo "<tr>
<td>".$infogib[id]."</td>
<td>".$infogib[username]."</td>
<td>".$infogib[profile_link]."</td>
<td>".$infogib[category]."</td>
<td>".$infogib[week]."</td>
<td>".$infogib[link]."</td>
<td>edit</td>
<td>delete</td>
</tr>";
}
echo "</table>";
?>