Jump to content



Photo
- - - - -

Current product count


This topic has been archived. This means that you cannot reply to this topic.
6 replies to this topic

#1   skeedo

skeedo
  • Members
  • 222 posts

Posted 12 May 2003 - 20:14

The following will allow you to place your catalog product count anywhere you please:

<?php

$sql = "SELECT COUNT(*) AS Total FROM products"; $query = mysql_query($sql); $data=mysql_fetch_array($query); echo $data['Total'];

?>

You could throw some code around it to make it output:

Currently carrying XXXX products

<!-- Product Count -->

<center>

<font style="font-family: Verdana; font-size: 12px; font-weight: bold; text-align: center;">

Currently carrying 

<font style="background-color: #CCCCCC;">

<?php

$sql = "SELECT COUNT(*) AS Total FROM products"; $query = mysql_query($sql); $data=mysql_fetch_array($query); echo $data['Total'];

?>

</font>

&nbsp;titles

</font>

</center>

<!-- Product Count -->


#2   skeedo

skeedo
  • Members
  • 222 posts

Posted 15 May 2003 - 07:09

See it in action at http://www.gameshipper.com.

#3   Druide

Druide
  • Members
  • 882 posts

Posted 15 May 2003 - 14:16

See it in action athttp://www.gameshipper.com.


where is your link to oscommerce.com ?

You changed it to Powered by Skeedo.com, that's NOT confirm the GNU /GPL from the creators.

Is this your respect to a GREAT FREE PRODUCT ? Shame on you /sad.gif' class='bbc_emoticon' alt=':(' />

#4   wizardsandwars

wizardsandwars
  • Members
  • 4,476 posts

Posted 15 May 2003 - 14:53

Druide,


that's NOT confirm the GNU /GPL from the creators


That is false. He can change it to whatever he likes.
-------------------------------------------------------------------------------------------------------------------------
NOTE: As of Oct 2006, I'm not as active in this forum as I used to be, but I still work with osC quite a bit.
If you have a question about any of my posts here, your best bet is to contact me though either Email or PM in my profile, and I'll be happy to help.

#5   Guyver

Guyver
  • Members
  • 162 posts

Posted 15 May 2003 - 20:05

Its only if you want feedback from the 'My Store' forum that you have to display the 'official' banner.

John

#6   skeedo

skeedo
  • Members
  • 222 posts

Posted 17 May 2003 - 01:32

I would love to keep Oscommerce at the bottom, but too many of my sites have been ripped off already. If I have a link to osc on my page that will only make it easier for them.

#7   Druide

Druide
  • Members
  • 882 posts

Posted 17 May 2003 - 06:17

Druide,



that's NOT confirm the GNU /GPL from the creators


That is false. He can change it to whatever he likes.


i'm sorry but i do believe it's written that IF you change your store so that's it doesn't look like the DEFAULT lay-out then you may delete the copyright info from the catalog (ADMIN is still not allowed), to me it doesn't look that different and I have respect for the creators (maybe my weakness /wink.gif' class='bbc_emoticon' alt=';)' /> )
If i'm wrong then i do appologize right now and go sit in the corner with my donkey hat for an hour :roll:
Whatever it is my appologizes for it
Robert

We all need to learn it once, how hard it may seem when you look at it, also you will master it someday ;)