how to display only certain rows of $result

bloomoon

sorry this is probably very n00bie question but im stuck. i have performed an SQL on my database and my $result looks something like this:

      ID           NAME
      -------------------
       1             john  
       1             paul
       2             barry
       2             dave
       2             susan
       3             janet

i know how to populate a HTML menu with all these names:

while ($row = ibase_fetch_object ($result)) {
...
}

how do I populate a menu with not all the names but only names with a specific ID?

many thanks

jpmoriarty

easiest way to do it is to either put that limitation into your SQL statement ( ie "Select * from users where id>10") or to include it in your loop:

while ($row = ibase_fetch_object ($result))
{
  $id = $row['id'];
  if($id == 4 || $id == 6 || $id>50)
  {
    echo "<option value='$id'>".$row['name']."</option>";
  }
}

bloomoon

i dont want to include it within my sql statement because ive actually got loads of id numbers so i dont want to write loads of sql statements.

the loop thing sounds the best solution for me. i will try that out. thanks for your time.