damerit Posted December 2, 2008 Share Posted December 2, 2008 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 More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.