hookit Posted August 10, 2009 Share Posted August 10, 2009 Hi, I have a table with the following fields. Province, post code, address, day, time. In a web page i want to introduce a search in the database with a text field for every field of the db. The results should be combining the fields (1 or 2 or 3 or 4 or all together). Can it be done with Mysql? In such a case how it should be the sintax? Thanks Quote Link to comment https://forums.phpfreaks.com/topic/169527-help-with-query/ Share on other sites More sharing options...
BLaZuRE Posted August 10, 2009 Share Posted August 10, 2009 What I understand from your question is: You want to search your database, using a text box with text input from a user. The result prints the fields together, if present in the database. Yes you can do this. You need to use a <form> to do this, with a submit button and get or post data. You search your database, using your post data and looking for it in each corresponding field. The results print to screen using any html formatting you want. (remember, you also always need PHP to complement MySQL) Quote Link to comment https://forums.phpfreaks.com/topic/169527-help-with-query/#findComment-894528 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.