แนะแนวทางให้หน่อยคับ การค้นหาจำนวนระหว่าง xxx-xxxx

$sql="SELECT * FROM customer WHERE Budget BETWEEN '1000000' AND '3000000'";
$query=mysql_query($sql);

<form name="frmSearch" method="post" action=<?=$_SERVER['SCRIPT_NAME'];?>>
  <table width="599" border="1">
    <tr>
      <th height="35">ค้นหาจากราคา
<select name="keyword" >
<option value="<?echo "$keyword"; ?>"><?echo "$keyword"; ?></option>
<option value="100000 AND 500000">100000-500000</option>
<option value="500001 AND 1000000">500001-1000000</option>
<option value="1000001 AND 3000000">1000001-3000000</option>
<option value="3000001 AND  5000000">3000001-5000000</option>
<option value="5000001 AND 10000000">5000001-10000000</option>
<option value="10000001 AND 50000000">5000001-500000000</option>
</select>
      <input type="submit" value="Search"></th>
    </tr>
  </table>
</form>
<?
include "config.php"; 

$objDB = mysql_select_db("$dbname");

$strSQL = "SELECT * FROM topic WHERE price between $keyword ";

$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
	?>
	
	<?
	while($row_show = mysql_fetch_array($objQuery))
	{
?>


<table width="100%">
  <tr>
    <td width="7%"><img src="item/<?=$row_show[image]?>"width='80' height='80' border='1'></td>
    <td width="93%"><table width="100%">
      <tr>
        <td align="left"><a href="detail.php?id=<?=$row_show[id]?>"><?=$row_show[topic]?></a></td>
      </tr>
      <tr>
        <td>จังหวัด : <?=$row_show[province]?> </td>
      </tr>
      <tr>
        <td>ราคา :  <?=$row_show[price]?> </td>
      </tr>
    </table>
  
    </td>
  </tr>
</table>
<hr align=left width=100% color=red>

  <?
}
	
?>

$strSQL = "SELECT * FROM topic WHERE price between 100000 AND 500000";

$strSQL = "SELECT * FROM topic WHERE price between '".$_POST["keyword"]."'";

$_POST["keyword"]

<form name="frmSearch" method="post" action="<?=$_SERVER['SCRIPT_NAME'];?>">
  <table width="599" border="1">
    <tr>
      <th height="35">ค้นหาจากราคา
<select name="keyword" >
<option value="<?echo "$keyword"; ?>"><?echo "$keyword"; ?></option>
<option value="100000 AND 500000">100000-500000</option>
<option value="500001 AND 1000000">500001-1000000</option>
<option value="1000001 AND 3000000">1000001-3000000</option>
<option value="3000001 AND  5000000">3000001-5000000</option>
<option value="5000001 AND 10000000">5000001-10000000</option>
<option value="10000001 AND 50000000">5000001-500000000</option>
</select>
      <input type="submit" value="Search"></th>
    </tr>
  </table>
</form>

<?


include "include/Conn.php"; 
$objDB = mysql_select_db("$db");

$strSQL = "SELECT * FROM topic WHERE price between ".$_POST["keyword"]."";

$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
	?>
	
	<?
	while($row_show = mysql_fetch_array($objQuery))
	{
?>


<table width="100%">
  <tr>
    <td width="7%"><img src="item/<?=$row_show[image]?>"width='80' height='80' border='1'></td>
    <td width="93%"><table width="100%">
      <tr>
        <td align="left"><a href="detail.php?id=<?=$row_show[id]?>"><?=$row_show[topic]?></a></td>
      </tr>
      <tr>
        <td>จังหวัด : <?=$row_show[province]?> </td>
      </tr>
      <tr>
        <td>ราคา :  <?=$row_show[price]?> </td>
      </tr>
    </table>
  
    </td>
  </tr>
</table>
<hr align=left width=100% color=red>

  <?

}
	
?>