wildcard query via PHP
21832Oct 28 2004 — edited Nov 17 2004need help on query using wildcard ... got sql statement that uses an input variable and then search Oracle thru wildcard "%variable%" like this:
select col1, col2, col3 from table
where col1 like '%$variable%'
what wrong with this sql statement on PHP ... $variable is supposed to be an input variable coming from POST/SUBMIT ... but when going to the url, it automatically query all from table even before entering the value for search ... tia for help!