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.
koros.komen
0
Newbie Poster
Recommended Answers
Jump to PostWhy 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 PostYou 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
JorgeM
958
Problem Solver
Team Colleague
Featured Poster
koros.komen
0
Newbie Poster
JorgeM
958
Problem Solver
Team Colleague
Featured Poster
koros.komen
0
Newbie Poster
koros.komen
0
Newbie Poster
seslie
56
Light Poster
JorgeM
958
Problem Solver
Team Colleague
Featured Poster
diafol
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.