Jump to content

invalid query


jeff5656

Recommended Posts

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.