Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / NewStats: 3,199,240 members, 7,970,863 topics. Date: Wednesday, 09 October 2024 at 04:51 PM |
Nairaland Forum / Science/Technology / Programming / Sql For Joing 3 Tables In My Databse (1516 Views)
Pls Developer Help Me To Solve This Excel File Upload To Databse / "SQL For Beginners”--- SUCH AS Mysql, Postgresql, Oracle 11g / How Do I Search Multiple Tables In A Database For A Query? (2) (3) (4)
Sql For Joing 3 Tables In My Databse by cyan2008(m): 10:23pm On Feb 16, 2015 |
Dear Friends, i am very new in programming, and i am just learning PHP MYSQL DATABASE. I need some good programmers to provide me with sql to join and display the information stored in database table in the manner illustrated below: .........table 1......................................................................table 2...............................................table 3-------------- id----name------age------------------------------------id---food--------drink--------------id-----marks------------position 1.......Ken...........15yrs...............................................1.....rice............coke--------------1.........50%.................1st 2.......John..........20yrs...............................................2 ....beans........fanta--------------2.........30%..................2nd Now i need an sql statement that when someone clicks on any record from table 1, say on KEN, all record in the corresponding rows in the other two tables (table 2 and table 3) will be displayed. In other words, any record from table 1 (KEN) will serve as a master link to display the other records of Ken in table 2 and tables 3. clikc on KEN-------------------------->>>display------>> rice, coke, 50%, 1st click on JOHN ------------------------>>>display------>> beans, fanta, 30%, 2nd and SO ON Thanks so much guys. 08036730744 |
Re: Sql For Joing 3 Tables In My Databse by Urine: 10:34pm On Feb 16, 2015 |
cyan2008: Ever heard of "Trigger" in mysql? Google it, you should be able to work something out. |
Re: Sql For Joing 3 Tables In My Databse by spikesC(m): 10:46pm On Feb 16, 2015 |
Urine: Trigger? In joins? Op, read on mysql joins |
Re: Sql For Joing 3 Tables In My Databse by Urine: 10:50pm On Feb 16, 2015 |
spikesC: Boss, you can use trigger to manipulate different tables in a database. I find it easier, that said I know it's not the only way. |
Re: Sql For Joing 3 Tables In My Databse by spikesC(m): 11:04pm On Feb 16, 2015 |
Urine: I think you missed a bit of his question. He is talking about selection here not manipulation. Trigger is usually used when you need to execute pre-defined queries based on events. The op just wants to select data from different tables related by a foreign key. |
Re: Sql For Joing 3 Tables In My Databse by Urine: 11:17pm On Feb 16, 2015 |
spikesC: I get your point about the FK, but I followed his database design to make the suggestion but with your suggestion he has to redesign his table. As for the trigger, a couple of months ago I wrote a code for an inventory system that had a sales and product table anytime a sale is registered the quantity in the product table reduces. I will put up the code for you tomorrow to see. |
Re: Sql For Joing 3 Tables In My Databse by spikesC(m): 2:20am On Feb 17, 2015 |
Urine: Yes, this is a perfect example of the use of Triggers. And honestly, I didn't bother to study his schema as it didn't display well |
Re: Sql For Joing 3 Tables In My Databse by cyan2008(m): 12:11pm On Feb 17, 2015 |
guys Thanks for the contributions and advice. But i have not been able to solve the problem. what i need to achieve is to display one or more data from a row in table 1 such that whoever clicks on it will get corresponding rows from the other two tables. |
Re: Sql For Joing 3 Tables In My Databse by codemarshal08(m): 2:05pm On Feb 17, 2015 |
cyan2008: ehmm, i think You need to work on your table design. Research on KEYS and table Relationship & sql Joins |
Re: Sql For Joing 3 Tables In My Databse by abdul01(m): 5:34pm On Feb 17, 2015 |
@op, try this SELECT t1.name, t1.age, t2.food, t2.drink, t3.marks, t3.position FROM table1 t1 JOIN (table2 t2, table3 t3) ON (t1.id=t2.id AND t2.id=t3.id); or SELECT t1.name, t1.age, t2.food, t2.drink, t3.marks, t3.position FROM table1 t1, table2 t2, table3 t3 WHERE t1.id=t2.id AND t2.id=t3.id But Ur table design's a bit poor sha! |
Re: Sql For Joing 3 Tables In My Databse by Urine: 10:20pm On Feb 17, 2015 |
cyan2008: Let's see your new table design. |
Re: Sql For Joing 3 Tables In My Databse by GoodMuyis(m): 12:33am On Feb 18, 2015 |
Where you able to Run The Sample @abdul01 gave to you in phpmyadmin if it works the the remain lies back in HTML/PHP abdul01: ======= Now Try something like this in your PHP file [can save it as "test.php"]
|
Re: Sql For Joing 3 Tables In My Databse by Nobody: 4:08pm On Feb 18, 2015 |
Urine:triggers is totally unrelated to the issue here |
Re: Sql For Joing 3 Tables In My Databse by Urine: 6:55pm On Feb 18, 2015 |
sledjama: Ok Sir ,but if you had taken time to read through the thread you will notice that has been clarified. So why did you raise the issue again? |
Re: Sql For Joing 3 Tables In My Databse by Nobody: 10:02pm On Feb 18, 2015 |
Urine: apologies for not reading through. 1 Like |
(1) (Reply)
Real Wifi Hacking App For Android Is Here. / A Programmer Male Friend Needed By A Female Programmer In Warri, Delta / ..
(Go Up)
Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health religion celebs tv-movies music-radio literature webmasters programming techmarket Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 38 |