CincoPistolero Posted October 18, 2009 Share Posted October 18, 2009 I've pulled some code that inserts into Mysql 4x db with not problem. I am trying it on a mysql 5.0.81 db. When I run the below code from the phpmyadmin sql query window it inserts fine. I also list the error I'm getting when running that same query. $query = "INSERT INTO annualRev (name, active) VAULES ('$name','$active')"; And here is the error. Error in query: INSERT INTO annualRev (name, active) VAULES ('$0-$20,000','1'). 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 'VAULES ('$0-$20,000','1')' at line 1 Quote Link to comment https://forums.phpfreaks.com/topic/178089-solved-insert-not-working/ Share on other sites More sharing options...
CincoPistolero Posted October 18, 2009 Author Share Posted October 18, 2009 Never mind. I spelled VALUES wrong. Duh, vaules isn't gonna work. Quote Link to comment https://forums.phpfreaks.com/topic/178089-solved-insert-not-working/#findComment-939029 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.