Jump to content

[SOLVED] insert not working


CincoPistolero

Recommended Posts

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.