[scootviva]

Hai im from Malaysia..and i need idea to solve my probleum.

my first probleum is:
I having probleum for making search code. to search data in this 2 table.

i using Mysql as DB
my DB name is: lesenanjing
and the table is:rm10 and rm20

i have attach my coding for the helper to view. This search code works fine but it select only one table (rm10).

second probleum is:
i want to view all data in this two table with single click to see if their is a duplicate data in it.

plz help me...

Attached image(s)

• 

This post has been edited by scootviva: 02 July 2009 - 02:52 AM

[CTphpnwb]

$tbl_name = "rm10";
$search1 = mysql_real_escape_string($_POST['search1']);
$sql1  = "SELECT * FROM $tbl_name WHERE NoKP LIKE '%$search1%'";
$tbl_name = "rm20";
$sql2  = "SELECT * FROM $tbl_name WHERE NoKP LIKE '%$search1%'";
$result1 = mysql_query($sql1);
$result2 = mysql_query($sql2);

From here it's just a matter of displaying the data from the two results. If you want to automatically compare the results, that's a little more difficult because you need to compare each row of one result with every row of the other.

[scootviva]

thank CTphpnwb for the coding. it help me actualy .

i just want to ask, how to view all data in two table with same database.


Thanks