members information on main page. NEED HELP!

If anyone knows a php script that can diaplay the number of registered members, the newest registered member and his/her profile linked to that , will be on my main page not the forum pages. Like the main page on http://www.FlashKit.com

If any one can help me, it would be a blessing!

PS: I tried to make my own from the top 10 post script idea but it bombed out

Mike

I tried to do this: by modifying the top 10 post script I came up with this but it never worked. I will just trow out the wrong number.

<?
require("forum/admin/config.php");
$db=mysql_connect($servername,$dbusername,$dbpassw ord);
mysql_select_db($dbname);
$myselect = "select * FROM user ";
$result = mysql_query($myselect);
echo "Registered Members ",$result;
?>

This is what I made so far as I am a novice at this stuff.
Right now it is way incorrect, I made 5 registered users and it say it has 2. If anyone can help I would love it!
Once agian I dont know jack about hack, I am learning!

<?php
require("forum/admin/config.php"); 
$db=mysql_connect($servername,$dbusername,$dbpassword); 
mysql_select_db($dbname); 
$myselect = 'SELECT COUNT(*) AS count FROM user'; 
$result = mysql_fetch_array(mysql_query($myselect)); 
echo "Registered Members ".$result['count']; 
?>

Thanks Ed! I was so close but so wrong. I think I can wing the rest of the code. I will pu in my code when I finish it all up. So every one can see and use it.

Once again thanks and now I can sleep

To make the code a bit more optimized change this line:

$myselect = 'SELECT COUNT(*) AS count FROM user';

To

$myselect = 'SELECT COUNT(userid) AS count FROM user';

No need to pull all of the fields from the user table.

Actually, a COUNT(*) is faster because it just reads the number of rows in a table. COUNT(userid) does a full table scan looking for non-null components only.

When I do that, all I get is;

http://www.soapedup.f2s.com/testing.php

What's wrong?! I just put in the .php code you told me, and I get that... Is there anything I need to edit?

The only thing on in my .php document is;

<?php
require("http://www.soapedup.f2s.com/bbs/admin/config.php")include_path='.:/usr/local/lib/php;
$db=mysql_connect($servername,$dbusername,$dbpassw ord);
mysql_select_db($dbname);
$myselect = 'SELECT COUNT(*) AS count FROM user';
$result = mysql_fetch_array(mysql_query($myselect));
echo "Registered Members ".$result['count'];
?>

..and nothing more... do I need to edit something? What? I have V Bulletin 1.14..-

Originally posted by badmeetsevil-
The only thing on in my .php document is;

<?php
require("http://www.soapedup.f2s.com/bbs/admin/config.php")include_path='.:/usr/local/lib/php;
$db=mysql_connect($servername,$dbusername,$dbpassw ord);
mysql_select_db($dbname);
$myselect = 'SELECT COUNT(*) AS count FROM user';
$result = mysql_fetch_array(mysql_query($myselect));
echo "Registered Members ".$result['count'];
?>

..and nothing more... do I need to edit something? What? I have V Bulletin 1.14..-

Should be:
require("http://www.soapedup.f2s.com/bbs/admin/config.php");
include_path="./usr/local/lib/php";

I changed that.. yet get another phrase error on line 3.. whats wrong?