Please help me, i new to php and php-forum also.
I am working on courier script and i have three tables named as consignment, b_consignment and h_consignment.
All three tables have same column name with different data.
Now i have to search a particular consignment no. from all the tables, and want to print all information of this particular consignment no. whether it is exist in consignment, b_consignment and h_consignment.
Code for query is as follows.
$c = $_POST['consignment'];
$query = "SELECT * FROM h_consignment h, b_consignment b, consignment c WHERE (c.consignment_no='".$c."' && c.consignment = 'enable') || (b.consignment_no='".$c."' && b.consignment = 'enable') || (h.consignment_no='".$c."' && h.consignment = 'enable')";
$result = mysql_query($query) or die(mysql_error());
Please help me for this problem, i will very greatful