text: how can i search for items from many tables in a database? i am usin mysql and php there are many methods.. you can create a union view , which combines all the different tables that you wanna search into and then make the select statement to the union view.. other solution , you can make multible select statements, each on a separate table, concatinating the results into your web page.