multiple queries & mysql_query()
| From: | Wee Keat | 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