db query in variable

[djdaz]

Hi
I have a search engine, and im creating the mysql query for this search engine in a variable, that changes depening on what the user specifys to search for, eg

$result = "mysql_query(\"SELECT * FROM generals_maps WHERE ".$in." LIKE %".$for."% ".$order." ".$ad."\")";

When i echo this statement it looks like a valid mysql_query, how ever it returns a mysql_num_rows error when i use it, is there a way around this/

Thanks

[tekky]

have you tried something like....

$result = mysql_query("SELECT * FROM generals_maps WHERE ".$in." LIKE %".$for."% ".$order." ".$ad.");

including the function name in the variable is kinda... odd way of doing things...