How to run 2 queries based on input value

[shmideo]

Hi

 

I have a form that has a drop-down with a few to choose from, unfortunately I don't get results for some due to the query involved.

Some need the AND channel LIKE '%$channel%'"; and some don't and therefore will not get desired results. So I would like to run two queries one with and one without.

 

$query = "SELECT * FROM asterisk_cdr WHERE calldate BETWEEN '$calldate' AND '$calldate2' AND clid LIKE '%$clid%' AND channel LIKE '%$channel%'";

 

Thanks

 

[Psycho]

Wouldn't the query without that condition include the records for both? There shouldn't be a need for two queries. You could actually add a dynamic field to the output to indicate which ones meet the like query if needed.

[shmideo]

No for some reason if that condition is present then no results are found for ones that don't require it. Can you give an example of a dynamic field to output please?

[Barand]

$query = "SELECT * FROM asterisk_cdr WHERE calldate BETWEEN '$calldate' AND '$calldate2' AND clid LIKE '%$clid%'";


if (!empty($_GET['channel'])) {

    $channel = $mysqli->real_escape_string($_GET['channel']);

    $query .= " AND channel LIKE '%$channel%' ";

}

[shmideo]

Thank you Barand