通过php在mysql中错误的参数计数错误

Question

I've been struggling with this for far too long, and I don't see any error.

I've got a table that holds a bunch of locations. When I'm adding a location via my php script, I get an error of 'Wrong parameter count for mysql_query()'.

When I echo the mysql query, everything looks fine,and I can copy and and paste it into phpmyAdmin , everything runs perfectly.

The query looks like this

INSERT IGNORE INTO locations (name, address, city, state, zip) VALUES ('Soboba Casino','23333 Soboba Road', 'San Jacinto', 'CA', '92581')

Am I missing something? Why would this not run in my script, but run in phpmyAdmin?

Sorry, Missed putting in the php, the offensive php seems pretty straight forward

// insert the venue
$insertLoc="INSERT IGNORE INTO locastions (loc, address, city, state, zip) VALUES ('$venueName','$streetAddress', '$city', '$state', '$zip')";
echo $insertLoc;
mysql_query($insertLoc)or die(mysql_query());

Answer 1

Try replacing the third line with

mysql_query($insertLoc)or die(mysql_error());

(Note that I've replaced the second mysql_query() with mysql_error().)