Help With Date in Mysql

DaemonProjects

I am trying to select the date and see if the data i am inserting has been updated using the L_Modified field.

L_Modified = 10/21/2007

$sql_check = "SELECT * listings WHERE L_uid='".$fields[20]."' AND L_Modified < '".$fields[46]."'";

$fields[46] = 12/2/2007
$fields[20] = 1

basically I am trying to do the following:

L_Modified < $fields[46] then update record if not then dont do anything

DaemonProjects

error message I am getting

1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'listings WHERE L_uid='058051835' AND L_Modified =< '07/06/2007'' at line 1

cahva

You are missing FROM:
Fixed:
SELECT * FROM listings ...

toxic_brain

AND L_Modified =< '07/06/2007

it seems like mysql doesn't support =<, we need to stick with <=