php/mysql value prob

[Inkybro]

Hi,

Hey, I'm making a script with my friend and it isn't working correctly. It's not inserting the value into the table, I've included the script below.

add.php

<?

mysql_connect("localhost","*******","*******");
mysql_select_db("lyrics");


if(empty($POST_['artist'])||empty($POST_['lyric']))
{
	echo "You must fill in all fields!";
	exit;
}
} else { 
	$query = mysql_query("insert into(artist,lyric) values('".$_POST['artist']."','".$_POST['lyric']."')"); 
	echo "Lyric successfully added!"; 
}


?>

[cgraz]

looks like you forgot to tell it what table to insert into.

INSERT INTO table_name (field1, field2) VALUES('$field1', '$field2')

Cgraz