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 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. Link to comment https://forums.phpfreaks.com/topic/178089-solved-insert-not-working/#findComment-939029 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.