Ignoring fields

[aktar]

Consider the query below

[CODE=mysql]SELECT exists1, exists2, non_existant FROM table[/CODE]

If the fileld non_existant does not exist, would it then be possible to get mysql to ignore this field?

[mwasif]

Didn't understand.

[ronverdonk]

No, you'll get an error message 'unknown column .. etc...' and the query will not be executed. Or you can suppress the message, but you still won't get a result. Out of curiosity: why would you want to select a column that does not exist?

Would it not be easier to check the existence of the columns of the table and use that to construct your query?

Ronald

[aktar]

No, you'll get an error message 'unknown column .. etc...' and the query will not be executed. Or you can suppress the message, but you still won't get a result. Out of curiosity: why would you want to select a column that does not exist?

Would it not be easier to check the existence of the columns of the table and use that to construct your query?

Ronald

Well the query will be auto generated depending on _REQUEST variables. It will be easy to fool the script with extra information, hence wanting to ignore non-existing fields.

BTW, how do you supress errors thrown by mysql?