[PHP-DB] mysqli - using PREPARED STATEMENTS - worth it?

[PHP freak]

Looking at this page:
http://us2.php.net/manual/en/function.mysqli-prepare.php

Also the new book ADVANCED PHP PROGRAMMING uses the new MySQLi Prepared Statements 
for all queries.

Wondering if that extra code, trouble, and lack of flexibility is worth it? Will it be 
a HUGE performance increase that will be worth those added lines of code for every 
single query?

Any insight appreciated.

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] two different MySQL connections without always select_db?

[PHP freak]

How would you keep two different MySQL connections to two different MySQL databases 
(on two different MySQL servers) up and available with two different pointers (id), 
and not need to always do select_db() to switch between them?

I thought that if I did this:

--- php: -
$aaa_link = mysql_pconnect(localhost, u, p);
mysql_select_db(apples, $aaa_link);

$zzz_link = mysql_pconnect(remotehost, u, p);
mysql_select_db(zebras, $zzz_link);
--

... that I'd be able to access both pretty easily. Like this:

--- php: -
$aaa_result = mysql_query(select * from apples, $aaa_link);
$orchard = mysql_fetch_assoc($aaa_result);

$zzz_result = mysql_query(select * from zebras, $zzz_link);
$zoo = mysql_fetch_assoc($zzz_result);

$aaa_result = mysql_query(update apples set something=' . $zoo['zebrafur'] . ', 
$aaa_link);
--

But it seems to tell me that $zzz_result is not a valid resource - unless I do the 
select_db thing inbetween the two commands.

Is there anyone doing this successfully?  Back-n-forth between two databases?

Thanks for any help.



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php