Please bear with me on this. Firstly I am using ASP pages and a MySQL database with 8 tables in it.

These 8 tables contain userdata each table holds different data about the user.

What I need to produce is a search engine that will perform a search on all tables, displaying the results, with a description of what it has found (stored within the table where the search item was found).

There are only certian fields that can be searched on within each table. I am having great troubles with this as if the user has multiple entries in any table I get that amount of results plus the result of the item itself.

I have the very basics of SQL but need to resolve this problem quickly, as the site I am developing is launching this week and this is the only part I am struggling with.

Any help would be greatly appreciated.

Thanks for your help.