select f.*,a.admNick from oj_focus f left join oj_admin a on f.admSno = a. admSno where f.focSno =  and f.focState > 0 order by f.focOrder<br /><br />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 f.focState > 0 order by f.focOrder' at line 1