wrong parameter count error in mysql via php

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

That's a PHP error, not a MySQL error. Check your PHP code, and post it if you need more help.

Edited answer after question edit: It's the die() clause. mysql_query wants at least one parameter. Someone else recommended using mysql_error(), which is probably what you meant to do.

Answer 2

Could you please show the PHP causing this error? If I were to guess I'd say it's a misplaced quote in the SQL you're creating, causing the parameter count to be off.

mysql_query("INSERT IGNORE INTO locations (name, address, city, state, zip) VALUES ('$place", '$address', '$city', '$state', '$zip')");

That would parse into multiple parameters.

Answer 3

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().)

Answer 4

or die(mysql_query()); should be or die(mysql_error());

Also, in your SQL I guess locastions should be locations