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

2004-03-28 Thread 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

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

2002-03-08 Thread 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: - $