Location: PHPKode > scripts > Free PHP Lyric Plug-n-Play Website > free-php-lyric-plug-n-play-website/a.php
<?php
/************* Lyrics 1.0 *****************************/
/*
Released by AwesomePHP.com, under the GPL License, a
copy of it should be attached to the zip file, or
you can view it on http://AwesomePHP.com/gpl.txt
*/
/************* Lyrics 1.0 *****************************/



$artist_title = mysql_escape_string(urldecode($QUERY[1]));
$get_list = "SELECT * FROM `lyrics_lyriclist` WHERE `artist_title`='$artist_title' ORDER BY `lyric_title` ASC";
$get_lyr = mysql_query($get_list);
$items_count = mysql_num_rows($get_lyr);

$PAGE = 'A';
?>
<table width="<?=$PAGE_WIDTH;?>"  border="0" style="border:1px solid #FFDBCA;" align="center" cellpadding="5" cellspacing="0">
  <tr>
    <td width="50%" colspan="2"><div align="center"><font color="#999999" size="4">Please select a song: [ 
      <?=number_format($items_count);?> Total ]</font></div>      </td>
  </tr>
  <tr>
    <td colspan="2"><div align="center">
      <table width="100%"  border="0" cellspacing="0" cellpadding="2">
            <tr>
              <td><ul>
			  <?php
			  while($each = mysql_fetch_assoc($get_lyr)){?>
                <li><strong><a href="<?=$SITE_URL;?>?V*<?=urlencode($each['lyric_title']);?>"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><?=$each['lyric_title'];?></font></a></strong></li>
				<?php } ?>
              </ul></td>
          </tr>
        </table>
	  <hr style="width:80%;border:1px solid green;">
    </div></td>
  </tr>
</table>
Return current item: Free PHP Lyric Plug-n-Play Website