mac
Joined: 04 Nov 2006
Posts: 4
Posted: 2006-11-04 23:38
Back to top
Reply with quote
|
I noticed that the system cannot edit the record of any table if it has a field named `order`.
The sql query made (from function phpMyEdit::myquery)
is
SELECT name,url_link,description,order FROM people
WHERE (id=9)
and it crashes.
Why not use
SELECT `name`,`url_link`,`description`,`order` FROM `people`
WHERE (id=9)
instead?
By adding ` around the field or table names, it eliminates the possibility to the mySQL engine misunderstanding the fieldname `order` with the command ORDER BY.
Thanks!
Mac[/b]
|
westdesign
Joined: 20 Nov 2006
Posts: 2
Posted: 2006-11-20 16:43
Back to top
Reply with quote
|
This is generaly for all "reserved words"
|
|
Post new topic
Reply to topic
|
|
|
Login
Registration
Slovak
