jerald717 Posted May 31, 2011 Share Posted May 31, 2011 Hi, I've been messing around with a script downloaded off the net and have been running it on my localhost. However, I've encountered an error of this sort, when the script runs this particular query: "SELECT t2.field_label AS FLABEL, t1.* AS ID, t2.field_comment AS FCOMMENT FROM form_fields AS t1, form_field_translations AS t2 WHERE t1.field_id=t2.field_id AND lang='".$_SESSION['MDS_LANG']."' AND section='$section' AND form_id='$form_id' $where_sql order by field_sort "; the error is: 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 'AS ID, t2.field_comment AS FCOMMENT FROM form_fields AS t1, form_field_translati' at line 1 Problem is, I've found nothing on google on FCOMMENT, and I'm wondering if anyone has any clue what error this is. Thanks! Quote Link to comment Share on other sites More sharing options...
gristoi Posted May 31, 2011 Share Posted May 31, 2011 FCOMMENT is just an alias name given to the fieldname, it could be called bob for all the difference it would make. Your mysql error is actually telling you that your error is with: t1.* Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.