ENUM data

[smonkcaptain]

Hey all.

 

I currently have a Field called 'Lens' in a MYSQL table called `members` containing ENUM data displaying on a drop down list on my upload.php page.

 

I'm just wondering whether there is a way to have different enum data for each member or ID such that depending on which user is signed in, it will displaying different data on the drop down.

 

Example:

 

ID      NAME    CAR

id=1  John  enum ('audi','ford')

id=2  Jack  enum ('honda','nissan')

 

 

...etc

 

 

Thankyou for your replies., if you need any more information, just ask!

 

Jimmy Leaman.

[fenway]

Sounds like you're talking about a SET.