01.<form name="frmSearch" method="post" action="<?=$_SERVER['SCRIPT_NAME'];?>">
02. <table width="599" border="1">
03. <tr>
04. <th height="35">ค้นหาจากราคา
05.<select name="keyword" >
06.<option value="<?echo "$keyword"; ?>"><?echo "$keyword"; ?></option>
07.<option value="100000 AND 500000">100000-500000</option>
08.<option value="500001 AND 1000000">500001-1000000</option>
09.<option value="1000001 AND 3000000">1000001-3000000</option>
10.<option value="3000001 AND 5000000">3000001-5000000</option>
11.<option value="5000001 AND 10000000">5000001-10000000</option>
12.<option value="10000001 AND 50000000">5000001-500000000</option>
13.</select>
14. <input type="submit" value="Search"></th>
15. </tr>
16. </table>
17.</form>
18.
19.<?
20.
21.
22.include "include/Conn.php";
23.$objDB = mysql_select_db("$db");
24.
25.$strSQL = "SELECT * FROM topic WHERE price between ".$_POST["keyword"]."";
26.
27.$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
28. ?>
29.
30. <?
31. while($row_show = mysql_fetch_array($objQuery))
32. {
33.?>
34.
35.
36.<table width="100%">
37. <tr>
38. <td width="7%"><img src="item/<?=$row_show[image]?>"width='80' height='80' border='1'></td>
39. <td width="93%"><table width="100%">
40. <tr>
41. <td align="left"><a href="detail.php?id=<?=$row_show[id]?>"><?=$row_show[topic]?></a></td>
42. </tr>
43. <tr>
44. <td>จังหวัด : <?=$row_show[province]?> </td>
45. </tr>
46. <tr>
47. <td>ราคา : <?=$row_show[price]?> </td>
48. </tr>
49. </table>
50.
51. </td>
52. </tr>
53.</table>
54.<hr align=left width=100% color=red>
55.
56. <?
57.
58.}
59.
60.?>
Quote:
