Jump to content

search post events from seperate tables


damerit

Recommended Posts

I need to know if this is possible. I have a variable of $status and a post value of 'Open' and 'Closed'. Open pulls from table1 and closed pulls from table2. How can I pull all 'Open + Closed' posts under and 'All' option?

 

if($_POST['status'] == "Open") {
if (!empty($clarifyID)) {
  mysql_select_db($database, $Calls);
$query_Calls = "Select * FROM table1 WHERE $Clarify";
$ActiveCalls = mysql_query($query_ActiveCalls, $ActiveCalls) or die(mysql_error());
$count_Calls = mysql_num_rows($Calls);
}
  else {
    mysql_select_db($database, $Calls);
  	$query_Calls = "Select * FROM table1 WHERE $TimeFrame AND $companySearch AND $severitySearch AND $Status AND $joinproductFamily AND $Product ORDER BY TimeInHouse";
$Calls = mysql_query($query_Calls, $Calls) or die(mysql_error());
$count_Calls = mysql_num_rows($Calls);
  }
} 
// Status == Closed
if($_POST['status'] == "Closed") {
if (!empty($clarifyID)) {
  mysql_select_db($database, $Calls);
$query_Calls = "Select * FROM table2 WHERE $Clarify";
$ActiveCalls = mysql_query($query_ActiveCalls, $ActiveCalls) or die(mysql_error());
$count_Calls = mysql_num_rows($Calls);
}
  else {
    mysql_select_db($database, $Calls);
  	$query_Calls = "Select * FROM table2 WHERE $TimeFrame AND $companySearch AND $severitySearch AND $Status AND $joinproductFamily AND $Product ORDER BY TimeInHouse";
$Calls = mysql_query($query_Calls, $Calls) or die(mysql_error());
$count_Calls = mysql_num_rows($Calls);
  }
}	  
/////// Status == All ///////////////
//[color=red][b]This is where I want to search for all calls in table1 and table2.[/b][/color]
if($_POST['status'] == "All") {
    mysql_select_db($database_Calls, $Calls);
  	$query_Calls = "Select * FROM callsclosed WHERE $TimeFrame AND $companySearch AND $severitySearch AND $Status AND $Product ORDER BY TimeInHouse";
$query_Calls = "Select * FROM e1data WHERE $TimeFrame AND $companySearch AND $severitySearch AND $Status AND $Product ORDER BY TimeInHouse";
$Calls = mysql_query($query_Calls, $Calls) or die(mysql_error());
$count_Calls = mysql_num_rows($Calls);
  }
}

Link to comment
https://forums.phpfreaks.com/topic/135190-search-post-events-from-seperate-tables/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.