469,925 Members | 1,475 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,925 developers. It's quick & easy.

MySql error 1064 on Select AS

6
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 4022
xpcer
51
i0+i1+i2+i3+i4

i think it cannot do
Dec 23 '06 #2
ronverdonk
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
By using this site, you agree to our Privacy Policy and Terms of Use.