use multiple while loop to fetch muliple data from multiple database table

Question

I have three tables namely title, image, lists. title table has an auto_increment id which is present in other two tables as reference id, other than that these two has their own auto_increment pid and lid, i want to fetch record from all tables using while loop.

eg.
my title table has

id   title
1    nirman
2    meditation

my image table has

pid   id  image
1     1    1.jpg
2     1    2.jpg
3     2    6.jpg

and my list table has

lid   id   list
1     1    serve us....
2     1    web service
3     1    cms
4     2    about

i have different division to show all data from image and list table where heading is coming from title table. If you can understand what I am trying to ask then please reply with relevant code otherwise reply with the part of my text you could not understand.

Let the storage engine deal with that. Select the data from all three tables at the same time based on the id. — Mike 'Pomax' Kamermans
– Mike 'Pomax' Kamermans, Commented Jun 19, 2013 at 13:08
yeah i did that but the place where I have to show the result is so much complicated that join is not working properly. sorry to say but join is not working fine for me please provide with another alternative — Php developer
– Php developer, Commented Jun 19, 2013 at 13:08
"the place where I have to show the result is so much complicated that join is not working properly" - this makes no sense; displaying it in PHP will not affect the join at all. What did you actually mean? — user359040
– user359040, Commented Jun 19, 2013 at 13:14

Randy · Accepted Answer · 2013-06-19 13:07:50Z

1

select title, image, list
from title t, image i, list l
where t.id = i.id
and t.id = l.id

answered Jun 19, 2013 at 13:07

Randy

16.7k2 gold badges40 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Php developer Over a year ago

a static jquery code was used where multiple images under one title was shown now i replaced that code with php but its not working properly.

Randy Over a year ago

i suggest editing your original question with some expected output.

Php developer Over a year ago

yeah I used join with some extra features and now its working fine. thanks a lot its working.

Collectives™ on Stack Overflow

use multiple while loop to fetch muliple data from multiple database table

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related