If Statements with MySql Queries

[Anon]

I'm not sure this is correct (or even possible) and need some help with it.

$GetSearchDate = "Select Distinct t.track_date,c.client,e.emp_name from t.tracking, c.client_list, e.emp_list where '$from_date'>=track_date and '$to_date'<=track_date and" .

if ($search_by == 'cli'){
. "c.client RLIKE '$keyword'";
}else{
. "e.emp_name RLIKE '$keyword'";

}

I am getting syntax errors when trying to run this.

Help will be greatly appreciated.
C.

[lawnmowerman]

What is the error that is being reported by mysql_error()?

-Rich

[Anon]

$GetSearchDate = \"first half of query\";

if ($search_by == \'cli\'){
$GetSearchDate .= \"c.client LIKE \'$keyword\'\";
}else{
$GetSearchDate .= \"e.emp_name RLIKE \'$keyword\'\";
}

[Anon]

....OR

$GetSearchDate = " blah, blah" .
( $search_by == 'cli' ? "c.client RLIKE '$keyword'" : "e.emp_name RLIKE '$keyword'" );

[Anon]

It is just a parse error.

C.

[Anon]

Thank you for all your help! I've gotten it figured out and know what I was doing wrong.

I really appreciate it.

[lawnmowerman]

It may simply be a parse error, but mysql_error() will tell you exactly where in the SQL statement the error is located.

mysql_error() is a great tool!

-Rich