RE: [PHP-DB] Arraying JOINED tables <--- SOLVED

2002-06-16 Thread César Aracena
> Asunto: Re: [PHP-DB] Arraying JOINED tables > > Try find out if you have an error in your query, like this: > > $query = "SELECT * FROM logins,auth WHERE logins.authname = $variable1 > AND auth.authid = $variable2"; > if ( $result = @mysql_query($query) ) { >

Re: [PHP-DB] Arraying JOINED tables

2002-06-16 Thread Denis Arh
ther thing... maybe you have fields in both table logins and auth with the same name Denis Arh - Original Message - From: "César Aracena" <[EMAIL PROTECTED]> To: "PHP DB List" <[EMAIL PROTECTED]> Sent: Sunday, June 16, 2002 8:59 AM Subject: [PHP-DB] Arrayi

[PHP-DB] Arraying JOINED tables

2002-06-16 Thread César Aracena
Hi all. This should be an easy one for all of you. I want to make a basic SELECT query from two tables and fetch all the results into one array. I’m doing it like this: $query = "SELECT * FROM logins,auth WHERE logins.authname = $variable1 AND auth.authid = $variable2"; $result = mysql_query($qu

[PHP-DB] Arraying JOINED tables

2002-06-15 Thread César Aracena
Hi all and sorry if this message is sent many times, but I’m having problems switching mailing lists from one email address to another. This should be an easy one for all of you. I want to make a basic SELECT query from two tables and fetch all the results into one array. I’m doing it like this:

[PHP-DB] Arraying JOINED tables

2002-06-15 Thread César Aracena
Hi all. This should be an easy one for all of you. I want to make a basic SELECT query from two tables and fetch all the results into one array. I’m doing it like this: $query = "SELECT * FROM logins,auth WHERE logins.authname = $variable1 AND auth.authid = $variable2"; $result = mysql_query($qu

[PHP-DB] Arraying JOINED tables

2002-06-15 Thread César Aracena
Hi all. Hope you’re all alright since I don’t see any of you writing for some time now ;-) This should be an easy one for all of you. I want to make a basic SELECT query from two tables and fetch all the results into one array. I’m doing it like this: $query = "SELECT * FROM logins,auth WHERE lo