Soz forgt to post me code, thats what happens when your girl freind is nagging the backside of me
- PHP: Select all
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>search</title>
</head>
<body>
<?php
$link = mysql_connect("localhost","root","longstand1");
mysql_select_db("dbsignup", $link) or die("Unable to select database");
#
$selectSql1 = "SELECT * FROM customer WHERE gender = '".mysql_real_escape_string($_POST['gender'])."'
AND area = '".mysql_real_escape_string($_POST['area'])."'";
$result = mysql_query($selectSql1, $link) or die(mysql_error());
while($row = mysql_fetch_assoc($result)) { ?>
<?php
echo '<pre>';
print_r($row);
echo '</pre>';
}
mysql_close($link);
?>
<form action="Search_engine.php" method="post">
<table width="323" height="250" border="5" cellpadding="0" cellspacing="0">
<tr>
<td width="155"><div align="right">Gender:</div></td>
<td width="154"><label>
<select name="gender" id="gender">
<option>Male</option>
<option>Female</option>
</select>
</label></td>
</tr>
<tr>
<td><div align="right">Age:</div></td>
<td><label>
<select name="age" id="age">
<option>18</option>
<option>19</option>
<option>20</option>
<option>21</option>
<option>22</option>
<option>23</option>
<option>24</option>
<option>25</option>
<option>26</option>
<option>27</option>
<option>28</option>
<option>29</option>
<option>30</option>
<option>31</option>
<option>32</option>
<option>33</option>
<option>34</option>
<option>35</option>
<option>36</option>
<option>37</option>
<option>38</option>
<option>39</option>
<option>40</option>
<option>41</option>
<option>42</option>
<option>43</option>
<option>44</option>
<option>45</option>
<option>46</option>
<option>47</option>
<option>48</option>
<option>49</option>
<option>50</option>
<option>51</option>
<option>52</option>
<option>53</option>
<option>54</option>
<option>55</option>
<option>56</option>
<option>57</option>
<option>58</option>
<option>59</option>
<option>60</option>
<option>61</option>
<option>62</option>
<option>63</option>
<option>64</option>
<option>65</option>
<option>66</option>
<option>67</option>
<option>68</option>
<option>69</option>
<option>70</option>
<option>71</option>
<option>72</option>
<option>73</option>
<option>74</option>
<option>75</option>
<option>76</option>
<option>77</option>
<option>78</option>
<option>79</option>
<option>80</option>
<option>81</option>
<option>82</option>
<option>83</option>
<option>84</option>
<option>85</option>
<option>86</option>
<option>87</option>
<option>88</option>
<option>89</option>
<option>90</option>
<option>91</option>
</select>
</label></td>
</tr>
<tr>
<td><div align="right">Height</div></td>
<td><label>
<select name="height_one" id="height_one">
<option>3</option>
<option>4</option>
<option>5</option>
<option>6</option>
<option>7</option>
<option>8</option>
</select>
To
<select name="height_two" id="height_two">
<option>1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
<option>6</option>
<option>7</option>
<option>8</option>
<option>9</option>
<option>10</option>
<option>11</option>
</select>
</label></td>
</tr>
<tr>
<td><div align="right">Hair Colour:</div></td>
<td><label>
<select name="hair_colour" id="hair_colour">
<option>Black</option>
<option>Brown</option>
<option>Blonde</option>
<option>Red</option>
<option>Auburn</option>
<option>Other</option>
</select>
</label></td>
</tr>
<tr>
<td><div align="right">Area:</div></td>
<td><label>
<select name="area" id="area">
<option>England-Bath Avon</option>
<option>England-Bedforshire</option>
<option>England-Berkshire</option>
<option>England-Brighton</option>
<option>England-Bristol</option>
<option>England-Buckinghamshire</option>
<option>England-Cambridgeshire</option>
<option>England-Channel Isles</option>
<option>England-Cheshire</option>
<option>England-Cornwall</option>
<option>England-County Durham</option>
<option>England-Cumbria</option>
<option>England-Derbyshire</option>
<option>England-Devon</option>
<option>England-Dorset</option>
<option>England-Essex</option>
<option>England-Gloucestershire</option>
<option>England-Hampshire</option>
<option>England-Herefordshire</option>
<option>England-Huntingdonshire</option>
<option>England-Isle Of White</option>
<option>England-Isle Of Sily</option>
<option>England-Kent</option>
<option>England-Lancashire</option>
<option>England-Leicestershire</option>
<option>England-Lincolnshire</option>
<option>England-London</option>
<option>England-Manchester</option>
<option>England-Merseyside</option>
<option>England-Middlesex</option>
<option>England-Norfolk</option>
<option>England-Northamptonshire</option>
<option>England-Northumberland</option>
<option>England-Nottinghamshire</option>
<option>England-Oxfordshire</option>
<option>England-Rutland</option>
<option>England-Shropshire</option>
<option>England-Somerset</option>
<option>England-Staffordshire</option>
<option>England-Suffolk</option>
<option>England-Surrey</option>
<option>England-Sussex</option>
<option>England-Tyne & Wear</option>
<option>England-Warwickshire</option>
<option>England-West midlands</option>
<option>England-Westmorland</option>
<option>England-Wiltshire</option>
<option>England-Worcestershire</option>
<option>England-Yorkshire</option>
<option>Isle Of Man</option>
<option>N Ireland-Artrim</option>
<option>N Ireland-Amagh</option>
<option>N Ireland-Bellfast</option>
<option>N Ireland-Down</option>
<option>N-Ireland-Femanagh</option>
<option>N-Ireland-Londondery</option>
<option>N-Ireland-Tyrone</option>
<option>Scotland-Aberdeenshire</option>
<option>Scotland-Angus</option>
<option>Scotland-Argylshire</option>
<option>Scotland-Ayrshire</option>
<option>Scotland-Banffshire</option>
<option>Scotland-Berwicshire</option>
<option>Scotland-Buteshire</option>
<option>Scotland-Caithness</option>
<option>Scotland-Clackmannanshire</option>
<option>Scotland-Dumfriesshire</option>
<option>Scotland-Dundee city</option>
<option>Scotland-Edinburgh</option>
<option>Scotland-Falkirk</option>
<option>Scotland-Fife</option>
<option>Scotland-Highland</option>
<option>Scotland-Inverness-shire</option>
<option>Scotland-Isle of Islay</option>
<option>Scotland-Isle of Lewis</option>
<option>Scotland-Isle of Skye</option>
<option>Scotland-Kincarineshire</option>
<option>Scotland-Kinross-shire</option>
<option>Scotland-Kirkcudbrightshire</option>
<option>Scotland-Lanarkshire</option>
<option>Scotland-Midlothian</option>
<option>Scotland-Morayshire</option>
<option>Scotland-Naimshire</option>
<option>Scotland-Orkney</option>
<option>Scotland-Peeblesshire</option>
<option>Scotland-Perthshire</option>
<option>Scotland-Renfrewshire</option>
<option>Scotland-Ross-shire</option>
<option>Scotland-Roxburghshire</option>
<option>Scotland-Selkirkshire</option>
<option>Scotland-Shetland</option>
<option>Scotland-Sterlingshire</option>
<option>Scotland-Sutherland</option>
<option>Scotland-West Lothiann</option>
<option>Scotland-Western Isles</option>
<option>Scotland-Wigtownshire</option>
<option>Wales-Anglesey</option>
<option>Wales-Brecknockshire</option>
<option>Wales-Caemarfonshire</option>
<option>Wales-Cardiff</option>
<option>Wales-Cardiganshire</option>
<option>Wales-Carmarthenshire</option>
<option>Wales-Ceredigion</option>
<option>Wales-Denbighshire</option>
<option>Wales-Flintshire</option>
<option>Wales-Glamorgan</option>
<option>Wales-Gwynedd</option>
<option>Wales-Merioneth</option>
<option>Wales-Monmouthshire</option>
<option>Wales-Montgomeryshire</option>
<option>Wales-Newport</option>
<option>Wales-Pembrokeshire</option>
<option>Wales-Radnorshire</option>
<option>Wales-Swansea</option>
</select>
</label></td>
</tr>
<tr>
<td><div align="right">Work Interested:</div></td>
<td><label>
<select name="desired_work" id="desired_work">
<option>Look-A-Likes</option>
<option>Models & Glamour</option>
<option>Actors & TV Extras</option>
<option>Singers & Vocalists</option>
<option>Theatre & Musicals</option>
<option>Producers&Aegents</option>
</select>
</label></td>
</tr>
</table>
<input type="submit" />
</form>
</body>
</html>