[SOLVED] data convert?

[dare87]

This code is suppost to pull all the data from one date to another, the problem I am having is that the data is mis matching.

 

The date in the db is YYYY-MM-DD and my NOW() is not working. Please Help

 

<?php
// This will post the three most current news articles.

// Connect to the database.
require_once('../../uwmysql_connect.php');

$query = "SELECT title, picurl AS url, details, DATE_FORMAT(start_date, '%M %d, %Y') AS sdate, DATE_FORMAT(end_date, '%M %d, %Y') AS edate FROM mydata WHERE start_date >= NOW() and end_date <= NOW()";
$results = mysql_query($query);

if ($results)
{	
// Insert the results.
while ($row = mysql_fetch_array($results, MYSQL_ASSOC))
{
	echo '
	<div id="item"><img src="images/' . $row['url'] . '.jpg" alt="' . $row['title'] . '"></div>
	<br><br><br>
	<div class="title2">' . $row['title'] . '</div>
	<div class="datetitle">' . $row['sdate'] . ' - ' . $row['edate'] . '</div>
	<div class="details">' . $row['details'] . '</div>

		';
}

// Free up the resources.
mysql_free_result ($results);
}
else
echo 'There is nothing there!!!!';
?>

[p2grace]

Use CURDATE() instead, the returning result will just be the date without the timestamp

 

http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_curdate

[Barand]

WHERE start_date >= NOW() and end_date <= NOW()

 

Where start date is in the future and end date is in the past ???