Location: PHPKode > scripts > Free PHP Lyric Plug-n-Play Website > free-php-lyric-plug-n-play-website/main.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 *****************************/

$get_cats = mysql_query("SELECT * FROM `lyrics_artists`");

?>
<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 an artist: </font></div>      </td>
  </tr>
  <tr>
    <td colspan="2"><div align="center">
      <table width="100%"  border="0" cellspacing="0" cellpadding="6">
	  <?php	  	 	  
	  $x = 1;
	  while($each = mysql_fetch_assoc($get_cats)){
	  	if($x == 1){ echo '<tr>';}
		echo '<td><a href="'.$SITE_URL.'?A*'.urldecode($each['artist_title']).'">'.$each['artist_title'].'</a></td>';
		if($x == $table_cloumns){ echo '</tr>';$x=0;}
		$x++;
	  }
	  if($x != 1){
		 for($x=$x;$x<=3;$x++){ echo '<td>&nbsp;</td>';}
		 echo '</tr>';
	  }
	  ?>
	  </table>
    </div></td>
  </tr>
</table>
Return current item: Free PHP Lyric Plug-n-Play Website