db error?

[imnsi]

$link = mysql_connect("localhost", $dbuser, $dbpass) or die ("Database Error: Couldn't Connect!");

mysql_select_db($dbname, $link) or die ("Couldn't open $db!");

$query = "INSERT INTO contacts values( '$firstname', '$lastname', '$email', '$company', '$title', '$phone', '$fax', '$street1', '$street2', '$city', '$state', '$zip', '$country', '$url', '$datein', '$refer', '$password', '$type' )";


mysql_query($query, $link) or die ("Couldn't input data!");


mysql_close($link);

Is the php/sql correct on this, I keep getting a couldnt input error. Anything you can see?

[cgraz]

It's always a good idea to specify which fields you are inputting into

INSERT INTO table (name, email) VALUES('$name', '$email')

rather than

INSERT INTO table VALUES('$name', '$email')

But either way, your "or die" statement does nothing to help you find the error. why not use mysql_error()

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

Cgraz