Re: [PHP-DB] multiple queries in the same request

2005-06-20 Thread Bruno Ferreira
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?

Re: [PHP-DB] multiple queries in the same request

2005-06-20 Thread Bruno Ferreira
Gabriel B. wrote: 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 I'm not really concerned about performance. i'm *really* concerned about race conditions. I have more than 3mi hits per day. the