0) { $test = mysql_query("SELECT * FROM nameviews WHERE nameId='$nameId'"); if(mysql_numrows($test) == 0) { $result = mysql_query("INSERT INTO nameviews (nameId,totalViews)"."VALUES ('$nameId', '1')"); } else { $result = mysql_query("SELECT totalViews FROM nameviews WHERE nameId='$nameId' LIMIT 1"); $viewResults = mysql_fetch_array($result); $newViewResult = $viewResults["totalViews"]; if($newViewResult > 1000) { $newViewResult = 1; } else { $newViewResult = $newViewResult + 1; } $result = mysql_query("UPDATE nameviews SET totalViews='$newViewResult' WHERE nameId='$nameId'"); } } $nameId = $_GET['nameId']; $result = mysql_query("SELECT * FROM thenames LEFT JOIN namecats ON thenames.catId = namecats.catId LEFT JOIN nameviews ON thenames.nameId = nameviews.nameId LEFT JOIN ratings ON thenames.nameId = ratings.nameId WHERE thenames.nameId='$nameId' AND thenames.nameLive='1'"); $nameStuff = mysql_fetch_array($result); $numRows = mysql_num_rows($result); if($numRows == 0) { header("Location: http://www.nameadder.com"); exit; } $getNameLength = strlen($nameStuff['theName']); $nameShort = substr($nameStuff['theName'], 0, 35); if($getNameLength > 35) { $nameShort = $nameShort .'...'; } ?> <?php echo $nameShort;?> - <?php echo $nameStuff['catName'];?> MSN Names - Name Adder
msn name #
The Name:
Category: MSN Names
Views:
Rating:
Rate Name:

Your rating has been counted!

'; } if($alreadyVoted) { echo '
You can only vote once per name!

'; } ?>