Page 1 of 1
select-query
Posted: Fri Feb 18, 2005 2:57 am
by Miku
Can I do sql-query that selects all fields, but by choise it discards some specified fields ?
Posted: Fri Feb 18, 2005 6:13 am
by timvw
you mean order by rand() and limit the rows in the resultset?
Posted: Fri Feb 18, 2005 6:18 am
by Miku
Well, I mean that if i have for example fields f1,f2,f3,f4_en, f4_fi etc.. How I select fields f1,f2,f3 and by users choise f4_en or f4_fi ?
Posted: Fri Feb 18, 2005 7:08 am
by magicrobotmonkey
yea just have a form with some check boxes or radio buttons that let them choose and then in your query hardcode in the ones you always want selected, and add in (after validation), the chosen ones.