Newb help :(

[Tom Camp]

Can someone tell me why this doesn't work. I've been pulling my hair out for a couple of hours now and am at my wits end.


mysql_connect("$host", "$userName", "$pword") or die('Could not connect: ' . mysql_error());

mysql_select_db("pmmotoco_p_pet") or die ("Could not connect to database\n");

$query = "INSERT INTO trackpet (pid, name, address, city, county, state, email) VALUES(NULL, $name, $address, $city, $county, $state, $email)";
$result = mysql_query($query);