VP-Cart Shopping Cart

Welcome, Guest ( Customer Panel | Login )

All Forums

VPCart Forum

Customization

random display if cimageurl not equal to empty

New Topic

Reply to Topic

Printer Friendly

Author

Topic

skynet104
VP-CART New User

94 Posts

Posted - February 09 2004 : 00:24:28

Hi there:

"random display if cimageurl not equal to empty"

Dear Sirs:
I have several products that I would like to present in the the main page, however most of my database is not completed yet, I would like to show only the items that contain something in the "cimageurl" field.
Is there some codding I can use to setup the random feature to just to show those that contain information in the "cimageurl" field?

help will be greattly appreciated.

Thanks in Advance.

siraj
VP-CART New User

USA
194 Posts

Posted - February 09 2004 : 00:37:45

Hi..
Locate this line (around 121) in shoprandomproducts.asp
sqlstr="SELECT catalogid FROM products where hide=0"
and change to
sqlstr="SELECT catalogid FROM products where hide=0 AND cimageurl <> ''"
Something like this would work for you but never tested.
GOOD LUCK.
SIRAJ.

[email protected]

Edited by - siraj on February 09 2004 00:41:54