Hi Prows,am creating a farm produce monitoring system using mysql and php.The database contains several tables of different produces that have the similar fields.The admin is supposed to update each table with different values.How will these datas relate.
For example,maize field has Product-id,produce-name,location,date,time and mobile number of the buyer.Each table have the same attributes as that.
Can I create any relationship?
Thanks in advance.
Jump to Post
Why would you need different tables. It sounds like the information belongs in one table. When you query this table, you would use the WHERE clause to pick specific produce as an example.
Without knowing more information about the tables you have, it would be challenging to advise on options …
Jump to Post
You havent provided enough details for me to answer your question, but this info may help you better understand the purpose of creating the relationships.
Say, you have a list of produce and you intend to sell the produce. This can be done with one table, but the data would …
All 8 Replies
We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.