what have i done wrong now

[Evan_Morgan]

i dunno what ive done wrong now but it doesnt like it, it says that mysql fetch row is not a valid resourse or something, sed the same about mysql fetch array when i used that.

<?

session_start();

if(!$_SESSION['username'])
{
include ('adminlogin.php');
exit();
}

$site = $_GET['site'];

$selection = mysql_query("SELECT * from sites WHERE id='$site'");

$poo = mysql_fetch_row( $selection );

echo "<font face='tahoma' size='2'>";
echo "Change referral link <input type='text' name='ref' value='$poo[0]'>";

any ideas?

please help

Evan

[LordShryku]

Change this line to have it tell you what the error is...

$selection = mysql_query("SELECT * from sites WHERE id='$site'");

// to this 

$sql = "SELECT * from sites WHERE id='$site'";
$selection = mysql_query($sql) or die(mysql_error());

[Evan_Morgan]

o my god im so stupid, i didnt include my dbconnect file so it didnt have anything to connect to 😃😃😃