<body>
<?php
set_time_limit(0);
$link= mysql_connect(localhost,root,240730);
if(!$link)
{
print("<b>Can't connect to host</b>");
}
else
{
print("<b>OK!!!</b><br>");
mysql_select_db("tot",$link) or die ("Can't connect to data base");
mysql_query( "set character_set_results=tis620 ");
mysql_query( "set character_set_connection=tis620 ");
mysql_query( "set character_set_client=tis620 ");
$result=mysql_query("SELECT r.tel, r.name, r.rcu, r.date, r.usage, r.service, r.tax, r.total, count(r.tel) other
FROM tttt as r RIGHT JOIN test as t
ON t.tel=r.telnew
GROUP BY r.tel, r.name, r.rcu, r.date, r.usage, r.service, r.tax, r.total" ,$link);
$num=mysql_num_rows($result);
$num2=$num-1;
print("ตรงกัน=$num2<br>");
while($row=mysql_fetch_row($result))
{
print("$row[0] _____ $row[1] _____$row[2]_____$row[3]_____$row[4]_____$row[5]_____$row[6]_____ $row[7]_____$row[8] <br>");
}
$result1=mysql_query("SELECT t.tel, t.code1, t.d, t.code2, t.f, t.where, count(t.tel) other
FROM tttt as r, test as t
WHERE not t.tel = r.telnew
GROUP BY t.tel, t.code1, t.d, t.code2, t.f, t.where",$link);
$num1=mysql_num_rows($result1);
print("ไม่ตรงกัน=$num1<br>");
while($row1=mysql_fetch_row($result1))
{
print("$row1[0] _____ $row1[1] $row1[2]_____$row1[3]$row1[4]_____$row1[5]_____$row1[6] <br>");
}
echo mysql_error();
mysql_close($link);
}
Load balance : Server 00
