X-Cart forums

[TheComputerGuy]

Hi there,
I need to get the total number of registered users I have in my database out. I also would like to get the total online.

How would I do that??

I would appreciate any advice,

Chris

[lildawg]

What do you mean by out? I am a little bit confused on what you are trying to do please explain a little better.

[pmstudios]

There's already a Users online module you could use. Take a look in skin1/modules/Users_online/

To get the total number of registered customers in your database

$result = mysql_query("SELECT login FROM $sql_tbl[customers] WHERE usertype='C'");
$total_registered_users = mysql_num_rows($result);

$smarty->assign("total_registered_users", $total_registered_users);

P.S. You should put your X-Cart version in your forum signature

[groovico]

If you want to export customer details you can use quite a few of our x-cart add ons for this type of thing.

http://www.firetanksoftware.com/x-cart-addon-features.html

[TheComputerGuy]

$total_registered_users

Would that be what I put in the template?

[pmstudios]

Originally Posted by TheComputerGuy

$total_registered_users

Would that be what I put in the template?

Yes, in the template you would use {$total_registered_users}

If you want to display the total on every page, you'll need to include the PHP code from my previous post in a file like auth.php