Date string search in query

ianh

Hi.
I’m fairly new to both MySQL and PHP, but finding it interesting. I’ve been working on a project that passes variables across the URL from one page to another and then uses the passed parameter to filter a query. This all works fine with Integer values.

So I can’t understand why I can’t do this with a date. Through trial and error and a lot of reading I know the problem is not with the passing of the date, but how I reference it in the query.

In the example I’ve replaced the returned value with the date in $pass_date, this is then used in the query, which never results in any data being found.

If I move the actual string ‘200-03-11’ into the query in place of the $pass_date then the expected result occurs and a extract the data I’m looking for.

As I said I’ve used the same syntax to query many integer values with no problem.

If you can help I’d be most appreciative.

paulnaj

You must quote dates in the SQL itself (as if they were character fields) ...

<?php # Script	

$pass_date = '2007-03-11' ; // It's not 'quoted' yet
$query  = "SELECT membership_no,
			instructor,
			club,
			first_name,
			surname,
			black_tag_1

		FROM tk_members
		WHERE black_tag_1 = '".$pass_date."'"; // quoted

// which now corresponds to ...
//			WHERE black_tag_1 = '2007-03-11'"; // quoted




// By '@'-ing out the following function, you are suppressing the error message ... 
// might as well keep it in whilst you're learning.
$result = mysql_query ($query); 



$num = mysql_num_rows($result);
?>

ianh

Thanks for the help. That's had me looking at the problem for a long time. Easy when you know how. Once again thanks.

paulnaj

It gets easier!

P 🙂