Re: [PHP-DB] selecting question

2002-02-21 Thread ACEAlex
Ahha, thats true :) Clever :) - Original Message - From: "William Fong" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, February 21, 2002 1:31 AM Subject: Re: [PHP-DB] selecting question > That's what I'm talking about. Make that on

Re: [PHP-DB] selecting question

2002-02-20 Thread William Fong
ax: 626.968.6877 Wireless #: 805.490.7732| Wireless E-mail: [EMAIL PROTECTED] - Original Message - From: "ACEAlex" <[EMAIL PROTECTED]> To: "William Fong" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, February 20, 2002 3:33 PM Subjec

Re: [PHP-DB] selecting question

2002-02-20 Thread ACEAlex
Message - From: "William Fong" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, February 21, 2002 12:24 AM Subject: Re: [PHP-DB] selecting question > Ok... so tbl.building_info contains all the different types of buildings. > Didn't get that... :) > &g

Re: [PHP-DB] selecting question

2002-02-20 Thread William Fong
-mail: [EMAIL PROTECTED] - Original Message - From: "ACEAlex" <[EMAIL PROTECTED]> To: "William Fong" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, February 20, 2002 1:56 PM Subject: Re: [PHP-DB] selecting question : Because the buildings t

Re: [PHP-DB] selecting question

2002-02-20 Thread ACEAlex
t; <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, February 20, 2002 10:46 PM Subject: Re: [PHP-DB] selecting question > Hmmm... Why do you want two or three tables? Why not just one? > tbl.buildings and tbl.building_queue looks identical. Looks like y

Re: [PHP-DB] selecting question

2002-02-20 Thread William Fong
]> To: "Rick Emery" <[EMAIL PROTECTED]>; "php-db" <[EMAIL PROTECTED]> Sent: Wednesday, February 20, 2002 12:53 PM Subject: Re: [PHP-DB] selecting question : I could make a rutine in php to make it work but i want to make the : datagrabbing thing in mysql :( : : --

Re: [PHP-DB] selecting question

2002-02-20 Thread ACEAlex
I could make a rutine in php to make it work but i want to make the datagrabbing thing in mysql :( - Original Message - From: "Rick Emery" <[EMAIL PROTECTED]> To: "'ACEAlex'" <[EMAIL PROTECTED]> Sent: Wednesday, February 20, 2002 6:25 PM Subject:

Re: [PHP-DB] selecting question

2002-02-20 Thread ACEAlex
uld get Superfarm planet_id=2 should get Superfarm planet_id=3 should get Smaltvark And so on :) Thanx again for responding /Alexander - Original Message - From: "Markus Lervik" <[EMAIL PROTECTED]> To: "ACEAlex" <[EMAIL PROTECTED]> Cc: "php-db" &

Re: [PHP-DB] selecting question

2002-02-20 Thread Markus Lervik
On Wed, 2002-02-20 at 15:03, ACEAlex wrote: > Hi i have trouble with this mysql query. > > OK, i have 3 different tables. > > Tabel 1: building_info > id > name > price > and other > table 2:queue > id > building_id > table 3:buildings_built > building_id > > Ok, now i want to make a query tha