01.
<?
$sql
=
"select * from `"
.
$tb_prefix
.
"question` WHERE quPinn='1' ORDER BY quID DESC limit 10"
;
02.
$result
= mysql_db_query(
$dbName
,
$sql
);
03.
while
(
$row
=mysql_fetch_array (
$result
))
04.
{
05.
$quIDC
=
$row
[quID];
06.
$memIDse
=
$row
[memID];
07.
$quCaption
=
$row
[quCaption];
08.
$quName
=
$row
[quName];
09.
$quImages
=
$row
[quImages];
10.
$quStatus
=
$row
[quStatus];
11.
$quDatePost
=
$row
[quDatePost];
12.
$quRead
=
$row
[quRead];
13.
$quAns
=
$row
[quAns];
14.
$quCode
=
$row
[quCode];
15.
$quID2
= sprintf(
"%05d"
,
$quIDC
);
16.
$quCaption
=CutLongText(
$quCaption
,
'190'
);
17.
18.
19.
20.
$sql
=
"select*from `"
.
$tb_prefix
.
"answer` where quID='$quIDC'"
;
21.
$query
=mysql_query(
$sql
);
22.
$chk
= mysql_num_rows(
$query
);
23.
24.
$resultud
=select(
"`"
.
$tb_prefix
.
"member`"
,
"where meUname='$quName'"
);
25.
$mePicture
=
$resultud
[
"mePicture"
];
26.
27.
echo
" <tr align=\"left\" class=\"h2\"><td> <img src=\"images/icon-03.png\"> $quID2 <a href=\"viewtopic.php?id=$quIDC\" class=\"link9\"
>
$quCaption
</a>
28.
";
29.
30.
if
(
$mePicture
==
""
){
31.
echo
"<a href=\"memberpost.php?id=$memIDse\" >$quName</a>"
;
32.
}
else
{
33.
echo
"<a href=\"memberpost.php?id=$memIDse\" ><img src=\"picpic/$mePicture\" width=\"110\" height=\"17\" border=\"0\"></a> "
;
34.
}
35.
36.
echo
" ( <font class=\"h6\">$quRead</font> + <font class=\"h7\">$chk</font> ) <br/></td></tr>"
;
37.
38.
}
39.
40.
?>