01.
<?php
02.
03.
...
04.
....
05.
...
06.
$genderString
=
array
(
"1"
=>
"ผู้ชาย"
,
"2"
=>
"ผู้หญิง"
);
07.
$sql
=
"select gender,count(*) as amount from databasic group by gender"
;
08.
$res
=mysql_query(
$sql
)
or
die
(mysql_error());
09.
while
(
$data
= mysql_fetch_assoc(
$res
)){
10.
echo
"มี"
.
$genderString
[
$data
[
"gender"
]].
":"
.
$data
[
"amount"
].
"คน"
;
11.
}
12.
13.
?>