multiple queries & mysql_query()

From: Date: Fri, 23 May 2003 02:06:58 +0000
Subject: multiple queries & mysql_query()
Groups: php.general 
Request: Send a blank email to php-general+get-148679@lists.php.net to get a copy of this message
Hi all, I'm using a rather rediculous piece of code that doesnt work: $CatId = 2; $query = "DELETE FROM ProdCat WHERE CatId=$CatId;DELETE FROM ProdList WHERE CatId=$CatId;DELETE FROM Slideshow WHERE CatId=$CatId"; $result = mysql_query($query); When run with mysql_error(), i get syntax errors with the $query contents. Anyone know what im doing wrong or can suggest a better method of doing 3 delete statements at once? Yours, Wee Keat Chin http://www.visualdensity.com ------------------------------------------ "Two things are infinite: the universe and human stupidity; and I'm not sure about the the universe." - Albert Einstein

« previous php.general (#148679) next »