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 Link to comment https://forums.phpfreaks.com/topic/11859-show-the-first-50-items/ 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 Link to comment https://forums.phpfreaks.com/topic/11859-show-the-first-50-items/#findComment-44968 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] Link to comment https://forums.phpfreaks.com/topic/11859-show-the-first-50-items/#findComment-44973 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.... Link to comment https://forums.phpfreaks.com/topic/11859-show-the-first-50-items/#findComment-45317 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.