Posted by Jerry Stuckle on 02/24/06 05:22

Lag wrote:
> This is the ouput for......
>
> $query = "UPDATE calendar_events SET event_title = '" . $title . "',";
>
> $query .= "event_start = " . $date . ", event_shortdesc = '".$desc."'";
>
> $query .= " WHERE id = ". $event;
>
>
> test2 2006-02-23 01:00:00 testYou have an error in your SQL syntax.
> Check the manual that corresponds to your MySQL server version for the
> right syntax to use near '01:00:00, event_shortdesc = 'test' WHERE id
> =' at line 1
>

It's telling you the same thing everyone else has been saying - although
not so clearly.

ALL non-numeric data MUST be within single quotes. And 01:00:00 is not
numeric data.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[Back to original message]