php - invalid query: Unknown certain column in 'where clause'

Question

I am trying to create update function for logged user but I get this kind of error:

invalid query: Unknown column 'johnny' in 'where clause'

can someone help me notify the problem?

<?php
$result = mysql_query("select * from admin where username_admin =".$_SESSION['username_admin']);

if($result) { 
while($row = mysql_fetch_array($result)) {
$_SESSION["username_admin"] = $row['id_admin'];                             

    ?>
   <li>   <a tabindex="-1" href="edit-user.php?id=<?php echo $row['id_admin']; ?>">Edit Account</a>
   </li>

        <?php
        }
        }
        else {
        echo 'invalid query: '.mysql_error(). "\n";

        }

        ?>

score 0 · Accepted Answer · answered Jun 03 '17 at 08:10

0

For sending string to sql, you must wrap it by single quotes:

<?php
$result = mysql_query("select * from admin where `username_admin` ='".$_SESSION['username_admin']."'");

if($result) { 
    while($row = mysql_fetch_array($result)) {
        $_SESSION["username_admin"] = $row['id_admin'];                             

        ?>
        <li>   <a tabindex="-1" href="edit-user.php?id=<?php echo $row['id_admin']; ?>">Edit Account</a>
        </li>

        <?php
    }
}
else {
    echo 'invalid query: '.mysql_error(). "\n";

}

?>

answered Jun 03 '17 at 08:10

Mohammad Hamedani

3,304
3
10
22

It doesn't help OP when you give answers using old deprecated API's – Rotimi Jun 03 '17 at 08:25
yeeaaah.. it works.. thanks.. jazakallah – awang Jun 03 '17 at 08:28

php - invalid query: Unknown certain column in 'where clause'

1 Answers1