Select WHERE problem

Where am I going wrong in this?

<?php 
$Keyword = $_GET["keyword"];
$sql = "Select * FROM address WHERE $Keyword LIKE 'john'";
?>

Code (markup):

 

i'm not sure exactly how to do it, but from using MS Access, shouldn't it be WHERE $Keyword = LIKE 'john' ?

 

 
$name="john";
$sql = "Select * FROM address WHERE $Keyword LIKE '" . $name ."'"; 

Code (markup):

 

$name = "john";
$sql = "Select * FROM tblname WHERE $keyword LIKE '%". $name ."%'";

 

I guess input filtering isn't trendy anymore.

 

Where do I go wrong

line 56 is:

	$query = odbc_exec($odbc, $sql) or die (odbc_errormsg());

PHP:

below.

<?php 
	
	require_once('odbc.php');

// Let's see what user wants to search for today :)
    $Keyword = $_GET["keyword"]; //Trim(Request.QueryString("Keyword"))
    $Keywordb = $_GET["keywordb"]; //Trim(Request.QueryString("Keywordb"))
    $Keywordc = $_GET["keywordc"]; //Trim(Request.QueryString("Keywordc"))
    $Keywordd = $_GET["keywordd"]; //Trim(Request.QueryString("Keywordd"))
    $Keyworde = $_GET["keyworde"]; //Trim(Request.QueryString("Keyworde"))
    $Keywordf = $_GET["keywordf"]; //Request.QueryString("Keywordf")
    $Keywordg = $_GET["keywordg"]; //Trim(Request.QueryString("Keywordg"))
    $spoke = $_GET["spoke"]; //Request.Querystring("spoke")
    $number = $_GET["number"]; //Request.QueryString("number")
    $id = $_GET["id"]; //Request.QueryString("id")
    $Keywordh = $_GET["keywordh"]; //Trim(Request.QueryString("Keywordh"))


echo $Keyword;
	$sql = "Select * FROM book WHERE";
		
if ($Keyword != "")
	{
		echo '<b>'.$Keyword.'</b>';
		$myarray = split($Keyword, '+');
		echo '<b>'.$myarray.'</b>';
		$whereclause=" text_data LIKE '%".$myarray[0]."%'";
		
		for ($i=1; $i<=ubound; $i++)
			{
			$whereclause = $whereclause." AND text_data LIKE '%".$myarray[$i]."%'";
			}
  
		$sql = $sql.$whereclause;		
		
	}
	 
	echo '<b>'.$sql.'</b>';
	$query = odbc_exec($odbc, $sql) or die (odbc_errormsg());
	while($row = odbc_fetch_array($query))
		{
			echo '<option value="'.$row['letter_id'].'"> Spoke '.$row['letter_id'].'</option>'."\n"; 
		}
	odbc_close($odbc);
?>

PHP: