Comparing dates

meekos

I'm used to coding in ASP, but transitioning over to PHP. I'm trying to compare two dates. I only want entries in the database that have not expired. I've written the following code but it does not work.

$today = date('m/d/Y');
"select date_format(expiredate,'%m/%d/%Y) as expiredate where expiredate>=$today";

Nothing comes out when I do this. Am I trying to compare them incorrectly. I've tried placing $today in single quotes.

If anyone can direct me it would be greatly appreciated.

Meekos

LordShryku

What field type is the expiredate field? The usual mysql date format is date("Y-m-d").

meekos

It is a date field stored in the table as YYYY-MM-DD. But I thought the date_format function would convert it into MM-DD-YYYY.

sidney

you need to have a FROM table in your query and the query would look like below

 <?php
error_reporting(E_ALL);
// connect to database
require("connect.php");
$today = date('m/d/Y'); 
$query = mysql_query("select date_format(date,'%m/%d/%Y') as date FROM table_name where date_format(date,'%m/%d/%Y')>='$today'");
while($row = mysql_fetch_assoc($query))
	{
	//display output to see what we got
	foreach($row as $key => $val)
		{
		echo $key." = ".$val." | ";
		}
	echo "<br>";
	}