How to create a [USERS] placeholder to show Number of Users

Solutions for other advanced phplisters

Re: How to create a [USERS] placeholder to show Number of Users

Postby Andy000 » 10:19pm, Wed 20 May, 2009

Hi CS2, thank you! :)

Here is a modification that works for me, returning the number of confirmed users:

Code: Select all
$query = 'SELECT COUNT(id) FROM '.$table.' WHERE (confirmed = 1)';
$result=mysql_query($query);
$array = mysql_fetch_array($result);
echo $array[0];


Smiles,

Andy
Andy000
PL Nut
 
Posts: 18
Joined: 12:00am, Fri 27 Mar, 2009
Location: New Zealand South Island

Previous

Return to Advanced Answers, Howtos, Tips & Tricks

Who is online

Users browsing this forum: No registered users and 1 guest