cs1h Posted September 6, 2007 Share Posted September 6, 2007 Hi, I'm new to php and Mysql, I am trying to develope a databse for travel reviews. So far people can submit articles to my database but I cannot get a search to work with the criteria I want. I have tried to find tutorials online but none of them do what I need. If any one can point me to one that would help or one give me some hints it would be much appriciated. My search form is as follows <body> <form id="form1" name="form1" method="post" action=""> <label> Select type of article you want <select name="lista" id="lista"> <option>News </option> <option>Magazine</option> <option>Listing</option> </select> <br /> Select Region <select name="listb" id="listb"> <option>Africa</option> <option>Asia</option> <option>Europe</option> <option>North America</option> <option>Oceania</option> <option>South America</option> </select> </label> <p>Search for a Keyword <label> <input type="text" name="keyword" id="keyword" /> </label> </p> </form> </body> And my database table is, Article_type VARCHAR 100, Place VARCHAR 100, Article TEXT . I want people to be able to select the article type, then select the places that they want and then matching words in the article. Any help would be much appriciated, Thanks, Colin Quote Link to comment Share on other sites More sharing options...
lemmin Posted September 6, 2007 Share Posted September 6, 2007 "... WHERE Article_type = $articletype AND Place = $place AND Article LIKE $search" I think that is what you are asking. Quote Link to comment 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.