<<I need it to echo out a table with all the A's first, then a blank line,
then all the B's, a blank line and so on. I could write 26 different
queries, one for each letter of the alphabet, but surely there is a tidier
way.>>
Do a query, sorting by the field you need alphabetized. Then do this (and
tidy it up as you need):
echo "<table>";
while($result = mysql_fetch_row$(query)) {
if(substr($result, 0, 1) != $previousfirstletter) {
$previousfirstletter = substr($result, 0, 1);
echo "<tr><th>$previousfirstletter</th></tr>";
}
echo "<tr><td>$result</td></tr>";
}
echo "</table>";
It's untested, but I believe it will work.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
