1.11M Members

comparing value from 2 diff databases


heyy guys....i manage to connect to diff database in a single form...but how do i compare the value...
for eg. now i would to compare invoice_no for the both of them

$host="localhost"; 		// Host name
    $username=""; 			// Mysql username
    $password=""; 			// Mysql password
    $db_name="test"; 		// Database name
    $tbl_name="test3"; 		// Table name
    $db_name1="test1"; 		// Database name
    $tbl_name1="test2";		// Table name
    // Connect to server and select database.
    $dbh1=mysql_connect("$host", "$username", "$password")or die("cannot connect");
    $dbh2=mysql_connect("$host", "$username", "$password",true)or die("cannot connect");
	mysql_select_db("$db_name", $dbh1)or die(mysql_error());
	mysql_select_db("$db_name1", $dbh2)or die(mysql_error());

    $sql="SELECT * FROM $tbl_name WHERE invoice_no = '$invoiceno'";			
    $row=mysql_fetch_array($result) or die(mysql_error());					
    echo "$row";  
		echo "Invoice No. found";
    else																	//invoice no. not found, prompts user again
		echo "ngek ngek";

could someone guide me please



These codes

$sql="SELECT * FROM $tbl_name WHERE invoice_no = '$invoiceno'";
$row=mysql_fetch_array($result) or die(mysql_error());
echo "$row";

Shouldn't be a lot easier to find if rows is greater than zero?

Something like this

$sql="SELECT * FROM $tbl_name WHERE invoice_no = '$invoiceno'";
$row= mysql_num_rows($result) or die(mysql_error());
echo "$row"; 

## check on the result

## do your thing here


Do the same on the second database..


thank you for the reply....hmm, i understand....one more question...lets say both the database has invoice number...how to i compare them....using a single sql line...is it possible?


owh...its okay..i manage to do it...:D

$invoiceno=$_POST['invoiceno'];							// invoice no. sent from form
 $sql="SELECT * FROM $tbl_name WHERE invoice_no ='$invoiceno'";			
    $result = mysql_query($sql,$dbh1);
	$row = mysql_fetch_array($result);
	$sql1="SELECT * FROM $tbl_name1 WHERE invoice_no = '$invoiceno'";
	$result1 = mysql_query($sql1,$dbh2);										
    $row1 = mysql_fetch_array($result1);

thank you again

Question Answered as of 2 Years Ago by veedeoo

cool.. :)

This question has already been solved: Start a new discussion instead
Start New Discussion
Tags Related to this Article