line 29: mysql_query('$SQL') will send the following query to your db: $SQL
i know of no db that understands that ;-) everything in single quotes is NOT parsed by php. here, use double quotes, or better, none at all. hope it works now, phil. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]