note 46604 added to function.mysql-fetch-object

i know this is not really a questions place... but heres a quick one that i need help with can you use function getAllMembers () { $query = "SELECT * FROM gtab ORDER BY artist"; $result = mysql_query($query); while($member = mysql_fetch_object($result)){ $members[] = $member; } return $members; } but have it only grab artist's with like "A" as the first letter in the artists name? Then put all the ones it grabbed in order so if the Artist feild has Anti-Flag Beatles All-American Rejects Arrogant Nofx it'll only list "Anti-Flag, All-American Rejects and Arrogant" on the website? and in Alphabetical order "All-American Rejects, Anti-Flag, Arrogant"? ---- Manual Page -- http://www.php.net/manual/en/function.mysql-fetch-object.php Edit -- http://master.php.net/manage/user-notes.php?action=edit+46604 Delete -- http://master.php.net/manage/user-notes.php?action=delete+46604&report=yes Reason: bad code -- http://master.php.net/manage/user-notes.php?action=delete+46604&report=yes&reason=bad+code Reason: spam -- http://master.php.net/manage/user-notes.php?action=delete+46604&report=yes&reason=spam Reason: useless example -- http://master.php.net/manage/user-notes.php?action=delete+46604&report=yes&reason=useless+example Reason: contains commercial links -- http://master.php.net/manage/user-notes.php?action=delete+46604&report=yes&reason=contains+commercial+links Reason: useless note -- http://master.php.net/manage/user-notes.php?action=delete+46604&report=yes&reason=useless+note Reject -- http://master.php.net/manage/user-notes.php?action=reject+46604&report=yes Search -- http://master.php.net/manage/user-notes.php