MySql error 1064 on Select AS

[mmoor]

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 ?

[xpcer]

i0+i1+i2+i3+i4

i think it cannot do

[ronverdonk]

Yes it can!

Ronald :cool: