Help - How To Add Another Table To Query

[leemo]

Hi

 

I need to grab some data from another table called, in this case, [|PREFIX|]product_downloads. They primary key for that table is 'downloadid'. I hope I've given enough information. Thanks in advance.

 

$query = "
				SELECT p.*, FLOOR(prodratingtotal/prodnumratings) AS prodavgrating, imageisthumb, imagefile, ".GetProdCustomerGroupPriceSQL()."
				FROM [|PREFIX|]products p
				LEFT JOIN [|PREFIX|]product_images pi ON (p.productid=pi.imageprodid)
				WHERE p.prodvisible='1' AND (imageisthumb=1 OR ISNULL(imageisthumb))
				".GetProdCustomerGroupPermissionsSQL()."
				ORDER BY proddateadded DESC
			";

[o3d]

I need to grab some data from another table called, in this case, [|PREFIX|]product_downloads.

 

What is the relationship between product_downloads and products (i assume)? What output do you want by joining product_download to the query?

[leemo]

I've tried this, but it is not pulling the data from the [|PREFIX|]product_downloads table.

 

This looks pretty correct to me:

 

$query = "
SELECT p.*, FLOOR(prodratingtotal/prodnumratings) AS prodavgrating, imageisthumb, imagefile, ".GetProdCustomerGroupPriceSQL()."
FROM [|PREFIX|]products p
LEFT JOIN [|PREFIX|]product_downloads dn ON p.productid=dn.downloadid
LEFT JOIN [|PREFIX|]product_images pi ON p.productid=pi.imageprodid
WHERE p.prodvisible='1' AND (imageisthumb=1 OR ISNULL(imageisthumb))
				".GetProdCustomerGroupPermissionsSQL()."
ORDER BY proddateadded DESC
";

 

Error here:

 

$GLOBALS['DownloadName'] = isc_html_escape($row['downname']);

downname being the field I require from TABLE [|PREFIX|]product_downloads