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
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