[TommyB]

Quote:

Originally Posted by iLearner %% arent a problem, the problem is typing ' ' Format: LIKE '%SEARCHEDTERM%' we cant type ' via pawn, as the plugin will convert it into "

Really? I don't have that problem. Here's a query that works just fine for me.

PHP Code:

mysql_format(conn, mquery, sizeof(mquery), "SELECT OwnerName,PhoneNumber FROM phones WHERE OwnerName LIKE '%%%e%%' AND ShowPhonebook = 1 LIMIT 25", params);