Video on Demand
". $keyword ." ตามคำสำคัญ ";
$i = 0;
$condition1 = " "; //for create where clause in sql query
$condition2 = " ";
while ($i < count($exp)) {
if ($i==0) {
$condition1 = $condition1." (title LIKE '%".$exp[$i]."%') ";
$condition2 = $condition2." (subtitle LIKE '%".$exp[$i]."%') ";
} else {
// if ($i < count($exp)-1) {
$condition1 = $condition1." AND (title LIKE '%".$exp[$i]."%') ";
$condition2 = $condition2." AND (subtitle LIKE '%".$exp[$i]."%') ";
}
$i++;
}
$query = " SELECT link, title, subtitle, series FROM vdo WHERE ($condition1 OR $condition2) ";
// $query = " SELECT link, title, subtitle FROM vdo WHERE ((title LIKE '%$keyword%') OR (subtitle LIKE '%$keyword%')) ORDER BY title";
// echo "query=".$query;
}
//------------
if ($select_from == 'alphabet')
{
echo "ค้นหาจาก: ". $keyword ." ลำดับอักษร ";
$query = " SELECT link, title, subtitle, series FROM vdo WHERE (title LIKE '$keyword%') ";
}
}
}break;
case 2:
{
$letter = $_POST["letter"];
echo "แสดงรายการตามลำดับตัวอักษรที่เลือก: ". $letter ." ";
$query = " SELECT link, title, subtitle, series, letter FROM vdo WHERE letter ='$letter' ";
}break;
case 3:
{
$series= $_GET["series"];
echo "แสดงรายการตาม series ที่เลือก: ". $series ." ";
$query = " SELECT link, title, subtitle, series FROM vdo WHERE series LIKE '%$series%' ";
// echo $query;
}break;
default:
{
echo "แสดงรายการตามหมวดหมู่ที่เลือก: ". $catname ." ";
$query = " SELECT link, title, subtitle, series, catid FROM vdo WHERE catid ='$catid' ";
}break;
}
?>
".mysql_num_rows($result). " รายการ
|
||||||