Code: Select all
mysql_connect("server","","");
mysql_select_db("");
$query ="SELECT type, poster, during, time";
$query.=" FROM ws ORDER BY time DESC LIMIT 20";
$result=mysql_query($query);
while (list($type,$poster,$during,$time) =
mysql_fetch_row($result)) {
If i were to add another field to my database like the current date, November 22, 2008, that would then be attributed to each row that was created on that day. Would i be able to set my LIMIT function to something like this?
Code: Select all
<?php
$today = date("l, F j, Y");
$query.=" FROM ws ORDER BY time DESC LIMIT $today";
?>
Thank you.