Need assistance with ORDER by

[Tecknowjnkie]

Below is the current sql select statement . I would like to order these results in my own custom order but can not figure out the sql sentence. Any help would be very much appreciaited. For example I want what appears in the 2nd to last row of table "team" to display first and so on. Thank you in advance.

<?php
    //Grab Content from DB
    $management = @mysql_query('SELECT name, position, bio, image from team where class=2');
    if (!management) {
        exit('<p> Error retrieving content from DB please email upde@michaelupdegraff.com with error: ' .
        mysql_error() . '</p>');
        }
        
    while ($display = mysql_fetch_array($management)) {
    $name = $display['name'];
    $position = $display['position'];
    $image = $display['image'];
    $bio = $display['bio'];
    
    
    //Display Instructors
    echo "$image
    <h3>$name</h3>
    <p><strong>$position</strong></p>
    <p>$bio</p><div class=\"clearer\"></div> " ;
    }
    mysql_close();
    ?>

[l0t3k]

hey dude sir!!

u just do 'order by name', 'order by bio', etc....!!!!!

[Tecknowjnkie]

HI l0t3k

THank you I was thinking a much more invlolved sentence, LOL. THank you very much.