MySQL Forums
Forum List  »  PHP

Displaying data by dates
Posted by: Mike Bis
Date: January 05, 2006 10:50AM

I have the following code I use to display games for the current day. How would I add a link to the bottom of the list to display games from days to follow?


$sql = "SELECT away, home, time
FROM scheduletable
WHERE date = CURDATE()
ORDER BY time ";

$res = mysql_query($sql) or die (mysql_error());

echo date("F n") . '...<br>';

while (list ($away, $home, $time) = mysql_fetch_row($res)) {
echo "$away vs $home $time<br>";
}



Thanks in advance for any help ....

Options: ReplyQuote


Subject
Written By
Posted
Displaying data by dates
January 05, 2006 10:50AM
January 05, 2006 11:24AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.