如何从MySQL数据库中选择用户特定信息？

Question

I was wondering how can I have my users pick their favorite food from a category of foods in my MySQL database.

Will I need two different tables? If so what will my second table look like?

Here is my MySQL food table structure.

id | parent_id | food | url

Answer 1

You'll need 3 tables in total:

1. Food - holds food information
2. Users - holds users information
3. Users_Food - holds user id + food id (and maybe a ranking)

You should probably read up on database normalization.