RE: [PHP-DB] Joining two talbes
| From: | John W. Holmes | Date: | Mon, 24 Mar 2003 03:28:14 +0000 |
| Subject: | RE: [PHP-DB] Joining two talbes | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-26582@lists.php.net to get a copy of this message | ||
> Can someone help me understand joining tables, and how I can do this:
> SELECT clients.business_name, details.quoted_price,
details.finish_date
> FROM clients, details WHERE clients.client_id = details.client_id =" .
> $HTTP_GET_VARS['id'];
Since when can you do
WHERE var1 = var2 = var3 ??
You need to do it such as:
WHERE var1 = var2 AND var1 = var3
---John W. Holmes...
PHP Architect - A monthly magazine for PHP Professionals. Get your copy
today. http://www.phparch.com/