Re: brain cramp, ouch!

Robert Cummings wrote: > > Kelly Meeks wrote: > > > > Ok > > > > Let's say I'm querying a table, and looping thru the results: > > > > $connect=mysql_connect(host,user,pass); > > $thedb=mysql_select(database1); > > $thequery="select * from foo"; > > $theresult=mysql_query($thequery) or die (mysql_error()) > > while ($output=mysql_fetch_assoc($theresult)){ > > > > do stuff here.. > > > > } > > > > What if while I'm looping, I want to take the information I'm looping thru, > > and want to write it to completely different database, assuming that the > > same username and password info works for both databases? > > > > Would you use multiple mysql_select_db statements, and then make refer. to > > the result of that select in your queries? > > > > I'm getting errors when I do that. > > > > Sorry to be so moronical, > > This is not moronical, it gets a lot of coders... what you need to do is > create another connection because the value returned from the mysql_connect > function is a resource identofier, which means if you run two queries on the > same connection the second result set will overwrite the first. Or maybe it's just the result set var that needs to be unique... I don't clearly remember since I have a pooling system that abstracts all this mess for me :) Cheers, Rob. -- .-----------------. | Robert Cummings | :-----------------`----------------------------. | Webdeployer - Chief PHP and Java Programmer | :----------------------------------------------: | Mail : mailto:robert.cummings@webmotion.com | | Phone : (613) 731-4046 x.109 | :----------------------------------------------: | Website : http://www.webmotion.com | | Fax : (613) 260-9545 | `----------------------------------------------'