 |
JamesKB
User
Mar 3, 2008, 5:33 PM
Post #1 of 2
(375 views)
Shortcut
|
HiYa Jake.... (I hope you see this)
I've created a section called "Test About Us," that has 2 records. I have created a field called "order" in each record. When I click "Test About Us" from the CMSB menu I get this error message:
MySQL 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 'order LIMIT 25 OFFSET 0' at line 1
Have a look at: http://www.crcongregation.org/test.php
Any ideas?????
Have a nice day....
--
James
(This post was edited by JamesKB on Mar 3, 2008, 5:38 PM)
|
|
| |
|
Dave
Staff
/ Moderator
Mar 3, 2008, 8:01 PM
Post #2 of 2
(365 views)
Shortcut
|
"order" is a special MySQL keyword. Try putting `backticks` (the key beside the 1 on my keyboard) around it in the sort order fields like this: `order`. Or rename the field to something else such as "sortOrder".
Hope that helps!
Dave Edis - Senior Developer
interactivetools.com
|
|
| |
|
