Site maintenance: Tuesday 17 Nov, from 10:00 UTC, about 4–6 hours. Details

This cutover relies on some testing that is still incomplete so may be cancelled at short notice

SQL Commands

Locked

Started by frost on 11 Aug 2007, 11:50 PM · Views: 2,214

Results 1 to 3 of 3
This thread is locked. New replies are disabled.
11 Aug 2007, 11:50 PM
#1
frost avatar

frost

New Zenner

Join Date:
Mar 2006
Posts:
15
Plugin Contributions:
0

SQL Commands

One of the mods I have in mind would be for use outside of the Zen cart system. For example if you wanted to show the latest products in your store on a non-store page.

So my question is how do I go about mimicing the sql commands used in Zen Cart?

How should the query be structured and what is the file I need to include to create the sql connection?

Thanks much!

Contributions:: Simple Blue CSS

12 Aug 2007, 12:03 AM
#2
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,511
Plugin Contributions:
176

Re: SQL Commands

You could use the external-sidebox contribution in conjunction with the whats-new sidebox module, to do the whole display.

Or just use the whats-new sidebox module as a reference and build your own display.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.