title: displaying records from mysql in ul and li format with php
body: <p>i want to display the mysql's fetched results with php and html in unordered list and list format  as like <a href="http://www.miniclip.com/games/en/" rel="nofollow">http://www.miniclip.com/games/en/</a>. you can see in the all games categories in the footer in alphabetical order. the same requirement i do have. i guess i have written the logic its working fine. but i am unable to represent it properly. you can see in the following link above the footer. <a href="http://www.playtoongames.com/play1" rel="nofollow">http://www.playtoongames.com/play1</a>...</p>
  
  <p>code:</p>
  
  <pre><code>&lt;?php
  $gameQuery = mysql_query ("SELECT name, LEFT(name, 1) AS first_char FROM games WHERE UPPER(name) BETWEEN 'A' AND 'Z' OR name BETWEEN '0' AND '9' ORDER BY name");
  $current_char = '';
     while ($gameRow = mysql_fetch_assoc($gameQuery)){
       if ($_SESSION['lang'] == 'fr'){
           $description = $gameRow['description_fr'];
       }else{
     $description = $gameRow['description'];
   }
  ?&gt;
  
  &lt;div style='float:left' title="&lt;img src='&lt;?php echo $gameRow['sitePath'];?&gt;games/images/&lt;?php echo $gameRow['img_100x75'];?&gt;' width='230' height='112' class='thumb' alt='&lt;?php echo $gameRow['name'];?&gt;'/&gt;" class='tooltip'&gt;
  
                       &lt;ul&gt;
                       &lt;li&gt;
       &lt;a href='&lt;?php echo $gameRow['sitePath'];?&gt;play/&lt;?php echo str_replace(' ','_',$gameRow['name']);?&gt;'&gt;&lt;?php echo $gameRow['name'];?&gt;&lt;/a&gt;
                       &lt;/li&gt; 
                        &lt;/ul&gt;
  &lt;/div&gt;
  </code></pre>
  
  <p>can anybody look into this...</p>
  
  <p>Regards,
  sam.</p>