PDA

View Full Version : Help Please


hobbybox
06-17-2008, 06:50 PM
I offer my members the ability to select from a list in the profile fields. Whatever they select shows in the post bit...

One of the items they can choose from is 'other' - I then have a 2nd profile field that allows them to type the name of the item if it doesnt appear on the list.

what im looking to do is somehow each day be able to get a list of the members that have 'other' selected so I can add what they typed to the list and change their profile.

Can this be done by a cron job? If so can someone help me create it? im trying to avoid having to manually check each new registration to see if they selected 'Other' and to see what they added.

Dismounted
06-18-2008, 07:22 AM
SELECT userid, fieldX
FROM userfield
WHERE fieldY = 'Other'
Where fieldX is the field you want to see and fieldY is the field with "other".

hobbybox
06-18-2008, 01:26 PM
thank you - works great.