search whole database

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
kumarsena
Forum Newbie
Posts: 18
Joined: Mon Oct 20, 2003 7:18 am
Contact:

search whole database

Post by kumarsena »

hey,

just wondering....i have a databse of my record collection. its a simple one designed only so i can learn to use mysql with php. my question here regards sql. is there are way to search the whole table or several tables (the whole database) for a search phrase entered by the user? the way i understand it now, i will have to provide a drop down menu or similar to allow the user to decide what to search for, a album name, band name or year (take a look at http://www.ultimate-guitar.com tab search) and then use a sql query based on that.

any help would be appreciated.

tnx
kumar
User avatar
JAM
DevNet Resident
Posts: 2101
Joined: Fri Aug 08, 2003 6:53 pm
Location: Sweden
Contact:

Post by JAM »

Personal first thought is the the mysql_list_tables() function, and go on from there. Check that out on the php manual (especially the comments) and let us know if more help is needed.
Linkjames
Forum Commoner
Posts: 90
Joined: Tue Sep 16, 2003 8:39 am

Post by Linkjames »

you could always try the LIKE option.
Post Reply