Select Group :
all
a-z
¡
¢
¤
¦
§
¨
©
ª
«
¬
¯
®
°
±
²
³
´
µ
¶
·
¸
¹
º
»
¼
½
¾
¿
À
Á
Â
Ã
Å
Ç
Ä
È
É
Ê
Ë
Ì
Í
Î
";
$i=0;
if($leter == "" or $leter == "all")
$query = "select id,title,url,filepwd from j_th_free order by (if(ascii(left(title,1))>206, ascii(substring(title,2,1)),ascii(left(title,1)))) ";
//$query = "select title,url,filepwd from j_th_free order by ascii(left(title,1)) ";
elseif($leter=="eng")
$query = "select id,title,url,filepwd from j_th_free where ascii(left(title,1)) between 65 and 90 or ascii(left(title,1)) between 97 and 122 order by title";
else
$query = "select id,title,url,filepwd from j_th_free where ascii(left(title,1))=ascii('".$leter."') or
(if(ascii(left(title,1))>206, ascii(substring(title,2,1))=ascii('".$leter."'),'')) order by title ";
//echo "aaaaaaaa : ".$query."
";
$result = mysql_query($query);
$_SESSION['url_j_thai'] = "http://".$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'];
echo " ";
echo " ";
echo " No. | ";
echo " Title | ";
echo " url Problem | ";
echo " Password | ";
echo " ";
if(mysql_num_rows($result)==0){
echo " ";
echo " | ";
echo " äÁèÁÕ¢éÍÁÙÅã¹ËÁÇ´¹Õé. | ";
echo " | ";
echo " ";
}
else{
while ($row = mysql_fetch_array($result))
{
$i = $i+1;
$chk_id3 = $row['id'];
echo " ";
echo " $i. | ";
// echo " | ";
}
}
echo " ";
mysql_close();
?>
|