total members registered

fullyloaded

hi
can anyone help me please?
here is the code from my database witch is the first(1)what im trying to do is get this code to read how many members have signed up to my site i know how to do it one way witch is number(2)and it works fine but the problem is my site is html and php witch is number (1)anyone no how to take number (1) and make it do the same as number (2)?
thanks..

(1)
$dbu->query("SELECT COUNT(*) AS maxrows FROM p_message WHERE member_id='".$vars['member_id']."' AND read='0'");
$dbu->move_next();
$ft->assign("PM_NO", $dbu->f('maxrows') );

(2)
<?php

$holder = mysql_connect("localhost", "name here", "password here");
mysql_select_db("name here", $holder);
$result = mysql_query("SELECT * FROM member", $holder);
$members = mysql_num_rows($result);
echo "$members members to date! \n";

bpat1434

ummm... sure....

$holder = mysql_connect('localhost', 'name here', 'password here') or die('Can\'t connect to database');
mysql_select_db('name here', $holder) or die('Couldn\'t select the database');
$query = "SELECT COUNT(*) AS registered FROM member";
$result = mysql_query($query) or die('Something is wrong with the query:<br>'.mysql_error());
$members = mysql_result($result, 0, 'registered');

echo $members.' registered members to date!'."\n";

Something like that?

fullyloaded

hi
thanks for taking the time to reply, the code you have done up works great but is not what im talking about its so hard for me to get the right words to explan it lol here i will try one more time ok this code here will read to see how many pm messages i have if i have 1 it will tell me 1 and so on if you look at the bottom of the code you will see "PM_NO" now if i were to put {PM_NO} just like that in a html page it will tell me how many pm messages i have on the html page so what i want to do with this code is to try and get it to grab the total register members in my database and in replace of PM_NO it will be MEMBERS or what ever the who reason for this is to put it on an html page with out i frames thanks...

$dbu->query("SELECT COUNT(*) AS maxrows FROM p_message WHERE member_id='".$vars['member_id']."' AND read='0'");
$dbu->move_next();
$ft->assign("PM_NO", $dbu->f('maxrows') );

bpat1434

Okay, so then do your query, and then do:

$ft->assign('MEMBERS', $registered_members);

SOmething like:

 $holder = mysql_connect('localhost', 'name here', 'password here') or die('Can\'t connect to database');
mysql_select_db('name here', $holder) or die('Couldn\'t select the database');
$query = "SELECT COUNT(*) AS registered FROM member";
$result = mysql_query($query) or die('Something is wrong with the query:<br>'.mysql_error());
$members = mysql_result($result, 0, 'registered');

$ft->assign('MEMBERS', $members);

That get you what you want?

Oh, there's no reason to PM me with your reply as well. It's unnecessary. I'll read it in the forums, don't need it in my inbox too.

fullyloaded

hi sorry bpat1434 for the pm i went to send the message here but did it to the pm again thanks for your time im getting a Fatal error: Call to a member function assign() on a non-object in /home/poiuio/public_html/tttt.php on line 12 im not sure why anymore help would be great again sorry thanks...

bpat1434

Probably because $ft isn't instantiated as an object prior to the function call. You'd need to create a new object as $ft, and then do the designation. Without code of (1) I can't tell you how to do that. But it should look something like:

$ft = new object_class;