PHP/MySQL Unknown column.......in 'where clause'

[sidvicious]

Hi - Hope someone can help me with this, driving me nuts.

Form with 3 fields & submit button. Method set to "GET".

Results page has URL bindings for the passed parameters, and these appear to be working ok since I put a field on the page to display the first parameter, bound it etc, and it's passed across fine.

In the advanced recordset definition, I've got the following SQL :-

SELECT *
FROM acOffers
WHERE acOffersType = TypeVar

then in variables TypeVar is defined with a default value of '%' and runtime value of $_GET['acOfferQueryType'].

When I run the 'search' page and enter say 'TRYTHIS' as the value for 'acOfferQueryType', then the 'results page displays the error :-

Unknown column 'TRYTHIS' in 'where clause'

I've tried using quotation marks instead of single quotes in the runtime value field, but the same thing happened.

It's driving me mad and really holding me up so any help would be really appreciated.

Cheers

 

[sidvicious]

Oh Sheeeeeite,

SQL should've been :-

SELECT *
FROM acOffers
WHERE acOffersType = 'TypeVar'
(just the single quotes missing around TypeVar).

Still can't get the default wildcard ('%') to work though - zero results ???