Mysql supplied arguemtn is not a vaild mysql result resource

[pinehead18]

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

and this is my code..

<?php
$name = $HTTP_COOKIE_VARS['user'];


    $con = mysql_connect("localhost","","") or die(mysql_error());
    $db = mysql_select_db("pinehead",$con) or die(mysql_error());
    $sql = "SELECT * FROM users where $name='$uname'"; 
       $result =  mysql_query($sql);
    $row =  mysql_fetch_array($result);

    $email = $row['email'];

?>

Any ideas?

THank you

[drag0n]

change:

$result =  mysql_query($sql); 
$row =  mysql_fetch_array($result); 

to

$result =  mysql_query($sql) or die(mysql_error()); 
$row =  mysql_fetch_array($result) or die(mysql_error());

Hopefully that way it will tell you whats bringing the problem such as unknown field, etc...

[pinehead18]

Unknown column 'pinehead' in 'where clause'

However.. I checked the db.. and it has pinehead in their.. OR else it would not of even logged pinehead in..

Ideas?

[drag0n]

I think it is ur $name/$uname problem, it didnt find $name which Im assuming is pinehead,you do know $name is referring to a column in the db meaning like a field... so i dont knwo if you understand that... because I dont see why u have to name the column dynamically?

[pinehead18]

yeah i just noticed that.. It fixed the prob.. THank you
Anthony

[drag0n]

yep, mark the thread resolved 🙂