How to select one first occurance of record accourding to filed value

[KeredDrahcir]

I'd like to select data from a table. One column in the table (type) can have a value of 1 to 6.
I do different things with the data depending on the value. If the value comes up as 4, I need to look at a column (group) and then as I continue through the table, I need it to miss out any fields where the value of type is 4 and the value of group has come up before.

Is there a way to do this in a loop.

 $sql="SELECT * FROM table WHERE id=$id_value";
$result=mysql_query($sql,$db) or die(mysql_error());
while($row = mysql_fetch_array($result))
{
  $class=new class_name($db, $table, $row['id']);
    process data
}

Many Thanks.

[dgreenhouse]

I'm very unclear on what you're trying to accomplish here...

Could you state your problem a little better?

I understand the code you've shown, but that doesn't indicate what your issue is...

[KeredDrahcir]

When I runs to code it retrives the data from the table. I want to process the data differently depending upon the value of the type field.
If the type field gives me a value of 2, I want to look at the name field and then as I continue through the table I want any occurances of data that have type of 2, and have the name used before to be dicounted, but I want all the rest of the data to be retireved as before.

[KeredDrahcir]

I've managed to solve the problem but if anyone else is interested in the solutions, this is the code I used:

$sql="SELECT field1, field2, field2, field4, MAX(field5) AS field5, field6, field7, field8, field9 FROM table WHERE field3=3 && field9=class->id GROUP BY field5 UNION SELECT field1, field2, field2, field4, field5 AS field5, field6, field7, field8, field9 FROM tabe WHERE field3!=5 && field3!=3 && field9=class->id ORDER BY id";

[KeredDrahcir]

I've found that although the previous solutions works, it doesn't return the first field on the first SELECT statement. I've got three values and it returns the second one I entered. I don't understand why.

SELECT field1, field2, field3, field4, MAX(field5) AS field5, field6, field7, field8, field9 FROM tables WHERE field3=3 && field9=field9=class->id GROUP BY field5 UNION SELECT field1, field2, field3, field4, field5 AS field5, field6, field7, field8, field9 FROM tables WHERE field3!=5 && field3!=3 && field9=class->id ORDER BY field1;
 

The three rows that have the the 3 of three in field3 have the values of 183, 184 and 223 in field1 which were generated using an autoincrement. When I run the query row 184 comes up and I need to row with the lowest number. Can anyone suggest what to do?

[KeredDrahcir]

I need to join two statments together but the ORDER BY is different for each statement so I can't use UNION. Is there a way to do it. I'm trying to find something that will do the same as this:

SELECT * FROM table WHERE field3=3 && field9=2 ORDER BY field1 LIMIT 1 UNION SELECT * FROM table WHERE field3!=5 && field3!=3 && field9=2 ORDER BY field1;
 

I know this wont work, but is there a way to get something that would generate the expected result?