refiking Posted September 28, 2008 Share Posted September 28, 2008 I just don't see it. Here's the code: $update = mysql_query("INSERT INTO resources (eid, name, source, desc, link) VALUES ('$eid', '$name', '$source', '$desc','$link')")or die(mysql_error()); Link to comment https://forums.phpfreaks.com/topic/126139-solved-sql-syntax-cant-find-the-error/ Share on other sites More sharing options...
Caesar Posted September 28, 2008 Share Posted September 28, 2008 Some of your column/field names may be SQL reserved words (Maybe the table name as well). Too lazy to check so I suggest surrounding column & table names in your query with ticks. If anything, it will not have any negative effect. <?php $update = mysql_query("INSERT INTO `resources` (`eid`, `name`, `source`, `desc`, `link`) VALUES ('$eid', '$name', '$source', '$desc','$link')")or die(mysql_error()); ?> It just hit me that you didn't paste any actual errors you may be getting. That may be a huge clue as to what the problem is. Link to comment https://forums.phpfreaks.com/topic/126139-solved-sql-syntax-cant-find-the-error/#findComment-652253 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.