01.
<?
02.
03.
04.
$hostname
=
"localhost"
;
05.
$user
=
"root"
;
06.
$password
=
"1234"
;
07.
$dname
=
"support"
;
08.
$tblname
=
"pm"
;
09.
$connect
= mysql_connect(
$hostname
,
$user
,
$password
)
or
die
(
"can't connect DB"
);
10.
$db
= mysql_select_db(
$dname
)
or
die
(
"can't connect DataBaseName"
);
11.
mysql_query(
"SET NAMES UTF8"
);
12.
13.
$To_id
=
$_SESSION
[
"ssUserID"
];
14.
$sql
=
"select * from pm where To_id =$To_id "
;
15.
$dbquery
= mysql_db_query(
"support"
,
$sql
);
16.
$isread
=
"N"
;
17.
18.
$sql2
=
"select * from $tblname where (isread = '$isread')"
;
19.
$dbquery2
= mysql_db_query(
"support"
,
$sql2
);
20.
$num_rows2
= mysql_num_rows(
$dbquery2
);
21.
22.
23.
?>
24.
ข้อความใหม่ [<?
echo
$num_rows2
?>]