How do I run a MySQL Query ?

[HeyIts007]

How do I run a ZenCart PHP MySQL Query ? For example to produce a custom report to output every product which might fall under a certain catagory or have a certain field value and then display its name, price and product image in a web page ?

i.e. I presume it could be done in PHP ocde.

It would be appreciated if someone can show me how to do this or point me to a PHP coding example.

Thanks,
007

[stevesh]

That isn't really a Zencart question, and is probably beyond the scope of this forum.

If you search the Free Software Add Ons for 'report' there are some mods that may do what you want or offer some instruction as to how.

There are also many excellent tutorials on PHP and MySQL on the Web.

[HeyIts007]

I'm looking for a ZenCart php MySQL query example, that does not require Admin access. The reports I've seen require admin access to run.

Anyone got any examples that can run without having to be logged in as Admin ? Just something very basic, like list all product specials for example.

[Ajeh]

Best choice is to use phpMyAdmin that should come with the Control Panel for your domain ...

For seeing all the Product Special, browse the table in your database for:
specials

[HeyIts007]

No I want an example of a ZenCart MySQL table query for PHP. Something that can run under any logged in account. I want to extract some table data and display it on a form.

For example I want to select manufacturers_id from table products where the product_id = a given value. I then want to display the manufacturers_id value on screen.

Can someone post some example code ?

[DrByte]

Lots of examples in /includes/functions/functions_lookups.php

[HeyIts007]

OK Thanks. I will take a look.