Easy query question HELP!!

[jamesloi]

Hi,

I have created a table in mySql database using fields of Type 'varchar'.

Everytime i do a query on the database, the query only returns results if it is an integer value e.g. If ref = 1, $ref is '1'

The query doesnt return any results if they are text e.g. 'CustName = $custname' , $custname is 'test' but this exists on the database.

The variables are posted from a form.

Any help please

[jamesloi]

God i fixed it,

forgot you have to put quotation marks around the variable e.g. ..WHERE CustName='$custname'

im so dumb