faqts : Computers : Programming : Languages : PHP : Common Problems : Arrays

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

3 of 3 people (100%) answered Yes
Recently 3 of 3 people (100%) answered Yes

Entry

How do you display mutliple values from array field via look-up table

Dec 27th, 2005 10:39
Lawrence Bunnell,


Using PHP I would like to display the values of an array field within a
mySQL table

ie. TABLE NAME: PROPERTY
COLUMN NAME: APPLIANCES
VALUE: "REFRG,WASHR,DRYER,DISPL"

using their values Refrigerator, Washer, Dryer, Disposal from a look-up
table 

LOOKUP TABLE NAME: APPLIANCES
id_app: REFRG 
name_app: Refrigerator

I'm not sure how to loop through the values in the field to display them