jeff5656 Posted March 23, 2011 Share Posted March 23, 2011 Ok I can't see anything wrong with tis but I get an invalid query. "You have an error in your SQL syntax, check the manual etc.:" $query = "insert into proc_exp (last_name, first_name, mrn, dob, staff, procedure, cpt, billing_date, diagnosis) VALUES ('".$row['lname']."', '".$row['fname']."', '".$row['mrn']."', '".$row['dob']."', '".$row['staff']."', '".$row['proc_name']."', '".$row['cpt']."', '".$row['proc_date']."', '".$row['dx']."' )"; echo $query."<br>"; mysql_query($query) or die ("Invalid query in while loop: " . mysql_error ()); Link to comment https://forums.phpfreaks.com/topic/231538-invalid-query/ Share on other sites More sharing options...
Maq Posted March 23, 2011 Share Posted March 23, 2011 Can you post the entire exact error? Link to comment https://forums.phpfreaks.com/topic/231538-invalid-query/#findComment-1191474 Share on other sites More sharing options...
jeff5656 Posted March 23, 2011 Author Share Posted March 23, 2011 Invalid query in while loop: 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 'procedure, cpt, billing_date, diagnosis) VALUES ('smith', 'bob', '1234' at line 1 Link to comment https://forums.phpfreaks.com/topic/231538-invalid-query/#findComment-1191477 Share on other sites More sharing options...
Maq Posted March 23, 2011 Share Posted March 23, 2011 'procedure' is a MySQL reserved word: http://dev.mysql.com/doc/refman/5.1/en/reserved-words.html Link to comment https://forums.phpfreaks.com/topic/231538-invalid-query/#findComment-1191478 Share on other sites More sharing options...
jeff5656 Posted March 23, 2011 Author Share Posted March 23, 2011 "'procedure' is a MySQL reserved word:" Ahh. thanks! Link to comment https://forums.phpfreaks.com/topic/231538-invalid-query/#findComment-1191480 Share on other sites More sharing options...
jeff5656 Posted March 23, 2011 Author Share Posted March 23, 2011 Did they remove the SOLVE button or is my adblock blocking it? I can't find it. Link to comment https://forums.phpfreaks.com/topic/231538-invalid-query/#findComment-1191490 Share on other sites More sharing options...
Maq Posted March 23, 2011 Share Posted March 23, 2011 Did they remove the SOLVE button or is my adblock blocking it? I can't find it. It got lost during the forum upgrade. It should be implemented back in the near future. Link to comment https://forums.phpfreaks.com/topic/231538-invalid-query/#findComment-1191491 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.