MySQL Insert not working in PHP - "Query was Empty"
I have the following code. And the SQL Error that I get is "Query Failed:Query was Empty". Yet, I print the SQL to the screen and it looks OK. The SQL should be fine, because I can run it from server tools, and the record adds OK.
______________________________CODE_____________________________________
<?php session_start();?>
<HTML>
<HEAD>
<TITLE>Add Message - Add Record</TITLE>
</HEAD>
<BODY>
<?
//Write the Entry to the database
//Create a connection object.
$usr = "dbwriter";
$pwd = "password";
$db = "archivedb";
$host = "localhost";
$cid = mysql_connect($host,$usr,$pwd);
if (!$cid) { echo("ERROR: " . mysql_error() . "\n"); }
//Insert Record
$sql = "INSERT INTO archive ( Type, Length, Speaker, Video, Audio, MP3, M4P, Realaudio , Filename, Dategiven, Title)";
$sql=$sql . "VALUES ('" . $_SESSION['type'] . "', '" . $_SESSION['length'] . "', '" . $_SESSION['speaker'] . "', '" . $_SESSION['video'] . "' , '" . $_SESSION['audio'] . "' , '" . $_SESSION['mp3'] . "' , '";
$sql=$sql . $_SESSION['m4p'] . "' , '" . $_SESSION['real'] . "' , '" .$_SESSION['filename'] . "', '" . $_SESSION['dategiven'] . "', '" . $_SESSION['title'] . "')";
echo $sql;
mysql_db_query($db,$SQL,$cid) or die("Query failed: " . mysql_error());
echo ("The Message has been added to our Archive database.");
echo ("<BR>".$result."<BR>");
mysql_close($cid);
?>
<FORM METHOD="post" ACTION="addmessage.php">
<INPUT TYPE="submit" VALUE="Add a New Message">
</FORM>
</BODY>
</HTML>
______________________________SCREEN OUTPUT________________________________
INSERT INTO archive ( Type, Length, Speaker, Video, Audio, MP3, M4P, Realaudio , Filename, Dategiven, Title)VALUES ('Sermon', '12', 'Gary Black', 'T' , 'T' , 'T' , 'T' , 'T' , 'test', '2008-05-23', 'test')
Query failed: Query was empty