Active in the last 24h script

Hello

I'm stucked with some stuffs and I can not find any ways to make them work. I would need help with Active in the last 24 H.

- - - Updated - - -

Anyone?

PHP Code:

---

<?php
$time = time() - 86400;
$date = date('Y-m-d H:i:s',$time);

$activepl = mssql_query("select count(memb___id) from MEMB_STAT where ConnectTM > '$date'");     
$activep = mssql_fetch_row($activepl);
?>

<table width="100%">
<tr>
<th width="50%">Active in last 24h</th>
<td align="right" colspan="2"><?php echo number_format($activep[0], 0, ',', ' '); ?></td>
</tr>
</table>

---