mysql_query help

[Duskwalker]

Is there anything wrong with this query

mysql_query("insert into shops (owner, name, location, desc, shopkeeper) values('$stat[id]','$name','$location','$desc','$sk')") or die("Could not create shop.");

Thanks

[LordShryku]

Why don't you execute it and find out?

[Duskwalker]

Originally posted by LordShryku
Why don't you execute it and find out?

Ive done it lots and lots of times over the past couple of hours. Redid the script, made sure everyhing is matched up, but its not working.

[LordShryku]

Any sort of errors coming out?

[Duskwalker]

just the Cannot add shop.

Ive checked all the variables and they are all fine

[pjleonhardt]

Originally posted by Duskwalker
Is there anything wrong with this query

mysql_query("insert into shops (owner, name, location, desc, shopkeeper) values('$stat[id]','$name','$location','$desc','$sk')") or die("Could not create shop.");

Thanks [/B]

Try this:

mysql_query("insert into shops (owner, name, location, desc, shopkeeper) values('$stat[id]','$name','$location','$desc','$sk')") or die("Error: " . mysql_error());