[SOLVED] info center

[chris_rulez001]

hi i would like to make an info center for my website and it just wont work, heres what i have so far:

 

<?php
$location = "localhost";
$username = "";
$password = "";
$database = "users";

$conn = mysql_connect("$location","$username","$password");
if (!$conn) die ("Could not connect MySQL");
mysql_select_db($database,$conn) or die ("Could not open database");

$mysql = "SELECT * FROM users WHERE id='1'";
$result=mysql_query($mysql);

echo "Number Of Users Registered: ".$result."";
?>

 

what i want this to do is show how many users are registered and who was the last user to register, can someone help me with this?

[Illusion]

$mysql = "SELECT * FROM users ORDER BY id DESC LIMIT 1;
$result=mysql_query($mysql);
$row = mysql_fetch_assoc($result);
echo "Number Of Users Registered: ".$row['id'];
echo "Last User Reigstered:".$row['username'];

[chris_rulez001]

thanks