Unable to execute query

[hynespm]

Im trying to execute this query from a previous page where all the variable are entered...the values are not inserted into the db.It connects fine.heres the code....maybe someone can help....

<?
$dbh=mysql_connect("localhost","patrickh_test","slalom");
@mysql_select_db("patrickh_ratemypub") or die( "could not connect to database!");

$query="INSERT INTO pubs VALUES('$pubname','$street','$town','$county','$openinghours','$contactnumber','$lounge','$barandnightclub','$barwithnonightclub','$barandrestaurant','$barrestaurantnightclub','$description','$dance','$hiphop,'$pop','$rock','$eightys','$ninetys','$techno','$traditional','$other','$pubfood','$italien','$american','$irish','$mexican','$foodtime','$reservation')";
mysql_query($query) or die("did not work");

mysql_close();
?>

cheers
Paddy 🙂

[Roger_Ramjet]

So how are you passing the vars to the query?

Debugging 101

Always print out the query string before you run it to see what is actually being sent to the db. Queries fail for all sorts of simple syntax reasons that become obvious only when you see the query itself - not how it is built.

[bough]

Also in your query you have missed a hypen ' after hiphop - '$hiphop,'$pop'