01. <select name="select">
02. <option value="Option 1" selected>เลือกปี</option>
03. <option value="Option 2">2016</option>
04. <option value="Option 3">2017</option>
05. <option value="Option 4">2018</option>
06. </select>
07. </p>
08.
09. <?php
10. if($_GET["contactid"] != "")
11. {
12.$objConnect= mysql_connect("localhost","crm.user","zubb*2017") or die("Error: " . mysql_error($objConnect));
13.$objDB = mysql_select_db("db_vtigercrm");
14.$strSQL = "SELECT * from vtiger_purchase_history WHERE contactid LIKE '%".$_GET["contactid"]."%' order by Amount_purchase ASC limit 1";
15.
16.$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
17.?>
18.<?php
19.while($objResult = mysql_fetch_array($objQuery))
20.{
21.?>
22.
23. <br><center>
24.<h4><font color="#0099FF"> รายการ : </font> <?php echo $objResult["List_purchase"];?><br><br>
25.<font color="#0099FF">จำนวน : </font> <?php echo $objResult["Amount_purchase"];?><br><br></h4></center>
26.
27.
28.<?php
29.}
30.?>
31.<?php
32.mysql_close($objConnect);
33.}
34.?>
