I'm looking for a way of displaying the results of a search facility on a site im creating.
The site is based on an animal sanctury and the database holds two key tables for searching 'blog' and 'animals' respectivly.
Now, how would i go about displaying the results for example in my site search i typed in 'moggy' how can i display the results of moggy from the animal database (age,colour,breed etc) and moggy from the blog (title,content) and echo it out accordingly
The search part itsself is no real problem its the fetching and displaying the results that i can't fiqure out.
Any help would be great, thanks