Re: [PHP] Query for two fields with the same name

On Wed, April 19, 2006 5:55 pm, Kevin Murphy wrote: > $connection = "select * from connection, pr WHERE connection.area_id > = '$gateway_link' and connection.pr_id = pr.id"; > > Both tables have a field called ID but they have different > information in them. $row['id'] gets me the one from the tab

Re: [PHP] Query for two fields with the same name

Maybe something like this : $connection = "SELECT t2.id AS idtwo, t1.id AS idone FROM connection AS t1, pr AS t2 WHERE t1.area_id = '$gateway_link' AND t1.pr_id = t2.id"; > This is probably a simple question, but I can't seem to find the > answer online. > > I'm using this query: > > $connection

Re: [PHP] Query for two fields with the same name

NOT a php question. Kevin Murphy wrote: This is probably a simple question, but I can't seem to find the answer online. I'm using this query: $connection = "select * from connection, pr WHERE connection.area_id = '$gateway_link' and connection.pr_id = pr.id"; doing "SELECT * FROM bla" is

[PHP] Query for two fields with the same name

This is probably a simple question, but I can't seem to find the answer online. I'm using this query: $connection = "select * from connection, pr WHERE connection.area_id = '$gateway_link' and connection.pr_id = pr.id"; Both tables have a field called ID but they have different informati