Greaser9780 Posted April 6, 2007 Share Posted April 6, 2007 I am having difficulty figuring out how to only show a list of gametitle by a givin letter. I used a tutorial found here to get the list broken down by letter using a substring but don't know how to only show certain letters. Here is my code right now: $gam1 = mysql_query("SELECT gametitle FROM games ORDER BY gametitle ASC") or die(mysql_error()); while ($list = mysql_fetch_object($gam1)): $letter = strtoupper(substr($list->gametitle, 0, 1)); if ($prev_row != '0-9' && is_numeric($letter)): echo '<br /><a gametitle="#number"></a><b><u>0-9</u></b> '; $prev_row = '0-9'; endif; if ($letter != $prev_row && !is_numeric($letter)): echo '<br /><a gametitle="'.$letter.'"></a><b><u>'.$letter.'</u></b> '; $prev_row = $letter; endif; echo $list->gametitle.'<br />'; endwhile; Quote Link to comment Share on other sites More sharing options...
tippy_102 Posted April 6, 2007 Share Posted April 6, 2007 SELECT gametitle FROM games WHERE gametitle like $letter . '%' ORDER BY gametitle ASC and put your figuring out the letter stuff above it. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.