Quick Question

[Ryaan]

So basically what I've got is this

$search = mysql_query("SELECT * FROM myPMs WHERE message like \"%$trimmed%\""); 

 

But what I want is it to do something such as

WHERE message like \"%$trimmed%\" and also WHERE to_user = '$id'

 

So it would be getting two WHERE's.

 

I'm not sure if it's possible, but if it is please let me know how.

 

Thanks, Ryan.

 

[fert]

SELECT * FROM `table` WHERE `foo`='bar' AND `bar`='foo'

[Ryaan]

Ah, I was trying &. Thank you very much.

 

Oh, and is there a point to the ` between every word?

[fert]

no, not really