SQL question

[DigitalShadow]

Someone must be able to help?

[kobra]

Someone must be able to help?

Whhile you know what it is that you want, it is not clear to others

Your OP asked for one thing, and this has escalated into something else

i.e.
What page you want this
What customer action will trigger it
What file(s) are you thinking of adding it to
How it is to be displayed
etc etc

As I stated earlier
If in the cart please explain in much more detail what it is you are seeking

We can not read your mind and even though it is clear to you it is not from what you have provided clear to anybody else

[gjh42]

There may not be enough information in the OP's posts to completely create his functionality, but the SQL to get the info requested from the db should be straightforward for those who are good with MySQL.

[kobra]

There may not be enough information in the OP's posts to completely create his functionality, but the SQL to get the info requested from the db should be straightforward for those who are good with MySQL.

Fully agree but almost knew that just the sql was not what was wanted
And why I asked

And is this to be included as some feature in the cart or only for you?

And the poster figured out that they also needed some php/mysql code but no idea given as to what or where this was to be used/displayed

I need a php code to make that work

[DigitalShadow]

I've got the sql code to work in phpmyadmin, what i need is the code to work in the shop front.

SELECT DISTINCT products_model_number FROM `zen_products_description`

All i need is to display the results on the shop front.

What code should i write to that that will display on the shop?

[kobra]

What code should i write to that that will display on the shop?

Back to my original post - you will have to much more specific about where you want this displayed as "display on the shop" is a lot of different pages

[DigitalShadow]

An EZPage would probably be the best place to put the generated list.

[gjh42]

Standard Zen Cart ez-pages don't handle PHP, so you would have to do some tricky customizing to get that to work.
Define pages do handle PHP, so you might make a new page for your content - see the "About Us page" mod in Free Addons.

[DigitalShadow]

Ok, lets say I create a new define page for the list, which isn't a problem.

[gjh42]

Search in Tools > Developers Toolkit for
$db->Execute(
and go to some of the files listed. You will see examples of SQL queries being handled in various ways.

When you assign the result to a variable, you can then use or display that variable's contents in standard PHP ways.