How to ?

[ghost]

please anyone help me with this simple query i jut started with idiorm but cant understand how i can do this using idiorm

$result = mysql_query("SELECT imdb_id FROM shows WHERE imdb_id IS NOT NULL");

while ($row = mysql_fetch_array($result)) {

$imdbdb = $row['imdb_id'];

}

[bradrozier]

Try something like

$result = ORM::for_table('shows')->select('imdb_id')->where_not_null('imdb_id')->find_many();

foreach($result as $row) {
    echo $row->imdb_id;
}

Hope this helps