Show the first 50 items...

[dragonstable]

$data = mysql_query("SELECT * FROM items WHERE user='$username'")
or die(mysql_error());
while($info = mysql_fetch_array( $data ))
{
Print "<center> ".$info['itemname'] . " <br>";
Echo "<img src=http://dragonstable.fileplace.biz/".$info['image'] ."> <br>";
Print " ".$info['rarity'] . "</center><br> ";
}
?>




thats my current script just after connecting, it works but shows each of the items one under the other and in the centre of the page... Is there a way I can make it go about 4 wide and then down to the next line and repeat, and then only show the first 50 items? Please help me if any of this makes sense to you... Thanks

[joquius]

"ORDER BY index ASC LIMIT 50" onto your sql query. "index" would be the "id" field from the db

[redarrow]

The rest is table for formating data ok.

[code]
$data = mysql_query("SELECT * FROM items WHERE user='$username'")
or die(mysql_error());
while($info = mysql_fetch_array( $data ))
{
Print "<center> ".$info['itemname'] . " <br>";
Echo "<img src=http://dragonstable.fileplace.biz/".$info['image'] ."> <br>";
Print " ".$info['rarity'] . "</center><br> ";
}
?>
[/code]

[dragonstable]

Thanks to both of you for helping....