nade93 Posted March 19, 2009 Share Posted March 19, 2009 Hi all I am trying to create a search form I want to search by the following things Gender - drop down options Activities - mulitple select checkbox The pre existing data would be in he form of this in the Mysql DB so the User id relates to all info relating to that member. the vlau is what needs to be searched and all matching entries need to be pulled out and displayed in the search results. table_1 id user_id field_id value 36 62 17 Horse riding, reading, writing, movies, television 37 62 2 Female 38 63 17 reading, writing, movies, television 37 63 2 Male this then needs to be joined with a second table that hols the members details table_2 userid status avatar thumb 62 none default.jpg default_thumb.jpg I then want to be able to display the results as such echo "<table width="100%" border="0" cellspacing="0" cellpadding="4"> <tr> <td rowspan="2"><img src='www.yourdomain.com/".$row['avatar']."'></td> <td>".row['value']."</td> </tr> <tr> <td> </td> </tr> </table> Can any one help e out please really stuck search high and low and just cannot seem to get it to work! Quote Link to comment https://forums.phpfreaks.com/topic/150127-search-form-to-search-database/ Share on other sites More sharing options...
nade93 Posted March 21, 2009 Author Share Posted March 21, 2009 sorry to bump but still struggling, anyone got any ideas please? Quote Link to comment https://forums.phpfreaks.com/topic/150127-search-form-to-search-database/#findComment-790342 Share on other sites More sharing options...
fenway Posted March 27, 2009 Share Posted March 27, 2009 You've stored multiple keywords in a single field... show the query you're using now. Quote Link to comment https://forums.phpfreaks.com/topic/150127-search-form-to-search-database/#findComment-795261 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.