Display Info from mySQL by letter

[GnaUnited]

Can anyone see why this won't work?

$result = sql_query("select id, title, time from gnadatagame where platform='$title' AND UPPER(title) LIKE '$let%'", $dbi);
        while(list($gid, $title, $time) = sql_fetch_row($result, $dbi))
            {
	        $cresult = sql_query("select * from gnadatagame where platform='$pid'", $dbi);
	        $cnumrows = sql_num_rows($cresult, $dbi);
	        $cnumm = "$cnumrows game(s)";
	        echo "<tr><td width=33% height=20><font class=\"option\"><center><a href=\"modules.php?name=Test&amp;cheat=opengame&amp;pid=$pid&amp;gid=$gid\">$title</a></td><td height=20 width=33%><center>$cnumm</td><td width=33% height=20><center>$time</td></tr>";
            }

[LordShryku]

Well, first I'd wonder what error message you are getting?

Next, what are you trying to do with this?
AND UPPER(title) LIKE '$let%'"

If you want the $let variable to be upper, change that to AND title like upper($let)%

Otherwise you may be saying that the field should look for uppers, but your variable might not be upper...