472,114 Members | 2,130 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,114 software developers and data experts.

MySql error 1064 on Select AS

mysql_query("SELECT name, street, url, extra1, extra2, i0+i1+i2+i3+i4 AS incoming, o0+o1+o2+o3 AS rent, s0+s1+s2 AS wohnung FROM amigo WHERE top='1' AND status='1' AND ($row[showif]) ORDER BY $row[sortby]");

brings this error
MySQL error no. 1064 occured: 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 'rent, s0+s1+s2

worked in mysql version 4. upgraded to version 5.0.27-log. error occours after upgarding. Anyone any idea whats wrong here ?
Dec 22 '06 #1
2 4117

i think it cannot do
Dec 23 '06 #2
4,258 Expert 4TB
Yes it can!

Ronald :cool:
Dec 23 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

23 posts views Thread by phpfrizzle | last post: by
reply views Thread by Morten Gulbrandsen | last post: by
reply views Thread by Kenneth Illingsworth | last post: by
reply views Thread by Mario Ohnewald | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.