Posted by noone on 02/24/06 06:43

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
>

okay.. show us the entire script - remove any passwords, usernames etc...

add:

echo $query."<br>;

so we can see the query as the database sees it...

in
MySQL> show fields from calendar_events;

In your code, I do not see where you are selecting the data to see if it
changed or not (or are you doing this in MySql -- is so, copy/paste the
select statement and the result so we can see what you are doing.

Basic troubleshooting techniques -- make sure what you are contatenating
is what you think it should be...

[Back to original message]