php/mysql help

Anon

I'm so used to odbc that I can't get this mysql to work - I can't figure out how to execute this INSERT statement so that it gets added to my database - any ideas? Thanks!

{
$dte = time();
$db = mysql_connect("localhost","","");
mysql_select_db("database_com",$db);
$sql = mysql_query("INSERT INTO getprayer (name,spousename,city,state,country,1,2,3,4,5) VALUES ('$name','$spousename','$city','$state','$country','$1','$2','$3','$4','$5'",$db);
}

sglane

I imagine you get a parse error. This is because you didn't close your quote. At the end of the $sql line, before the close parenthesis and semicolon put a double quote.

Anon

No, there's a double quote, before the comma before the $db - not a parse error - just plain nothing - I don't know how to make mysql execute a query.

Thanks

[deleted]

Rule #2 of debugging SQL; if it doesn't work, print it!

you forgot to close the parenthesis after $5:

('$name','$spousename','$city','$state','$country','$1','$2','$3','$4','$5'",$db);

YOu would have know that if you used error checking:

http://www.hvt-automation.nl/yapf/faq.php?cmd=viewitem&itemid=12