Steve Gerbitz

<?php include("top.php");  if(isset($_POST['Submit'])) { $USERNAME = $_POST['USERNAME'];$COUNTRY = $_POST['COUNTRY'];	$countryState = explode(":", $COUNTRY);	$COUNTRY = $countryState[0];	$STATE = $countryState[1];$GEN = $_POST['GEN'];$query = mysql_query("SELECT * FROM users WHERE USERNAME LIKE '%$USERNAME%' AND STATE LIKE '$STATE' AND COUNTRY LIKE '$COUNTRY' AND GEN LIKE '$GEN' ORDER BY USERNAME DESC ") or DIE("ERROR <br><br> " . mysql_error());while ($data = mysql_fetch_array($query)) {?><table width="540" cellpadding="5" cellspacing="1" border="0"><tr>  <td width="100"><div align="center"><img src="<?php if ($data['PHOTO_URL']) { echo $data['PHOTO_URL']; } else { echo './images/no_pic.gif'; }?>" width="75" height="75"></div></td>  <td width="83"><p align="center"><b>Username: </b><u><br>  </u><b>Gender: </b><b><br>      State/Prov: </b><b>      <br>    Country: </b></p>    </td>  <td width="323"><p><u>    <?=$data['USERNAME'];?>    </u><br>    <u>      <?=$data['GEN'];?>      </u><br>    <u>      <?=$data['STATE'];?>      </u><br>      <u>      <?=$data['COUNTRY'];?>      <br>      </u></p>    </td><tr>	<td colspan="3"><center>	  <a href="gallery_profile.php?USERNAME=<?=$data['USERNAME'];?>">Look at This User's Profile</a>    </center></td>  </tr></table><?PHP}?><br><br><p>Return to <a href="search.php">Back to Search Page</a><center></P><?PHP} else {?><center><form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>"><table width="424" border="0">  <tr>    <td colspan="2"><font face="verdana, arial, geneva, helvetica" size="-1">      <div align="center"> <strong><br>                   <center>           <span class="style4">BBWnetwork Gallery</span></strong></div></td>  </tr>  <tr>    <td colspan="2"><div align="center"><em><strong>Search Our Gallery </strong></em></div></td>    </tr>  <tr>    <td><strong>Username:</strong></td>    <td><input type="text" name="USERNAME"></td>    </tr>  <tr>	<td><strong>Gender:</strong></td>	<td><select name="GEN">		<option value="">Select a Gender</option>		<option value="MALE">MALE</option>		<option value="FEMALE">FEMALE</option>		<option value="OTHER">OTHER</option>	    </select></td>    </tr><tr>	<td><strong>Location:</strong></td>	<td><select name="COUNTRY">          <option value="">Select Your Country </option>	          <?php $query = mysql_query("SELECT * FROM `country` ORDER BY country ASC") or DIE("ERROR <br><br> " . mysql_error());while($data = mysql_fetch_array($query)){	echo "<option value=\"".$data['COUNTRY']."\"> ".$data['COUNTRY']."</option>";	$countryForQuery = $data['ID'];		$result = mysql_query("SELECT * FROM `stateprovs` WHERE `country`='$countryForQuery' ORDER BY `name` ASC");		if (mysql_num_rows($result) != 0)		{			while ($row = mysql_fetch_assoc($result))			{				echo "<option value=\"".$data['COUNTRY'].":".$row['name']."\"> &nbsp;&nbsp;- " . $row['name'] . "</option>";			}		}}		?>        </select>	</td>    </tr>  <tr>    <td width="123"><input type="submit" name="Submit" value="Submit"></td>    <td width="291">&nbsp;</td>    </tr></table></form></center><p> Do you want to <a href="register.php">register</a>?</p><?php}include("bottom.php"); ?>