Retrieving rows from MySQL

Help

[PokeTech]

Well I'm using this:

$query = "SELECT * FROM poketech_pokedex WHERE catch_rate='45'";
$result = $database->query($query);
$dex = $result->fetchRow(DB_FETCHMODE_ASSOC,0);
$database->disconnect();

But its only retrieving one Row. How do I get it to retrieve all the row that have 45 as there catch_rate?

[kele56]

while ($dex = $result->fetchRow(DB_FETCHMODE_ASSOC,0))
{
#*$!x ;
yyyy;

}