MySQL (with PHP) How 2 check duplicate date?

Posted: Sun Feb 17, 2002 6:39 pm (22 years, 2 months ago)

I want to add a date to a database, but only if that date doesn't already exist.

I wrote this query to check, but it was returning any dates set to 0000-00-00 as duplicates.

Quote:

$another_date = "2002-03-01";

$query = "SELECT count(*)
FROM $tablename
WHERE date = $another_date";

$result = mysql_query($query, $link_id);
$query_data = mysql_fetch_row($result);
$duplicates = $query_data[0];

So I added the AND statement which stoped 0000-00-00 triggering a duplicate, along with everything else!

Quote:

$another_date = "2002-03-01";

$query = "SELECT count(*)
FROM $tablename
WHERE date = $another_date
AND rom_date != '0000-00-00'";

$result = mysql_query($query, $link_id);
$query_data = mysql_fetch_row($result);
$duplicates = $query_data[0];

What am I doing wrong? How can I do it right?

Thanks,
Darren