hey folks, I have a question. I have several mysql tables and I'd like to fetch data from a few of them to create a <select> <option> list. How could this be done. I can get the info from one table, but don't know how to get the data from more than one table. Hope you can understand what I;m trying to do. Thanks.
PomonaGrange
0
Junior Poster in Training
Recommended Answers
Jump to PostAssuming that the two tables that you have are exactly the same in their structure.. i mean, both have same fields and same order of fields..
…
Then you can execute first query, then second query, and append the data of second query to the first one.. See the example below...
All 4 Replies
sikka_varun
0
Junior Poster in Training
PomonaGrange
0
Junior Poster in Training
sikka_varun
0
Junior Poster in Training
PomonaGrange
0
Junior Poster in Training
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.