Question: how can i search for items from many tables in a database? i am usin mysql and php

Answer: There are many methods..\nyou 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..\nother solution , you can make multible select statements, each on a separate table, concatinating the results into your web page.
This question from the Yahoo Q&A forum is categorized in the topic: Health