newhip Posted February 21, 2013 Share Posted February 21, 2013 I keep getting this error "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 'desc) VALUES ([jskdgkfdgjgfdhfxg],[_1353564571.48585_617.png],[fhvcjhvchjvjhvgjh' at line 1 " I know its just a dumb syntax error but i dont get it. Can someone help? struggling with this part a bit... here's the part of the code $sqlqry=mysql_query("INSERT INTO media(title,pic,desc) VALUES ([$title],[$pic2],[$desc])"); if (!$sqlqry) { echo mysql_error(); } Link to comment https://forums.phpfreaks.com/topic/274787-i-know-its-dumb/ Share on other sites More sharing options...
AyKay47 Posted February 21, 2013 Share Posted February 21, 2013 Desc is a mysql reserved word as it stand for descending and must be surrounded by back tics ( ` ) if used in a query as a field reference. Although, I would recommend changing the field name altogether. Also, what's with the square brackets? field values should be encased in quotes. Link to comment https://forums.phpfreaks.com/topic/274787-i-know-its-dumb/#findComment-1413961 Share on other sites More sharing options...
newhip Posted February 21, 2013 Author Share Posted February 21, 2013 Success! thx AyKay47 Link to comment https://forums.phpfreaks.com/topic/274787-i-know-its-dumb/#findComment-1413962 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.