[PHP-DB] Re: MySQL query from multiple tables

[Matthew Crouch]

it sounds like you may be serializing your SQL, in which case the following link might
help.
http://www.ashleyit.com/rs/jsrs/select/php/select.php


Matthew Nock wrote:

 Hi All,

 I have a strange query which I need to build - I have looked at the JOIN and
 aliasing functions of mySQL but not sure if I can achieve want I want to do.

 I have two tables (product_head, and product_features) (in addition to a
 number of other tables) which form the list of products I have available,
 and the features available with each product.

 I want to be able to retrieve from product_head the rows which are for a
 specific product category (ie: 1)..  this bit is easy.

 SELECT * from product_head where prod_cat_ID = 1;

 This query could return 1 or more rows - works great.

 but I also want to retrieve records from the product_features table.
 information stored in this table is:

 prod_ID feat_ID feat_value

 so for each product ID, there could be any number of features.  I need to
 retrieve only certain feat_value records, for specific products, where the
 feat_ID equals certain values .

 can I build a single query that will return all these results similar to
 below?

 Prod_ID Prod_name   Feat_1_valueFeat_2_valuefeat_3_value
 1   prod1   34  25  15
 2   prod2   10  15  15
 ...

 does this all make sense?


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: MySQL query from multiple tables

[andy]

hello Matthew:

if I understood your problem right, you have to join the two tables.

E.g:

SELECT
ph.*,
pf.prod_ID,
pf.feat_ID,
pf.feat_value
FROM
product_head ph,
product_features pf

WHERE
ph.prod_cat_ID = 1
AND ph.prod_cat_ID = pf.prod_cat_ID /*join the two tables with the same
id*/
AND pf.yourcriteria = whatever /* put your criteria for table 2 here*/

Hope this helps a bit,

Andy

--
--
http://www.globosapiens.net
Global Travellers Network


Matthew Nock [EMAIL PROTECTED] schrieb im Newsbeitrag
news:[EMAIL PROTECTED]...
 Hi All,

 I have a strange query which I need to build - I have looked at the JOIN
and
 aliasing functions of mySQL but not sure if I can achieve want I want to
do.

 I have two tables (product_head, and product_features) (in addition to a
 number of other tables) which form the list of products I have available,
 and the features available with each product.

 I want to be able to retrieve from product_head the rows which are for a
 specific product category (ie: 1)..  this bit is easy.

 SELECT * from product_head where prod_cat_ID = 1;

 This query could return 1 or more rows - works great.

 but I also want to retrieve records from the product_features table.
 information stored in this table is:

 prod_ID feat_ID feat_value

 so for each product ID, there could be any number of features.  I need to
 retrieve only certain feat_value records, for specific products, where the
 feat_ID equals certain values .

 can I build a single query that will return all these results similar to
 below?


 Prod_ID Prod_name Feat_1_value Feat_2_value feat_3_value
 1 prod1 34 25 15
 2 prod2 10 15 15
 ...

 does this all make sense?




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php