hi can anyone help me please? here is the code from my database witch is the first(1)what im trying to do is get this code to read how many members have signed up to my site i know how to do it one way witch is number(2)and it works fine but the problem is my site is html and php witch is number (1)anyone no how to take number (1) and make it do the same as number (2)? thanks.. (1) $dbu->query("SELECT COUNT(*) AS maxrows FROM p_message WHERE member_id='".$vars['member_id']."' AND `read`='0'"); $dbu->move_next(); $ft->assign("PM_NO", $dbu->f('maxrows') ); (2) <?php $holder = mysql_connect("localhost", "name here", "password here"); mysql_select_db("name here", $holder); $result = mysql_query("SELECT * FROM member", $holder); $members = mysql_num_rows($result); echo "$members members to date! \n"; ?>