Richard, Here is the code $sql = " INSERT INTO $table (id,date,user,title,brief,body,expires,visible) VALUES(NULL,\"$date\",\"$user\",\"$title\",\"$brief\",\"$body\",\"$exdate\", \"1\") "; $connection = mysql_connect($dbhost, $dbusername, $dbpass) or die ("Could not connect to database"); $db = mysql_select_db($dbname) or die ("could not select db."); $result = mysql_query($sql,$connection) or die ("Could not execute query"); The variables $date etc are from a POST form input Any ideas? Toby -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php