Bug when inserting sql row

[slpshtmike]

$dbh = mysql_connect ("localhost", "teamae_mike", "pass") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db("teamae_negdb");
mysql_query("INSERT INTO news (user, cont, date, title) VALUES ('$user', '$cont', '$date', '$title')") or die(mysql_error());

for some reason, my script inserts two rows when i run it. ( the second row is full of blank values ).

Has anyone ever encountered an error like this before? I have looked at my code over and over and I cant figure out why its doing that.

[abc123]

Give this a try and see if it works.

$theQuery ="INSERT INTO news(user, cont, date, title) VALUES ($user, $cont, $date, $title)";

mysql_query($theQuery,$dbh) or die(mysql_error());

If that doesn't make a difference then try just running the query directly through mysql rather than php. This should help determine if it is a database problem or a php problem.

[Houdini]

$dbh = mysql_connect ("localhost", "teamae_mike", "pass") or die ('I cannot connect to the database because: ' . mysql_error());
$db= mysql_select_db("teamae_negdb")or die(mysql_error());
$query="INSERT INTO news (user,cont, date, title) VALUES ('$first', '$last', '$phone', '$fax')";
$result=mysql_query($query)or die(mysql_error());
if($result)echo "Data was entered into teamae_negdb";

Should work just fine

[laserlight]

The back ticks shouldnt matter here, since they are MySQL's (non-standard) way of delimiting identifiers.