bowtellj
Posts: 65
|
| Posted: 09/18/2007, 3:54 AM |
|
I modified the sql to show a random image. I am getting the following error. Going by the manual my syntax is correct. Any Ideas? If I remove LIMIT things work OK as the area is only setup for one image. I thought using LIMIT would be more efficient...Am I wrong?
SQL:
SELECT ImageTitle, ImageName FROM Projects_Images Where StatusID = 1 ORDER By RAND() LIMIT 1
Error:
Database Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '; LIMIT 0,2' at line 1
_________________
Thanks
James
Just another Newbie! - Apache 2.24, PHP 5.2.3, MySQL 5.0.41, Windows XP SP2. CCS 3.2.0.2/4.0.2
|
 |
 |
|
