Forum Moderators: coopster

Message Too Old, No Replies

Retrieving rows from MySQL

Help

         

PokeTech

12:40 am on Apr 11, 2008 (gmt 0)

10+ Year Member



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

3:49 am on Apr 11, 2008 (gmt 0)

10+ Year Member



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

}