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 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) Link to comment https://forums.phpfreaks.com/topic/169527-help-with-query/#findComment-894528 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.