21,893
社区成员




$sql="select t1.name as table1_name,t2.name as table2_name from table1 t1,table2 t2 where t1.name=t2.name and t1.name like '%123$'";";
$result=mysql_query($sql);
while($rs=mysql_fetch_array($result))
{
echo " <tr> <td>".$rs['table1_name']." </td> </tr>"; //table1
echo " <tr> <td>".$rs['table2_name']." </td> </tr>"; //table2
}
while($rs=mysql_fetch_array($result))
{
echo " <tr> <td>".$name." </td> </tr>";
}