Re: [PHP-DB] Store more than 1 piece of information in a single variable

2007-08-03 Thread Michael Preslar
First.. You're using mysql_fetch_array when you wanted mysql_fetch_assoc.. .. select user_id from whatever .. and then $row = mysql_fetch_array($res) .. youd have a $row[0].. mysql_fetch_assoc would allow $row['user_id'] Secondly.. You can use one query to select all the info.. select e107.user_i

Re: [PHP-DB] Updating 2 Databases from a single form

2007-09-27 Thread Michael Preslar
On 9/27/07, Derek <[EMAIL PROTECTED]> wrote: > Hello, > > I was wondering if there is anyway to first connect to two databases > simeltaneously. (both reside on the same server) . After connecting, I have > a single form that I want to use to update data to 2 different tables, both > tables are in

Re: [PHP-DB] parameters not working under PDO

2007-10-31 Thread Michael Preslar
Check $parts.. print_r($parts) and make sure its 1) an array 2) contains 2 values On 10/31/07, Chris Curvey <[EMAIL PROTECTED]> wrote: > It's quite possible that I'm missing something obvious here. The > following code fragment does not return any rows, but if I take out the > parameters and repl