I have the following query, which works:
"SELECT product.productid,product.title,
(SELECT count(pic) FROM picture WHERE picture.productid =
product.productid AND picture.pic !='')
AS pcx FROM product WHERE yada yada conditions....
but now I want to get more then just count(pic) from the 'picture' table.
How do I do this?
Michael
--~--~---------~--~----~------------~-------~--~----~
NZ PHP Users Group: http://groups.google.com/group/nzphpug
To post, send email to [email protected]
To unsubscribe, send email to
[email protected]
-~----------~----~----~----~------~----~------~--~---