Hi all,
Thanks in advance for any help.
I am new to php and mysql but doing my best, I am currently working on a form that allows users to select certain data then displaying any data in the table that matches those form fields, I almost there but cant seem to get my php to match data from forms with data from my database, Here is my code... please be gentle
The underline part throws me an error but i think its because i am not selecting any data to be shown???
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$sqlwhere = "WHERE (member_id)";
if (isset($_POST[‘city’])){
$sqlwhere .= " AND city=’{$_POST[‘city’]}’";
}
if (isset($_POST[‘state’])) {
$sqlwhere .= " AND state=’{$_POST[‘state’]}’";
}
if (isset($_POST[‘zip’])) {
$sqlwhere .= " AND zip=' {$_POST[‘zip’]}'";
}
$sql = "SELECT * FROM members" . $sqlwhere;
echo "<p>$sqlwhere = " . $sqlwhere . "</p>\n";
echo "<p>$sql = " . $sql . "</p>\n";
$result = mysql_query($sql);
$numrows = mysql_num_rows($result);
if(0<$numrows){
$row = mysql_fetch_array($result,MYSQL_ASSOC);
}
{
echo "<table border='1'>
<tr>
<th>First Name</th>
<th>Last Name</th>
<th>City</th>
<th>State</th>
<th>Days Available</th>
<th>Preferred Exercise</th>
<th>Gender</th>
<th>Age</th>
<th>Email Address</th>
<th> Zip </th>
</tr>";
echo "<tr>";
echo "<td>" . $row['firstname'] . "</td>";
"<td>" . $row['lastname'] .
"<td>" . $row['city'] .
"<td>" . $row['state'] .
"<td>" . $row['daysavailable'] .
"<td>" . $row['preferredexercise'] .
"<td>" . $row['gender'] .
"<td>" . $row['age'] .
"<td>" . $row['emailaddress'] .
"<td>" . $row['zip'] ;
echo "</tr>";
}
echo "</table>";
?>
</div>
<div id="findbuddyform">
<form id="updateprofile" name="updateprofile" method="post" action="findbuddies.php">
<INPUT TYPE="hidden" NAME="fuseaction" VALUE="ViewResults">
<table width="300" border="0" align="left" cellpadding="2" cellspacing="0">
<!--DWLayoutTable-->
<tr><th width="145" height="26">City</th>
<td width="147">
<input name="city" type="text" class="textfield" id="city"/></td>
</tr>
<tr>
<th height="26">State</th>
<td><input name="state" type="text" class="textfield" id="state" /></td>
</tr>
<tr>
<th height="26"> Zip </th>
<td><input name="zip" type="text" class="intfield" id="zipcode" /></td>
</tr>
<tr><th height="26"> Gender</th>
<td><input name="gender" type="text" class="text" id="gender"/></td>
</tr>
<td height="4" colspan="2" valign="top"> </tr>
</table></td>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p>(Select as many as you like.)<br />
<strong>Exercise Preferences</strong>:</p>
<p>
<input type="checkbox" id="$preferredexercise[]" value="0" />
Running<br />
<input type="checkbox" id="$preferredexercise[]" value="1" />
Walking<br />
<input type="checkbox" id="$preferredexercise[]" value="2" />
Swimming<br />
<input type="checkbox" id="preferredexercise[]" value="3" />
Yoga<br />
<input type="checkbox" id="preferredexercise[]" value="4" />
Weightlifting<br />
<input type="checkbox" id="preferredexercise[]" value="5" />
Tennis<br />
<input type="checkbox" id="preferredexercise[]" value="6" />
Basketball<br />
<input type="checkbox" id="preferredexercise[]" value="7" />
Soccer<br />
<input type="checkbox" id="preferredexercise[]" value="8" />
Bicycling<br />
<input type="checkbox" id="preferredexercise[]" value="9" />
Mountain Biking<br />
<input type="checkbox" id="preferredexercise[]" value="10" />
Hiking<br />
<input type="checkbox" id="preferredexercise[]" value="11" />
Volleyball<br />
<input type="checkbox" id="preferredexercise[]" value="12" />
Pilate's<br />
<input type="checkbox" id="preferredexercise[]" value="13" />
Other<br />
<input type="checkbox" id="preferredexercise[]" value="14" />
Many Exercises<br />
(Select as many as you like.)<br />
</p>
<tr> <td class="lbl" align="left"><strong>My Buddies age is between</strong> </td>
<td class="select"> <p>
<select name="age" id="age" class="sel">
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
<option value="32">32</option>
<option value="33">33</option>
<option value="34">34</option>
<option value="35">35</option>
<option value="36">36</option>
<option value="37">37</option>
<option value="38">38</option>
<option value="39">39</option>
<option value="40">40</option>
<option value="41">41</option>
<option value="42">42</option>
<option value="43">43</option>
<option value="44">44</option>
<option value="45">45</option>
<option value="46">46</option>
<option value="47">47</option>
<option value="48">48</option>
<option value="49">49</option>
<option value="50">50</option>
<option value="51">51</option>
<option value="52">52</option>
<option value="53">53</option>
<option value="54">54</option>
<option value="55">55</option>
<option value="56">56</option>
<option value="57">57</option>
<option value="58">58</option>
<option value="59">59</option>
<option value="60">60</option>
<option value="61">61</option>
<option value="62">62</option>
<option value="63">63</option>
<option value="64">64</option>
<option value="65">65</option>
<option value="66">66</option>
<option value="67">67</option>
<option value="68">68</option>
<option value="69">69</option>
<option value="70">70</option>
<option value="71">71</option>
<option value="72">72</option>
<option value="73">73</option>
<option value="74">74</option>
<option value="75">75</option>
<option value="76">76</option>
<option value="77">77</option>
<option value="78">78</option>
<option value="79">79</option>
<option value="80">80</option>
<option value="81">81</option>
<option value="82">82</option>
<option value="83">83</option>
<option value="84">84</option>
<option value="85">85</option>
<option value="86">86</option>
<option value="87">87</option>
<option value="88">88</option>
<option value="89">89</option>
<option value="90">90</option>
<option value="91">91</option>
<option value="92">92</option>
<option value="93">93</option>
<option value="94">94</option>
<option value="95">95</option>
<option value="96">96</option>
<option value="97">97</option>
<option value="98">98</option>
<option value="99">99</option>
<option value="100">100</option>
</select>
<td class="select">
And
<select name="age" id="age" class="sel">
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
<option value="32">32</option>
<option value="33">33</option>
<option value="34">34</option>
<option value="35">35</option>
<option value="36">36</option>
<option value="37">37</option>
<option value="38">38</option>
<option value="39">39</option>
<option value="40">40</option>
<option value="41">41</option>
<option value="42">42</option>
<option value="43">43</option>
<option value="44">44</option>
<option value="45">45</option>
<option value="46">46</option>
<option value="47">47</option>
<option value="48">48</option>
<option value="49">49</option>
<option value="50">50</option>
<option value="51">51</option>
<option value="52">52</option>
<option value="53">53</option>
<option value="54">54</option>
<option value="55">55</option>
<option value="56">56</option>
<option value="57">57</option>
<option value="58">58</option>
<option value="59">59</option>
<option value="60">60</option>
<option value="61">61</option>
<option value="62">62</option>
<option value="63">63</option>
<option value="64">64</option>
<option value="65">65</option>
<option value="66">66</option>
<option value="67">67</option>
<option value="68">68</option>
<option value="69">69</option>
<option value="70">70</option>
<option value="71">71</option>
<option value="72">72</option>
<option value="73">73</option>
<option value="74">74</option>
<option value="75">75</option>
<option value="76">76</option>
<option value="77">77</option>
<option value="78">78</option>
<option value="79">79</option>
<option value="80">80</option>
<option value="81">81</option>
<option value="82">82</option>
<option value="83">83</option>
<option value="84">84</option>
<option value="85">85</option>
<option value="86">86</option>
<option value="87">87</option>
<option value="88">88</option>
<option value="89">89</option>
<option value="90">90</option>
<option value="91">91</option>
<option value="92">92</option>
<option value="93">93</option>
<option value="94">94</option>
<option value="95">95</option>
<option value="96">96</option>
<option value="97">97</option>
<option value="98">98</option>
<option value="99">99</option>
<option value="100">100</option>
</select>
<p><strong>My Days Available:</strong><br />
<form method="post" action="findbuddies.php">
<p>
<input type="checkbox" id="daysavailable[]" value="monday" />
Monday<br />
<input type="checkbox" id="daysavailable[]" value="tuesday" />
Tuesday<br />
<input type="checkbox" id="daysavailable[]" value="wednsday" />
Wednesday<br />
<input type="checkbox" id="daysavailable[]" value="thursday" />
Thursday<br />
<input type="checkbox" id="daysavailable[]" value="friday" />
Friday<br />
<input type="checkbox" id="daysavailable[]" value="saturday" />
Saturday<br />
<input type="checkbox" id="daysavailable[]" value="sunday" />
Sunday<br />
<input type="checkbox" id="daysavailable[]" value="mornings" />
Mornings<br />
<input type="checkbox" id="daysavailable[]" value="evenings" />
Evenings<br />
<input type="checkbox" id="daysavailable[]" value="itchanges" />
It changes<br />
<br />
<input type="submit" name ="submit" value="Search"
onclick="if(updateprofile.state.value.length==0) alert('You must at least enter a state!!'); else updateprofile.submit();"
/>
</p>
<input type="reset" name="reset" value="Reset">
</form>
</div>
<div id="footer">
<?php require("footer.php"); ?>
</div>
</body>
</div>
