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(); } Quote 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. Quote 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 Quote Link to comment https://forums.phpfreaks.com/topic/274787-i-know-its-dumb/#findComment-1413962 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.