Q695 Posted June 14, 2013 Share Posted June 14, 2013 How can I write the HTML, not have an sql escape error, and do the insert? <?php $img_src = ob_get_contents(); //25x25 html table of images being written by about 30 lines of PHP $sql_map_img="INSERT INTO map_image (`user`, `map_id`, `map_img`) VALUES ('$id', NULL, `$img_src`);"; //echo $sql_map_img; $result_creature = mysql_query($sql_map_img, $con) or die ("can not generate result " . mysql_error()); ?> Link to comment https://forums.phpfreaks.com/topic/279164-can-not-generate-result-unknown-column/ Share on other sites More sharing options...
Barand Posted June 14, 2013 Share Posted June 14, 2013 put $img_src in single quotes, not backticks. (Backticks say "this is a column name") Link to comment https://forums.phpfreaks.com/topic/279164-can-not-generate-result-unknown-column/#findComment-1436022 Share on other sites More sharing options...
Q695 Posted June 14, 2013 Author Share Posted June 14, 2013 can not generate result 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 '../images/clear.gif' alt='terain' height='20' width='20' /> Link to comment https://forums.phpfreaks.com/topic/279164-can-not-generate-result-unknown-column/#findComment-1436025 Share on other sites More sharing options...
Barand Posted June 14, 2013 Share Posted June 14, 2013 I have just told you the solution Link to comment https://forums.phpfreaks.com/topic/279164-can-not-generate-result-unknown-column/#findComment-1436037 Share on other sites More sharing options...
Barand Posted June 14, 2013 Share Posted June 14, 2013 You need to escape $img_src as it contains quotes. mysql_real_escape_string Link to comment https://forums.phpfreaks.com/topic/279164-can-not-generate-result-unknown-column/#findComment-1436038 Share on other sites More sharing options...
Q695 Posted June 15, 2013 Author Share Posted June 15, 2013 I feel silly, I shoud've thought that Link to comment https://forums.phpfreaks.com/topic/279164-can-not-generate-result-unknown-column/#findComment-1436087 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.