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 ?