Forum Moderators: open
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.
