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, K Do I define