mysql table update...

[Anon]

Is there a limit to the number of fields that can be UPDATED at once on a table?

I have a form used to take user info for table update. All options are RADIO BUTTONs on the form.

The query below is not updating my table:

$query = "UPDATE music SET outdoor='$outdoor', workout='$workout', dd='$dd' ";
$query .= ",ppl='$ppl',season='$season',date='$date',pet='$pet',petpeeve='$petpeeve'";
$query .= ",alias='$alias',vac='$vac' where login='$login' && id=$id ";

$login and $id are generated dynamically. They can't be the problem, because they're displayed on the form ok.

I'm using mysql 4.0 Thanks.

Richie.

[Anon]

I figured it out. The table wasn't getting update because I have a column called DATE, which is a reserved word in mysql.

[gardner1]

good to know that that mysql exclusivity on words might cause a problem...

reserved words are always a binzich-sandwich eh?...supplies a nice hehfx tho, e