Gabriel B. wrote:
SELECT (@category_id:=id) FROM categories WHERE description = "cat1";
REPLACE INTO data VALUES( 10, @category_id);
i send this as a single query in PHP and it returns an error quoting
everything after the first ";"
anyidea if i can't send several queries at once? any workaround?
You can't send multiple queries in an SQL statement. You can just
split that in two separates queries. It's not really slower by any
practical means because the DB system would have to execute them both
anyway.
-- Bruno Ferreira
---
[This E-mail scanned for viruses by Declude Virus]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
