very urgent

[gopi nath <gopivsb@xxxxxxxxxxx>]

my table type:


  tbl_media =    id,name,address.
 tbl_travels = tid,name,address.
tbl_tour = trid,name,address.
...
....
for example

$search = $_POST['txtSearch'];
    if($search != ""){
    $t1 = "(SELECT * from tbl_travels where VNAME='".$_REQUEST['txtSearch']."' or VCATAGORY='".$_REQUEST['txtSearch']."')UNION(SELECT * from tbl_stay where VNAME = '".$_REQUEST['txtSearch']."' OR VCOMPANYNAME = '$search')UNION(SELECT * FROM tbl_eatouts where VNAME = '$search' or VCOMPANYNAME = '$search')UNION(SELECT * FROM tbl_finance where VNAME = '$search' or VCOMPANYNAME = '$search')";
}
  



      Add more friends to your messenger and enjoy! Go to http://messenger.yahoo.com/invite/

[Non-text portions of this message have been removed]