i'm a big dummy, help me

[big bad opus]

$tablename = "songs";

$link = mysql_connect($host, $user, $password);

$query = "INSERT into $tablename values ('0','$array[artist]','$array[songtitle]','$array[file]','$array[review]','$array[date]','0','1')";

print("your query is:<br> $query <p>\n");

if (mysql_db_query($query, $dbname, $link)) {
    print("thanks, the audio was added successfully<br>\n");
}else{
    print("you messed up, try again<br>\n"); 
}

mysql_close($link);

?> 

can anyone tell me why this isn't working? i keep getting the "you messed up, try again" message.

[qslack]

Try adding this somewhere in your code:

echo mysql_error();

And tell us what the error message is.

[big bad opus]

mysql_db_query was mixed up. i fixed it and it works now.