whats wrong with this codew

[gple]

<?php
if (mysql_query("insert into test values (' ', '$day', '$date', '$location', '$time', '$division', '$team1',' ','$team2,' ','$comments')"))
{echo "Success";}
else
{echo "NO";}
?>

 

I keep getting NO. All the variables are correct.

[wildteen88]

Change your code to:

mysql_query("insert into test values (' ', '$day', '$date', '$location', '$time', '$division', '$team1',' ','$team2,' ','$comments') or die('Query error: ' . mysql_error());

echo 'Success';

[AnnieKay]

I'm fairly new to all this but could it be also that you don't have an apostrophe after your $team2 variable? The next apostrophe comes after the comma so it throws things out of whack, but maybe your original code has it... good luck!