[SQL Question] Banned accounts

[ryaku]

I'm trying to make this show who's banned but instead of showing their char names it tells me how many exp:4 lol... >.> forgive me for being a noob in SQL :/

$hostname = "localhost";
$username = "root";
$password = "pw";
$db = "rose131";

$sql = mysql_connect($hostname,$username,$password);
mysql_select_db($db);

$query = mysql_query("SELECT * FROM accounts WHERE accesslevel = '0'");
$result = mysql_num_rows($query);

echo " $result";

mysql_free_result($query);

Thanks in advice.

 

[FragFrog]

use mysql_fetch_assoc instead of mysql_num_rows.

mysql_num_rows, does, indeed, list the number of rows in the last set.

 

[ryaku]

It kinda worked because i have like 10 people banned from my server and it only showed 1 person lol, is that suppost to happen?

 

[Wh005h]

Did just grab the last inserted value? ^_^ *hint* *hint*
ORDER BY accesslevel =p

 

[username1]

sage

Read PHP Manual and MySQL Reference Manual for more information on using MySQL functions in PHP.