jemgames Posted May 4, 2007 Share Posted May 4, 2007 Hey! How do you code the system like on the front page of 64digits.com where you use SQL to retrieve the latest 8 database records? I have tried lots of things but they dont work. Can someone help me? Link to comment https://forums.phpfreaks.com/topic/50051-latest-submitions-ive-tried-loads-of-things/ Share on other sites More sharing options...
pocobueno1388 Posted May 4, 2007 Share Posted May 4, 2007 $sql = mysql_query("SELECT col FROM tbl WHERE blah='$blah' ORDER BY id DESC LIMIT 8"); while ($row=mysql_fetch_assoc($sql)){ echo $row['col'].'<br>'; } Obviously you just need to replace that information with yours. Link to comment https://forums.phpfreaks.com/topic/50051-latest-submitions-ive-tried-loads-of-things/#findComment-245675 Share on other sites More sharing options...
jemgames Posted May 4, 2007 Author Share Posted May 4, 2007 Thanks! Link to comment https://forums.phpfreaks.com/topic/50051-latest-submitions-ive-tried-loads-of-things/#findComment-245708 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.