chrometweaks.org

What is the best web host out there? and is iPage a good one?

Click Here To View All Answers...


First off, What is the best web host out there? and is iPage a good one? Hoping for any response. Another question on my mind: As the title says, I want to add the registered customers & products in the database to the footer of my website..

This is the info I want to add to the footer (which is originally from the admin index):.

I have been messing with it a little bit and this is the code I have added to my footer, but I can't get the counters/numbers to show up correctly..

Any help or ideas from anyone. I just want to show the # of registered customers & the # of products available. I appreciate your help..

Comments (78)

That's a good question. I'm not sure what is the right answer to your question. I'll do some poking around and get back to you if I find an answer. You should email the people at iPage as they probably could give you an answer..

Comment #1

You may want to put some window dressing around the code and alter the <br> breaks to suit, depending on where you are placing the code also you may want to put some style to the text and or change the textual wording at present it is all uppercase with CUSTOMERS and PRODUCTS.

This post has been edited by.

241.

: 22 April 2004, 21:15..

Comment #2

Novice php here, will you edit that so it will say.

X customers x products.

Instead of.

Customers x products x.

?..

Comment #3

OK do you really want the.

X.

<?php.

$customers_query = tep_db_query("select count(*) as count from "TABLE_CUSTOMERS);.

 $customers = tep_db_fetch_array($customers_query);.

 $products_query = tep_db_query("select count(*) as count from "TABLE_PRODUCTS" where products_status = '1'");.

 $products = tep_db_fetch_array($products_query);.

Echo $customers['count']' 'CUSTOMERS'<br>'$products['count']' 'PRODUCTS'<br>';.

?>..

Comment #4

Well, I installed the code and everything worked, but the.

X.

's didn't show up..

Comment #5

Thank you SOOO much! That's exactly what I was looking for. I knew I was close too, but I just couldn't get it exact.

Thanks again..

Comment #6

Agiftcodotcom.

The.

X.

's are hidden.

Glad I could help, however as I say you may want to put your own style etc on the text..

Comment #7

As the title says, I want to add the registered customers & products in the database to the footer of my website..

This is the info I want to add to the footer (which is originally from the admin index):.

I have been messing with it a little bit and this is the code I have added to my footer, but I can't get the counters/numbers to show up correctly..

Any help or ideas from anyone. I just want to show the # of registered customers & the # of products available. I appreciate your help..

Comment #8

Here is a very crude method.

<?php.

$customers_query = tep_db_query("select count(*) as count from "TABLE_CUSTOMERS);.

 $customers = tep_db_fetch_array($customers_query);.

 $products_query = tep_db_query("select count(*) as count from "TABLE_PRODUCTS" where products_status = '1'");.

 $products = tep_db_fetch_array($products_query);.

Echo CUSTOMERS' '$customers['count']'<br>'PRODUCTS' '$products['count']'<br>';.

?>..

Comment #9


This question was taken from a support group/message board and re-posted here so others can learn from it.