dragonstable Posted June 13, 2006 Share Posted June 13, 2006 $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 Quote Link to comment Share on other sites More sharing options...
joquius Posted June 13, 2006 Share Posted June 13, 2006 "ORDER BY index ASC LIMIT 50" onto your sql query. "index" would be the "id" field from the db Quote Link to comment Share on other sites More sharing options...
redarrow Posted June 13, 2006 Share Posted June 13, 2006 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] Quote Link to comment Share on other sites More sharing options...
dragonstable Posted June 14, 2006 Author Share Posted June 14, 2006 Thanks to both of you for helping.... Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.