Jump to content

Archived

This topic is now archived and is closed to further replies.

dragonstable

Show the first 50 items...

Recommended Posts

$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

Share this post


Link to post
Share on other sites
"ORDER BY index ASC LIMIT 50" onto your sql query. "index" would be the "id" field from the db

Share this post


Link to post
Share on other sites
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]

Share this post


Link to post
Share on other sites

×

Important Information

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.