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

On Wednesday 01 January 2003 20:14, superbus22@attbi.com wrote: > Jason, thanks, but see if you can you read the initial question and try to > answer that one for me. You are a great help with resources when I need > them. Your help is always appreciated. The origial clip is as follows > (concentrate on the ending question): OK concentrating on the last paragraph ... > Is there a better way to delete multiple items > from multiple tables with one SQL string? I don't want to separate the two > DELETE functions and run them through two separate times because of > overhead concerns. I tried looking on the MySQL and PHP website for better > ways of using DELETE syntax on multiple tables, but I had no luck finding > anything useful with my version of MySQL. Any help would be greatly > appreciated. ..., unfortunately that's not possible. Each DELETE statement can only delete from a single table. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * /* "You show me an American who can keep his mouth shut and I'll eat him." -- Newspaperman from Frank Capra's _Meet_John_Doe_ */