mySQL error with query SELECT a.cname as cname,a.age as age ,a.size as size , a.schedule1 as schedule1,a.schedule2 as schedule2,a.schedule3 as schedule3, a.schedule4 as schedule4,a.schedule5 as schedule5,a.schedule6 as schedule6,a.schedule7 as schedule7, a.pic1 as pic1,a.memid as memid,a.id as id,b.type3 as type3 FROM cast a LEFT JOIN castdetail b ON (a.id = b.castid) WHERE a.memid = order by mascotgirl desc,a.id desc: 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 'order by mascotgirl desc,a.id desc' at line 7
mySQL error with query select area as result from area1 where id = : 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 '' at line 1mySQL error with query select area as result from area2 where area1_id = and id = : 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 'and id =' at line 1mySQL error with query select area as result from area3 where area1_id = and area2_id = and id = : 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 'and area2_id = and id =' at line 1mySQL error with query select pic1 as result from cast where memid = and mascotgirl=1: 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 'and mascotgirl=1' at line 1mySQL error with query select pic1 as result from cast where memid = order by rand() limit 0,1: 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 'order by rand() limit 0,1' at line 1