THERES NOTHING WRONG WITH MY QUERY!!!!
why am i getting this error???
im so confused...
says line 93 but ive even replaced the variable with the real table name as part of the query string with no change in the error
Code:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html lang="en-US" xml:lang="en-US" xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Admin</title>
<link rel="stylesheet" type="text/css" href="/css/mw3dailymedia.css?a=<%=now%>" />
</head>
<body>
<script>(function(d, s, id) {
  var js, fjs = d.getElementsByTagName(s)[0];
  if (d.getElementById(id)) return;
  js = d.createElement(s); js.id = id;
  js.src = "//connect.facebook.net/en_US/all.js#xfbml=1";
  fjs.parentNode.insertBefore(js, fjs);
}(document, 'script', 'facebook-jssdk'));</script>
<img src="background.jpg" alt="background image" id="fixed" />

<div id="login">
<div class="fb-like" data-href="http://www.youtube.com/watch?v=mA2aTK2JQRc" data-send="true" data-width="120" data-show-faces="true"></div>
<br/>
<p>
<a href="http://www.youtube.com/subscription_center?add_user=williebeemin22" target="_blank"><img src="/subscribe.gif" border="0" alt="Photobucket"></a>
<br/>
<a href="/">home</a>
<br/>
<a href="/">login/register</a>
</p>
</div>
<div id="content">
<div id="admin">
<?php

	// redifine variables for different server
	require_once "textprep.php";  
	require_once "mysqlconfig.php";  
	
	// connect to database
	$connection = mysql_connect(DB_SERVER,DB_USER,DB_PASS); 
	if (!$connection)
	{
		die("Database connection failed: " . mysql_error());
	}
 
	// select database
	$db_select = mysql_select_db(DB_NAME,$connection);
	if (!$db_select)
	{
		die("Database selection failed: " . mysql_error());
	}

	//user's header
	
echo  "<img src=\"2.gif\" alt=\"emblem\" />";

//content
// sections EDIT, TWIXTOR, GAMEPLAY, GLITCHES/CHEATS, MONTAGES, SHORT CLIPS/FAILS, NEWS, TOP3, TH3RRC
mysqlTableAdmin("edit");
mysqlTableAdmin("twixtor");
mysqlTableAdmin("gameplay");
mysqlTableAdmin("glitch");
mysqlTableAdmin("montage");
mysqlTableAdmin("short");
mysqlTableAdmin("news");
mysqlTableAdmin("top3");
mysqlTableAdmin("th3rrc");

//functions
function mysqlTableAdmin($mysqlTableName)
{
	echo "
<h1>add to ".$mysqlTableName."</h1>
 <form action=\"".$mysqlTableName."/post.php\" method=\"post\">
  <label for=\"title\">Title</label>
  <input type=\"text\" name=\"title\" id=\"title\" />
  <br />
  <label for=\"text\">Description</label>
  <input type=\"text\" name=\"text\" id=\"text\" />
  <br />
  <label for=\"link\">Youtube Code</label>
  <input type=\"text\" name=\"link\" id=\"link\" />
  <br />
  <input type=\"submit\" name=\"submit\" id=\"submit\" value=\"Submit\" />
 </form>
 <img src=\"2.gif\" alt=\"emblem\" />
<h1>rearrange or delete ".$mysqlTableName."</h1>
<form action=\"".$mysqlTableName."/swaper.php\" method=\"post\">
  <label for=\"text\">Text</label>
  <br />
  <textarea rows=\"10\" cols=\"50\" name=\"text\" id=\"text\">
  ";
  
 
	// get table
	$result = mysql_query("SELECT * FROM ".$mysqlTableName, $connection);
	if (!$result)
	{
		die("Database query failed: " . mysql_error());
	}
	$i=0;
	
	// display table
	while ($row = mysql_fetch_array($result)) 
	{
		$rank[$i]=$row["rank"];
		$name[$i]=$row["title"];
		$i++;
	}
	
	//make a list of ranks to check for
	for($j=0;$j<$i;$j++)
	{
		$rankList[$j]=$j+1;
	}	
	
	//check the list
	for($j=0;$j<$i;$j++)
	{
		for($k=0;$k<$i;$k++)
		{
			if($rankList[$j]==$rank[$k])
			{
				echo $rank[$k]." ".$name[$k];
				if ($j<($i-1))
				{
					echo "\n";
				}
			}
		}
	}
	echo "
	</textarea>
  <br />
  <input type=\"submit\" name=\"submit\" id=\"submit\" value=\"Submit\" />
 </form>

 <img src=\"2.gif\" alt=\"emblem\" />
 ";
 }
?>
 </div> 
 </div> 
</body>
</html>