Page 1 of 1

search whole database

Posted: Wed Nov 26, 2003 5:58 pm
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

Posted: Sat Nov 29, 2003 5:37 pm
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.

Posted: Sun Nov 30, 2003 2:48 pm
by Linkjames
you could always try the LIKE option.