display data from db

[dru_nasty]

I'm trying to display the amount of people in my reg_mem table starting at a certain time.
I had the time stamped into the column date_added when they registered with time().
Here's what I've got:

$query = "select count(*) from reg_mem where date_added <=time()";
$rs = mysql_query($query, $db_conn);
$row = mysql_fetch_array($rs, MYSQL_NUM);
$total_email_blast = $row[0];

And heres what I call it with in the html part:

<?=$total_email_blast?>

[bastien]

and what is the problem?

[dru_nasty]

I'm not sure, it doesn't work, and I don't get any errors.

[bastien]

Add some debugging code

$query = "select count(*) from reg_mem where date_added <=time()";
$rs = mysql_query($query, $db_conn) or die("query failed because ".mysql_error());
if (($rs) && (mysql_num_rows($rs)>0)))
{
  $row = mysql_fetch_array($rs, MYSQL_NUM);
  $total_email_blast = $row[0]; 
}else{
  echo "no results found";
}//end if