 |
|
Code (PHP)
<?php
$host = "localhost";
$database = "db";
$username = "root";
$password = "1234";
$connect = mysql_connect($host, $username, $password) or trigger_error(mysql_error(),E_USER_ERROR);
mysql_select_db($database, $connect_mk);
$sql = "SELECT name,surname,salary,month_val FROM salary LIMIT 1";
$result = mysql_query( $sql, $connect);
$fd = mysql_fetch_array($result);
?>
<select name="select_month">
<option value="">- เลือกเดือน -</option>
<?php
mysql_select_db($database, $connect_mk);
$sql = "SELECT month_val,month_label FROM t_month ORDER BY month_val ASC";
$result = mysql_query( $sql, $connect);
while ($rs = mysql_fetch_array($result))
{
if ($rs['month_val'] == $fd['month_val'])
echo "<option value=\"$rs[month_val]\" selected>$rs[month_label]</option>\n";
else
echo "<option value=\"$rs[month_val]\">$rs[month_label]</option>\n";
}
?>
</select>
|
 |
 |
 |
 |
| Date :
2011-03-03 15:01:12 |
By :
avsqlz |
|
 |
 |
 |
 |
|
|
 |
