note 46604 rejected from function.mysql-fetch-object by sean
| From: | sean@php.net | Date: | Sun, 17 Oct 2004 04:48:39 +0000 |
| Subject: | note 46604 rejected from function.mysql-fetch-object by sean | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-78684@lists.php.net to get a copy of this message | ||
Note Submitter: staff at quictabs dot com
----
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"?