Posted by noone on 02/24/06 04:21

Lag wrote:
> I removed the quotes and the same thing still happens......the
> variables are passed but the database doesn't update.
> Any other help you can give would be appreciated.
>
> CODE:

(modified for readability)

$query = "UPDATE calendar_events SET event_title = '" . $title . "',";
$query .= "event_start = " . $date . ", event_shortdesc = '".$desc."'";
$query .= " WHERE id = ". $event;

text should be enclosed in single quotes.
($title and $desc are text fields)

Can you give me the output of "show fields from calendar_events;"

You may also need to enclose the $date field....

or
die(mysql_error());
>
> OUTPUT: test 2006-02-23 01:00:00 testingRecord Updated.
> (original information: test 2006-02-23 01:00:00 testRecord Updated.)
>

[Back to original message]