Now I see that this mod creates a sidebox for the customer to print out a price list. Wouldn't want them to get too much info.
You could just run a query to a spreadsheet.
The only tricky part would be getting the product description with the ID as they are in two separate tables and the manufacturer with the manufacturer's ID for the same reason.
Butwill get you pretty close.SELECT
products_description.products_name as 'Product',
products.products_quantity as 'Qty on Hand',
products.products_model as 'Model',
manufacturers.manufacturers_name as 'Manufacturer'
FROM
products ,
products_description ,
manufacturers
WHERE
products.products_id in (products_description.products_id) OR
products.manufacturers_id in (manufacturers.manufacturers_id)
This is assuming you don't have a table prefix
Adding WHERE and GROUP BY could clean things up for the display you need.



Reply With Quote
