On Saturday 25 May 2002 04:26, Miguel Cruz wrote: > On Sat, 25 May 2002, Jason Wong wrote: > > Your biggest problem is that you're trying to nest mysql_query() but > > you're only using 1 link identifier. You need to establish another > > connection using another mysql_connect(). > > The same link identifier can be used simultaneously for any number of > queries so long as they are directed at the same server and rely on the > same user credentials. You can query different databases, etc., on the > same server with the same link identifier, for instance.
I'll take your word for it :) In my early encounters with php I had problems with multiple queries on a single page which were apparently solved by using more than one link-id. Ever since, I've been using more than one link-id when I have nesting or 'over-lapping' queries. -- Jason Wong -> Gremlins Associates -> www.gremlins.com.hk Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * /* Carson's Consolation: Nothing is ever a complete failure. It can always be used as a bad example. */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php