re: Parse Error

From: Date: Fri, 22 Feb 2002 18:25:39 +0000
Subject: re: Parse Error
Groups: php.db 
Request: Send a blank email to php-db+get-17204@lists.php.net to get a copy of this message
I'm sure by now this has already been answered, but just in case it hasn't been, you've got an extra ')' at the end of this line: r_num\""); I hate to post this again but I have looked in a couple of php and mysql books but cannot seem to figure this one out. I am getting a parse error when trying to use php to delete records from a table. The error I am recieving is as follows.... Parse error: parse error in /path/to/php/done2.php3 on line 22 Here is the file that is giving me the error, any help would be great... I think that my problem is that I left out a variable to hold the $cars data but I am not sure. Here is the code... $db_name = "test"; $table_name = "inventory"; $connection = @mysql_connect("localhost", "root", "password") or die ("Could not connect to database. Please try again later."); $db = @mysql_select_db("$db_name",$connection) or die ("Could not select database table. Please try again later."); $sql = "DELETE FROM $table_name WHERE $cars = \"$car_type\",\"$car_model\",\"$car_year\",\"$car_price\",\"$car_vin\",\"$dl r_num\""); $result = @mysql_query($sql, $connection) or die ("Could not execute query. Any insight would be great... thanks again. Jas

« previous php.db (#17204) next »