$query = mysql_query($sql, $conn);
   $num_rows = mysql_num_rows($query);
   $myarray = array();
   while ($user = mysql_fetch_array($query)){

    $myarray[]=$user;


}
echo $num_rows;
mysql_free_result($query);
print_r ($myarray);
mysql_close();
}