01.
$n
=
array
(
''
,
'หมู'
,
'เห็ด'
,
'เป็ด'
,
'ไก่'
,
'ช้าง'
,
'ม้า'
,
'วัว'
);
02.
03.
$coSQL
= "SELECT *,
count
(num)
as
cn1 FROM number
04.
WHERE type =
'$n[2]'
and
user =
'$_SESSION[login_true]'
05.
and
price >= cut group by num";
06.
$coQuery
=
$conn
->query(
$coSQL
)
or
die
(
$conn
->error.
"<br>$coSQL"
);
07.
while
(
$cROW
=
$coQuery
->fetch_assoc()):
08.
09.
echo
$type
=
$cROW
[
"type"
];
10.
echo
"-"
;
11.
echo
$n
=
$cROW
[
"num"
];
12.
echo
"-"
;
13.
echo
$nu
=
$cROW
[
"cn1"
];
14.
echo
"-"
;
15.
echo
$num
=
$cROW
[
"cn1"
] *
$p_twoup
;
16.
echo
"<BR>"
;
17.
endwhile
;