How to make, that at search as a result of selection there were only two columns from the table, for example, 'name' and 'lastname'? I have this:

$sql=mysql_query("SELECT * FROM 'members' WHERE 'lastname' LIKE '%{$user_get}%' ");

    1 answer 1

     $sql=mysql_query("SELECT `name`, `lastname` FROM `members` WHERE `lastname` LIKE '%{$user_get}%' ");

    Focus on oblique quotes.