Display database info in dropdown list
Posted: Mon Jul 24, 2006 9:00 am
Hi people.
Could anyone help me here, i need to output two fields from my sql database, and join them together so that the dropdown list in my CMS page displays the first and last name of a member of staff.
the table name is called tbl_staff
the firstname field is called staff_nameFirst
the surname field is called staff_nameLast
All help will be appreciated.
Many thanks,
Nick.
Could anyone help me here, i need to output two fields from my sql database, and join them together so that the dropdown list in my CMS page displays the first and last name of a member of staff.
the table name is called tbl_staff
the firstname field is called staff_nameFirst
the surname field is called staff_nameLast
All help will be appreciated.
Many thanks,
Nick.