search function error

[pinehead18]

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in search.php on line 27
that is my error

if(isset($_POST["submit"])) { //if submit button has been pressed
    //take variable of form
    $keys = $_POST['keys'];
    $by = $_POST['by'];
    $selec = "select * from users where '$by' like %$keys%";
    $sql = mysql_query($selec);
    //show the results
    echo "Results :<br>";
    $i=1;
    while($row = mysql_fetch_array($sql)) {
        $name = $row['name'];
        $address = $row['location'];
        $city = $row['user'];
        $zip_post = $row['zip_postal'];
        $telp = $row['telp'];
        echo "<font color=#00FFFF face=verdana size=2>";
        echo "$i. $name $address $city $zip_post $telp<br>";
        echo "</font>";
        $i++;
    }
    if(!$sql) {
        ?><script language=’JavaScript’>alert(‘No record found’);     </script><?
    }
}
?>

Any ideas?

Thank you

[drawmack]

keys needs to be in quotes

[pinehead18]

It still gives me the same error. Any other ideas?

[LordShryku]

$selec = "SELECT * 
          FROM users 
          WHERE ".$by." LIKE '%".$keys."%'";

Try that

[pinehead18]

Still giving the mysql_fetch_array error...?

[pinehead18]

i added mysql_error and it says no database seleected.. But, i users is a real db..
any suggestions?

[Moonglobe]

you haven't called [man]mysql_select_db/man before you run your query.