hi eric,
yes i have an unknown column error. however i added in a column App1Age and App2Age in mysql database with type int.
however it wont have a value in the database as it is the query which is producing the value from the date of birth column.
when i test my recordset it shows fine with a value in the app1age.
also when i display it on the page next to that clients details it shows the correct value from the recordset.
all i want to be able to do is search the recrodset.
i there custom coding that is required in the backend or helper file?
if you can let me know asap as i need to be able to search this value on my page.
many thanks