在PHP上返回整个MYSQL表数据

Question

I found this code once...

$sql_select = "SELECT * FROM users";
$rs_stuff = select($sql_select);

while ($res = mysql_fetch_assoc($rs_stuff)) {

echo ($res("Name")."<br />");

}

It works well, it returns all names found in "Name" col, the problem is I want it to make to return all data in that table, like if I just typed "SELECT * FROM users" on mysql, I don't understand much of PHP, I tried to do this:

echo("<br />
".$res);

But when trying to run this on the page, I just got a empty blank with "Array" written on it... Is it possible to do this without putting the col names in the php?

(Sorry about my English, it is not my main language.)

Answer 1

This happens because $res is a Array

use:

print_r($res);

or if you want a better view of it:

echo '<pre>';
  print_r($res);
echo '</pre>';

OR

you can use:

echo ($res["Name"]."<br />");

also, on this second option, watch out for multidimensional arrays. Your $res might be one. In which case it will be:

echo ($res[0]["Name"]."<br />");

if you have only one result. I suggest you go with the first choice and see how your $res looks like before echoing strings ;)

Either way, please find a good PHP tutorial as it is CLEAR that you lack basic knowledge of how to use and manipulate PHP code.

Hope it helps! :D