mysql error

[roeyhaim]

Hello,

can anybody tell me whats wrong with my code:

 

function check_login($uname, $pwd){
            $sql = "SELECT * FROM users WHERE uname=$uname";
            $result = mysql_query($sql) or die('Error, Load query failed: ' . mysql_error());
            $data = array();
            while($row=mysql_fetch_assoc($result)){
                $data[] = $row;
            }
        return $data;
}

$chk = check_login("test", "test1");
foreach($chk as $row){
        echo $row['uname'];
        echo " = ";
        echo $row['pass'];
        echo "<BR>";
    }

 

when i run this i get: 

Error, Load query failed: Unknown column 'test' in 'where clause'

[mikosiko]

wow....  this is not clear enough?  :-\

Error, Load query failed: Unknown column 'test' in 'where clause'

 

hint

uname=$uname

 

[roeyhaim]

Not really.  as i see on W3school:

SELECT column_name(s)
FROM table_name
WHERE column_name operator value 

example:
$result = mysql_query("SELECT * FROM Persons
WHERE FirstName='Peter'");

 

and this is exactly what i did.

the "uname" is the column and the $uname is the value.

 

[ras1986]

is $uname containing string value? if yes, try '$uname'... and also try putting backslashes to your column name `uname`....

i faced this error before and this fixed it....

[mikosiko]

Not really.  as i see on W3school:

.....

WHERE FirstName='Peter'");

 

and this is exactly what i did.

the "uname" is the column and the $uname is the value.

 

and what is the difference between

FirstName = 'Peter'

 

and

uname = $uname

 

[roeyhaim]

Thank you ras1986

it's work

[Pikachu2000]

is $uname containing string value? if yes, try '$uname'... and also try putting backslashes to your column name `uname`....

i faced this error before and this fixed it....

 

You mean backticks, not backslashes . . .

[ras1986]

sorry.. my bad....

[PFMaBiSmAd]

Also, back-ticks are mysql specific and should be avoided whenever possible.