populate select list from multiple Mysql tables

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.

Assuming 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...

This isn't exactly what I was looking for. I should have been more specific.
Table1 holds information such as item information and a category id number.
Table2 holds the category name and a parent category number.
Table3 holds the parent category's name.

What I need is to select distinct category id numbers from Table1 and retrieve the name of those categories from Table2.

Hi...
I read your post... This thing will be a problem to do because, you do not have anythng common in the Table1 and Table2. Im not sure how much you have idea about the Database Normalization thing, but this is actually not a correct way to implement the database thing.

I know you have the parent category id in table 2, but then the parent id might not be the category of the item... I hope you get me..

So for this, first correct your tables structure...
I'll suggest you one structure..

Hello everyone..it's me again..adindra
i have a problem :
i have 1 database name [B]manipulasiphp[/B], with 10 field (id,nama,email,alamat,umur,negara,universitas,jurusan,prodi,no_telp)
i have 1 HTML script and …

Hello,
I've read on how to insert properly into two linked tables using mysql_insert_id() function from:
[url]http://www.webproworld.com/web-programming-discussion-forum/87197-php-insert-different-records-into-multiple-mysql-tables-same-unique-id.html[/url]
now how about if i want it to …

I'm working in Excel to extract content of a table from a web page and populate Excel sheet cells with it. I'm trying to extract data from a table that gets loaded to a web page after show results method gets called. I have an error that says "Run-time error ...