" ;
$sql = "SELECT * FROM pati_meeka WHERE hurigana LIKE 'あ%' OR hurigana LIKE 'い%'
OR hurigana LIKE 'う%' OR hurigana LIKE 'え%' OR hurigana LIKE 'お%' ORDER BY hurigana " ;
$rst = mysql_query($sql) ;
while ($col = mysql_fetch_array($rst)) {
if($cn%4==1){
$agyou .= "
" ;
}
$agyou .= "| $col[meekamei] | " ;
if($cn%4==0){
$agyou .= "
" ;
}
$cn ++ ;
}
$cn -- ;
if($cn%4==1){
$agyou .= "
| | | " ;
}
if($cn%4==2){
$agyou .= "
| | " ;
}
if($cn%4==3){
$agyou .= "
| " ;
}
$agyou .= "" ;
?>
" ;
$sql = "SELECT * FROM pati_meeka WHERE hurigana LIKE 'か%' OR hurigana LIKE 'き%'
OR hurigana LIKE 'く%' OR hurigana LIKE 'け%' OR hurigana LIKE 'こ%'
OR hurigana LIKE 'が%' OR hurigana LIKE 'ぎ%' OR hurigana LIKE 'ぐ%'
OR hurigana LIKE 'げ%' OR hurigana LIKE 'ご%'
ORDER BY hurigana " ;
$rst = mysql_query($sql) ;
while ($col = mysql_fetch_array($rst)) {
if($cn%4==1){
$kagyou .= "
" ;
}
$kagyou .= "| $col[meekamei] | " ;
if($cn%4==0){
$kagyou .= "
" ;
}
$cn ++ ;
}
$cn -- ;
if($cn%4==1){
$kagyou .= "
| | | " ;
}
if($cn%4==2){
$kagyou .= "
| | " ;
}
if($cn%4==3){
$kagyou .= "
| " ;
}
$kagyou .= "" ;
?>
" ;
$sql = "SELECT * FROM pati_meeka WHERE hurigana LIKE 'さ%' OR hurigana LIKE 'し%'
OR hurigana LIKE 'す%' OR hurigana LIKE 'せ%' OR hurigana LIKE 'そ%'
OR hurigana LIKE 'ざ%' OR hurigana LIKE 'じ%'
OR hurigana LIKE 'ず%' OR hurigana LIKE 'ぜ%' OR hurigana LIKE 'ぞ%'
ORDER BY hurigana " ;
$rst = mysql_query($sql) ;
while ($col = mysql_fetch_array($rst)) {
if($cn%4==1){
$sagyou .= "
" ;
}
$sagyou .= "| $col[meekamei] | " ;
if($cn%4==0){
$sagyou .= "
" ;
}
$cn ++ ;
}
$cn -- ;
if($cn%4==1){
$sagyou .= "
| | | " ;
}
if($cn%4==2){
$sagyou .= "
| | " ;
}
if($cn%4==3){
$sagyou .= "
| " ;
}
$sagyou .= "" ;
?>
" ;
$sql = "SELECT * FROM pati_meeka WHERE hurigana LIKE 'た%' OR hurigana LIKE 'ち%'
OR hurigana LIKE 'つ%' OR hurigana LIKE 'て%' OR hurigana LIKE 'と%'
OR hurigana LIKE 'だ%' OR hurigana LIKE 'ぢ%'
OR hurigana LIKE 'づ%' OR hurigana LIKE 'で%' OR hurigana LIKE 'ど%'
ORDER BY hurigana " ;
$rst = mysql_query($sql) ;
while ($col = mysql_fetch_array($rst)) {
if($cn%4==1){
$tagyou .= "
" ;
}
$tagyou .= "| $col[meekamei] | " ;
if($cn%4==0){
$tagyou .= "
" ;
}
$cn ++ ;
}
$cn -- ;
if($cn%4==1){
$tagyou .= "
| | | " ;
}
if($cn%4==2){
$tagyou .= "
| | " ;
}
if($cn%4==3){
$tagyou .= "
| " ;
}
$tagyou .= "" ;
?>
" ;
$sql = "SELECT * FROM pati_meeka WHERE hurigana LIKE 'な%' OR hurigana LIKE 'に%'
OR hurigana LIKE 'ぬ%' OR hurigana LIKE 'ね%' OR hurigana LIKE 'の%' ORDER BY hurigana " ;
$rst = mysql_query($sql) ;
while ($col = mysql_fetch_array($rst)) {
if($cn%4==1){
$nagyou .= "
" ;
}
$nagyou .= "| $col[meekamei] | " ;
if($cn%4==0){
$nagyou .= "
" ;
}
$cn ++ ;
}
$cn -- ;
if($cn%4==1){
$nagyou .= "
| | | " ;
}
if($cn%4==2){
$nagyou .= "
| | " ;
}
if($cn%4==3){
$nagyou .= "
| " ;
}
$nagyou .= "" ;
?>
" ;
$sql = "SELECT * FROM pati_meeka WHERE hurigana LIKE 'は%' OR hurigana LIKE 'ひ%'
OR hurigana LIKE 'ふ%' OR hurigana LIKE 'へ%' OR hurigana LIKE 'ほ%'
OR hurigana LIKE 'ば%' OR hurigana LIKE 'び%'
OR hurigana LIKE 'ぶ%' OR hurigana LIKE 'べ%' OR hurigana LIKE 'ぼ%'
OR hurigana LIKE 'ぱ%' OR hurigana LIKE 'ぴ%'
OR hurigana LIKE 'ぷ%' OR hurigana LIKE 'ぺ%' OR hurigana LIKE 'ぽ%'
ORDER BY hurigana " ;
$rst = mysql_query($sql) ;
while ($col = mysql_fetch_array($rst)) {
if($cn%4==1){
$hagyou .= "
" ;
}
$hagyou .= "| $col[meekamei] | " ;
if($cn%4==0){
$hagyou .= "
" ;
}
$cn ++ ;
}
$cn -- ;
if($cn%4==1){
$hagyou .= "
| | | " ;
}
if($cn%4==2){
$hagyou .= "
| | " ;
}
if($cn%4==3){
$hagyou .= "
| " ;
}
$hagyou .= "" ;
?>
" ;
$sql = "SELECT * FROM pati_meeka WHERE hurigana LIKE 'ま%' OR hurigana LIKE 'み%'
OR hurigana LIKE 'む%' OR hurigana LIKE 'め%' OR hurigana LIKE 'も%' ORDER BY hurigana " ;
$rst = mysql_query($sql) ;
while ($col = mysql_fetch_array($rst)) {
if($cn%4==1){
$magyou .= "
" ;
}
$magyou .= "| $col[meekamei] | " ;
if($cn%4==0){
$magyou .= "
" ;
}
$cn ++ ;
}
$cn -- ;
if($cn%4==1){
$magyou .= "
| | | " ;
}
if($cn%4==2){
$magyou .= "
| | " ;
}
if($cn%4==3){
$magyou .= "
| " ;
}
$magyou .= "" ;
?>
" ;
$sql = "SELECT * FROM pati_meeka WHERE hurigana LIKE 'や%' OR hurigana LIKE 'ゆ%'
OR hurigana LIKE 'よ%' ORDER BY hurigana " ;
$rst = mysql_query($sql) ;
while ($col = mysql_fetch_array($rst)) {
if($cn%4==1){
$yagyou .= "
" ;
}
$yagyou .= "| $col[meekamei] | " ;
if($cn%4==0){
$yagyou .= "
" ;
}
$cn ++ ;
}
$cn -- ;
if($cn%4==1){
$yagyou .= "
| | | " ;
}
if($cn%4==2){
$yagyou .= "
| | " ;
}
if($cn%4==3){
$yagyou .= "
| " ;
}
$yagyou .= "" ;
?>
" ;
$sql = "SELECT * FROM pati_meeka WHERE hurigana LIKE 'ら%' OR hurigana LIKE 'り%'
OR hurigana LIKE 'る%' OR hurigana LIKE 'れ%' OR hurigana LIKE 'ろ%' ORDER BY hurigana " ;
$rst = mysql_query($sql) ;
while ($col = mysql_fetch_array($rst)) {
if($cn%4==1){
$ragyou .= "
" ;
}
$ragyou .= "| $col[meekamei] | " ;
if($cn%4==0){
$ragyou .= "
" ;
}
$cn ++ ;
}
$cn -- ;
if($cn%4==1){
$ragyou .= "
| | | " ;
}
if($cn%4==2){
$ragyou .= "
| | " ;
}
if($cn%4==3){
$ragyou .= "
| " ;
}
$ragyou .= "" ;
?>
" ;
$sql = "SELECT * FROM pati_meeka WHERE hurigana LIKE 'わ%' ORDER BY hurigana " ;
$rst = mysql_query($sql) ;
while ($col = mysql_fetch_array($rst)) {
if($cn%4==1){
$wagyou .= "
" ;
}
$wagyou .= "| $col[meekamei] | " ;
if($cn%4==0){
$wagyou .= "
" ;
}
$cn ++ ;
}
$cn -- ;
if($cn%4==1){
$wagyou .= "
| | | " ;
}
if($cn%4==2){
$wagyou .= "
| | " ;
}
if($cn%4==3){
$wagyou .= "
| " ;
}
$wagyou .= "" ;
?>
あ行
か行
さ行
た行
な行
は行
ま行
や行
ら行
わ行
