Log in

View Full Version : Newest Member on non-Vb page


Me2Be
03-21-2001, 08:06 PM
How can I get the name of the newest registered member on a non-Vb page?

Thanks :)

03-21-2001, 10:32 PM
Here you go:

<?php
require("forums/admin/config.php");
$db=mysql_connect($servername,$dbusername,$dbpassw ord);
mysql_select_db($dbname);
$query = "select * from user order by userid desc limit 1";
$resultlatest = mysql_query($query,$db);
$latest_array = mysql_fetch_array($resultlatest);
echo "<FONT FACE=\"Verdana, Arial, Helvetica, sans-serif\" SIZE=\"2\"><b>Greetings to our newest member, <a href=\"/forums/member.ph
p?action=getinfo&userid=$latest_array[userid]\" target=_blank>$latest_array[username]</a> !</b></font>";
?>