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

$lyric_title = mysql_escape_string(urldecode($QUERY[1]));

$get_info = mysql_fetch_assoc(mysql_query("SELECT * FROM `lyrics_lyriclist` WHERE `lyric_title`='$lyric_title'"));

$update = mysql_query("UPDATE `lyrics_lyriclist` SET `lyric_views`=lyric_views+1 WHERE `lyric_title`='$lyric_title'");
?>
<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"><?=$get_info['lyric_title'];?> </font></div>      </td>
  </tr>
  <tr>
    <td colspan="2"><div align="center">
      <table width="100%"  border="0" cellspacing="0" cellpadding="2">
            <tr>
              <td style="border:1px solid #FFDBCA;">
			  <div align="center">
			  <font size="2" face="Verdana, Arial, Helvetica, sans-serif"><?php
			echo $get_info['lyric_text'];
			 ?></font>
			 </div></td>
            </tr>
            <tr>
              <td><div align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><?=$get_info['lyric_views'];?> Reads </font></div></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