Re: How To Delete Multiple Items Of Multiple Tables Using PHP and MySQL

On Wednesday 01 January 2003 06:30, superbus22@attbi.com wrote: > I was hoping for better news. Thanks for the suggestion, but it will put a > very big strain on my application since every DELETE query will open and > close the mysql connection everytime. Think about deleting 100s of records > one at a time. Surely someone has thought of a better way to do this with > MySQL 3.23. Also, I don't want to run persistent connections, as I only > have a limited number of simultaneous connections to the database > currently. Is there a better way to do all this? Anyone? You can use something like: DELETE FROM table WHERE column IN (val1, val2, val3, ..., valN); -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * /* Most people want either less corruption or more of a chance to participate in it. */