[RESOLVED] Duplicate row setup - hopefully simple

[genista]

Hi!

I have two tables which might store have duplicate columns, ie first_name is in 'suppliers' and first_name is in 'users'.

Having retrieved them from the database i want to setup the rows, only they don't work from I perceived to be the way to do it:

$supplierfirstname= $row['suppliers.first_name'];
$userfirstname = $row['users.first_name'];

What is the correct way of setting this up?

Thanks,

G

[Piranha]

I thought that worked. A way to get around it is to set names in the query, something like this:

SELECT suppliers.first_name as sfn, users.first_name as ufn, ... FROM ...
// Run the query, and get the rows into $row
$suppfn = $row['sfn'];
$userfn = $row['ufn'];

[genista]

Perfect, thanks!