[SOLVED] counting number of users

[runnerjp]

im trying to count the number of users i have signed up by

 

<?php
session_start();
require_once '../settings.php';



$search_query = "SELECT ID FROM users";

$result = mysql_query($search_query);

$result_count = mysql_num_rows($result);


?>

 

 

but its notworking...how ocmes?

[ratcateme]

have you defined and mysql connection??

use this for the query

$result = mysql_query($search_query) or die (mysql_error());

 

Scott.

[runnerjp]

ok i just did a major school boy error....

 

i suppose it will never work if i dont echo the result out  ><  dang lol cheers