Whats wrong? It gets no rows from the database

[TeddyKiller]

The PHP code echo's "none", and I don't know why I have a row in the database, it just echo's none?

Sorry for lack of information, I'm competely stumped..

 

<?php
  include("lib.php");
  $player = check_user($secret_key, $db);
    $query = $db->execute("select * from `skills` where `type`='spells' and `user_id`=?", array($player->id)) or die("query failed: ". mysql_error());
   if($query->recordcount > 0){ 
        while($row = $query->fetchrow()) {
        echo $row['name'];
        }
    } else { echo "none"; }
        ?>

[mikesta707]

well clearly the query isn't finding anything. but since its all locked away in that class I can't be of much help without seeing the class internals