i get this error when executing the sql query.

 

if i remove the DESC it works.

 

tNG_fields.getFakeRecordset:

SQL error: Error creating temporary table:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'desc TEXT, date TEXT, id TEXT)' at line 1

SQL:

CREATE TEMPORARY TABLE KT_fakeRS_20090611 (iwant TEXT, type TEXT, price TEXT, bedrooms TEXT, img1 TEXT, img2 TEXT, img3 TEXT, img4 TEXT, desc TEXT, date TEXT, id TEXT) (FIELDS_FAKE_RS_ERROR)

 

field type of desc in the table is text

 

any sql gurus?...

i think it maybe the mysql recognising desc as describe

 

you may need to change the name from desc to something mysql does not recognise as a command

i think it maybe the mysql recognising desc as describe

 

you may need to change the name from desc to something mysql does not recognise as a command

 

thanks..ill try

I "think" it should work if you put the field names in inverted quotes, like this:

CREATE TEMPORARY TABLE `KT_fakeRS_20090611` (`iwant` TEXT, `type` TEXT, `price` TEXT, `bedrooms` TEXT, `img1` TEXT, `img2` TEXT, `img3` TEXT, `img4` TEXT,` desc` TEXT, `date` TEXT, `id` TEXT) (FIELDS_FAKE_RS_ERROR)