* J.M. Roth <[EMAIL PROTECTED]> wrote on 28.01.01 02:05:
> I just installed the newest MySQL (3.23.32) with PHP 4.0.4pl1 (shared
> module) on an Apache 1.3.12 (Linux).
>...
> $query = "SELECT * FROM $userstable ORDER BY when DESC LIMIT 0, 3";
> doesn't work:
>From your query I think you upgraded from a 3.22.x version? When was not a
reserved word in 3.22, but is so in 3.23. There have been a few hints how to
both circumvent and fix this in 3.23, just search the archives. The thread
was called something like "3.22 databases in 3.23 cause problems with fields
named 'when'".
--
Tomi Junnila <[EMAIL PROTECTED]>
http://www.badzilla.net/~topeju/
Electronics and Information Technology,
University of Turku, Finland
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
