01.
<?php
02.
$objConnect
= mysql_connect(
"localhost"
,
"root"
,
""
)
or
die
(
"Error Connect to Database"
);
03.
$objDB
= mysql_select_db(
"testdb"
);
04.
$strSQL
=
"select * from tb_name where year_name='"
.
$_post
['ddlyear
']."'
or
05.
(
'".$_post['
ddlyear
']."'
=
''
and
year_name = (
06.
select top 1 year_name from tb_year where year_status =
'enable'
order by year_name desc
07.
))";
08.
$objQuery
= mysql_query(
$strSQL
)
or
die
(
"Error Query ["
.
$strSQL
.
"]"
);
09.
?>