search

[sanu]

hi
i have 22 tables in one database now my problem is making search script i did that with giving a choice to user to select the catagory and enter the keyword that worked fine now i want to remove that catagory option is it possible to search in 22 table for a keyword and display in one page

[sarah]

Is each of the 22 tables a category? If so, you might do better to put all of the information in one table with an extra column for 'category' (in case you still need it in the future). Then, you can search any record without having to mess with searching across 22 tables?