Here is what finally worked:
<?php $letter =
isset($_GET['letter']) ? $_GET['letter'] : "A";
//alphabetical pagination links
echo '<div align="center"><b>';
foreach(range('A','Z') as $c){
($letter == $c)
? printf('%s ',$c)
: printf('<a
href="?letter=%s">%s</a> ',$c,$c);
} echo
"</b></div><p>";
//Show all restaurants that
start with $letter $sql
= "SELECT * FROM restaurants WHERE name LIKE '{$letter}%'";
$result = mysql_query($sql) or
die(mysql_error());
while($row = mysql_fetch_assoc($result)){
printf('<div align="left"
width="100"><b>%s</b><br>%s</br>%s</br></div><hr color=#000
width=200></hr>',$row['name'],$row['address'],$result['cviolations']);
}
?>
Thanks again everyone!!
On 7/15/09 10:48 AM, "tedd" <[email protected]> wrote:
At 8:29 AM -0700 7/15/09, Miller, Terion wrote:
>
>Hi all thanks for all the suggestions, I really had no idea this was
>going to be so difficult..
I think you are making it more difficult than it has to be.
Please review what I said and try it out.
Cheers,
tedd
--
-------
http://sperling.com http://ancientstones.com http://earthstones.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
