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? Quote Link to comment 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. Quote Link to comment Share on other sites More sharing options...
jemgames Posted May 4, 2007 Author Share Posted May 4, 2007 Thanks! 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.