Querying Database
Posted: Fri May 24, 2002 11:23 pm
Hey there
Just a query regarding commands used for MYSQL.
I have on a form 3 fields, 1 list, 1 text and 1 submit/search button. Once the form has been submitted, what commands would be used to query the database depending on which type was chosen from the list menu, and the data inputted in the text field.
eg The list has Singer, Album, Song. And the text field is where you'd type in details of what ever your looking for, and the search button will post the form to the .php file containing sql commands.
Really appreciate some advice.. Cheers..
I have on a form 3 fields, 1 list, 1 text and 1 submit/search button. Once the form has been submitted, what commands would be used to query the database depending on which type was chosen from the list menu, and the data inputted in the text field.
eg The list has Singer, Album, Song. And the text field is where you'd type in details of what ever your looking for, and the search button will post the form to the .php file containing sql commands.
Really appreciate some advice.. Cheers..