Insert To Database

[Anon]

this is the script I'm trying to run the values come from a form
I don't get any error messages and the Thank you comes up but nothing is inserted into my database

Please respond back if you know what is wrong.

mysql_connect("localhost",$MysqlName,$MysqlPW);
msql_selectdb("database_name");
$result = msql_query("INSERT INTO Customers (firstN,lastN,address) VALUES ('$firstn','$lastn','$address')");
if(!result)
{
echo "Insert unsuccessful:",msql_error();
exit;
}
else
{
print("thank you");
}

[cordex]

Try changing if(!result) (which should be if(!$result) anyway) to mysql_affected_rows($result).

-Ben

[Anon]

your second line has a typo:

msql_selectdb should probably be mysql_selectdb

[killswytch]

It should actually be mysql_select_db()

• Tek