[SOLVED] Query Help with Query using CONCAT() Adding WHERE

[centerwork]

I'm sorry to bother all of you with this, I am pushing a deadline and I just can't seem to figure this out.

 

Here is the query:

$query = "select *,CONCAT(CAST(o_id AS CHAR), CAST(o_cust_id AS CHAR), CAST(o_po AS CHAR), o_mainline, CAST(o_status AS CHAR), CAST(o_crc AS CHAR), CAST(o_completed AS CHAR)) AS alais1 FROM orders HAVING alais1 LIKE '%$trimmed%'";

 

What I need to do is add  -  WHERE o_cust_id='$c_id' && o_completed='1'

 

I have tried everything I can think of, none of which worked.

 

My mysql_num_rows() gives me an error, Here it is:

 

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/content/m/e/t/metrodigital/html/admin/order_search.php on line 81

 

 

[cooldude832]

put your error on the mysql_query function not the mysql_num_rows you get a better idea what the error is then

[fenway]

This is a continuation of this thread -- don't double-post next time.

 

Put the where clause before the having clause.

[centerwork]

Sorry about that.

 

Thank you for the good advice it worked perfectly.