[Resolved] SQL query problem ?

[developer]

Hello! 🙂

I got this SQL query

$Query2 = "INSERT INTO tabs(date, genre, type, artist,  album, title, tab) VALUES ('$date', '".$row['genre']."', '".$row['type']."',  '".$row['artist']."', '".$row['album']."', '".$row['title']."', '".$row['tab']."' "; 

And get this error msg is:

Error: You have an error in your SQL syntax near '' at line 1 in query: INSERT INTO tabs(date, genre, type, artist, album, title, tab) VALUES ('May 16, 2003', 'punk', 'bass', test 22', 'test234', testing 222', 'this is a test //test'

Here is more of the code:

$Query = "SELECT * FROM unreviewed WHERE id=$id";
$Result = mysql_query($Query) or die("Error: ".mysql_error()." in query: ".$Query);
$row=mysql_fetch_array($Result);

$date = date("M d, Y");  

$Query2 = "INSERT INTO tabs(date, genre, type, artist,  album, title, tab) VALUES ('$date', '".$row['genre']."', '".$row['type']."',  '".$row['artist']."', '".$row['album']."', '".$row['title']."', '".$row['tab']."' "; 

$Result2 = mysql_query($Query2) or die("Error: ".mysql_error()." in query: ".$Query2);

[John_Canyon]

$Query2 = "INSERT INTO tabs(date, genre, type, artist, album, title, tab) VALUES ('".$date."', '".$row['genre']."', '".$row['type']."', '".$row['artist']."', '".$row['album']."', '".$row['title']."', '".$row['tab']."') ";

You were missing an ending parenthesis on VALUES.

[developer]

Thanks John!!! 🙂