Recordset Filtering

[brattt]

Hi

I am displaying the current date on my web page using the following php code:

<?php
$asdf=$date_array;
$date_array = getdate();
echo $date_array['weekday'], ' ', $date_array['mday'], ' ',$date_array['month'], ' ',$date_array['year'];
?>

this returns eg.: Wednesday 22 March 2006

I have a table in a mysql database called 'todaysGames' which has a column called 'date'. In the date column is a list of different dates for different games.

How do I filter a recordset in such a way that it compares the php result (ie. Wednesday 22 March 2006) with the 'date' column in the database?

ie. it only returns the games results if the date in the database matches the current date?

Any assistance would be very helpful.

[duckduckgoose]

I don't know if this is syntactically perfect, but you could try something like:

$result = mysql_query("SELECT DATE_FORMAT(Date, '%W %d %M %Y') AS FormattedDate FROM todaysGames")
or exit(mysql_error());

    while ($row = mysql_fetch_assoc($result)) {

	$asdf=$date_array;
	$date_array = getdate();
	$phpDate = ($date_array['weekday'], ' ', $date_array['mday'], ' ',$date_array['month'], ' ',$date_array['year']);
	$sql_Date = $row['FormattedDate'];

	if ($sql_Date == $phpDate) {

		... do stuff ...

	}

}

[Ludichrist]

$date_array = getdate();
$phpDate = ($date_array['weekday'], ' ', $date_array['mday'], ' ',$date_array['month'], ' ',$date_array['year']);

if(!$result = mysql_query("SELECT DATE_FORMAT(Date, '%W %d %M %Y') AS FormattedDate FROM todaysGames WHERE FormattedDate = '" . $phpDate . "'")) die(mysql_error());

This will only select rows that match your date.