try:
<?php
$connect = mysql_connect("localhost","root","") or die ("connection failed!");
mysql_select_db("users") or die (mysql_error());
echo "connected!"
$recordset = mysql_query("select * from member order by id ASC") or die( mysql_error());
$row=mysql_fetch_assoc($recordset);
extract( $row );
?>