MySQL command LIKE '00__' problem

[bc173]

This is my table:

name pageid level

test 1 0001
bla 2 0002
yeah 3 0003

The select of the following query is looping 3 times which is correct, but without any
output!

This is my php code:

$result = mysql_db_query($database, " SELECT * FROM $pagetable WHERE
level LIKE '00__' ");
while (mysql_fetch_array($result))
{
$name = $row["name"];
$pageid = $row["pageid"];
print("<a
href=\"content.php?pageid=$pageid\">$name</a><br>");
}

$name neither $pageid (which are fields of the same table) are retrieved by the query, why not?

Greetz

Barton

[Anon]

I think you should be using mysql_fetch_assoc instead of mysql_fetch_array.