Code: Select all
andCode: Select all
tags where approriate when posting code. Read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url][/color]
Im very new to PHP so please bear with me,
I am sampling a web site based on an estate agent. I am using it to work on forms and submitting quries (with no joy). I have done the database and have done an index that displays all results and have set up an admin page to delete, edit or remove the data, these all work fine.
I have created the "houses" database and have added a table called "sales" with the following fields (7)Code: Select all
id
address
area
bedrooms
price
description
imageCan someone help me with the coding or give some advice, have been working on this for the last few weeks and have made no progress...............maybe im looking into it too deep
Code: Select all
<?php require_once('Connections/myConnection.php'); ?>
<?php
mysql_select_db($database_myConnection, $myConnection);
$query_area = "SELECT area, count(*) as count FROM sale GROUP BY area ORDER BY area ASC";
$area = mysql_query($query_area, $myConnection) or die(mysql_error());
$row_area = mysql_fetch_assoc($area);
$totalRows_area = mysql_num_rows($area);
?>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<table width="90%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><img src="images_1/logo.jpg" width="600" height="100"></td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
</table>
<div align="center"> </div>
<form name="form1" method="post" action="results.php">
<table width="90%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td colspan="6"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Please
enter your search criteria below.</font></td>
</tr>
<tr>
<td width="20%"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"> </font></td>
<td colspan="5"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"> </font></td>
</tr>
<tr>
<td><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Minimum
Price range</font></td>
<td colspan="3"><select name="Minprice" id="price">
<option value="20000">£20'000</option>
<option value="30000">£30'000</option>
<option value="40000">£40'000</option>
<option value="50000">£50'000</option>
<option value="55000">£55'000</option>
<option value="60000">£60'000</option>
<option value="65000">£65'000</option>
<option value="70000">£70'000</option>
<option value="75000">£75'000</option>
<option value="80000">£80'000</option>
<option value="85000">£85'000</option>
<option value="90000">£90'000</option>
<option value="95000">£95'000</option>
<option value="100000">£100'000</option>
<option value="105000">£105'000</option>
<option value="110000">£110'000</option>
<option value="115000">£115'000</option>
<option value="120000">£120'000</option>
<option value="125'000">£125'000</option>
<option value="130'000">£130'000</option>
<option value="135000">£135'000</option>
<option value="140000">£140'000</option>
<option value="140000">£145'000</option>
<option value="150000">£150'000</option>
<option value="155000">£155'000</option>
<option value="160000">£160'000</option>
<option value="165000">£165'000</option>
<option value="170000">£170'000</option>
<option value="175000">£175'000</option>
<option value="180000">£180'000</option>
<option value="185000">£185'000</option>
<option value="190000">£190'000</option>
<option value="195000">£195'000</option>
<option value="200000">£200'000</option>
<option value="250000">£250'000</option>
<option value="300000">£300'000</option>
<option value="350000">£350'000</option>
<option value="400000">£400'000</option>
<option value="450000">£450'000</option>
<option value="500000">£500'000</option>
<option value="550000">£550'000</option>
<option value="600000">£600'000</option>
</select> <font size="2" face="Verdana, Arial, Helvetica, sans-serif"> </font></td>
<td width="18%"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Maximum
Price Range</font></td>
<td width="38%"><select name="Maxprice" id="price">
<option value="600000">£600'000</option>
<option value="550000">£550'000</option>
<option value="500000">£500'000</option>
<option value="450000">£450'000</option>
<option value="400000">£400'000</option>
<option value="350000">£350'000</option>
<option value="300000">£300'000</option>
<option value="250000">£250'000</option>
<option value="200000">£200'000</option>
<option value="180000">£180'000</option>
<option value="160000">£160'000</option>
<option value="140000">£140'000</option>
<option value="135000">£135'000</option>
<option value="130000">£130'000</option>
<option value="125000">£125'000</option>
<option value="120000">£120'000</option>
<option value="115000">£115'000</option>
<option value="110000">£110'000</option>
<option value="105000">£105'000</option>
<option value="100000">£100'000</option>
<option value="95000">£95'000</option>
<option value="90000">£90'000</option>
<option value="85000">£85'000</option>
<option value="80000">£80'000</option>
<option value="75000">£75'000</option>
<option value="70000">£70'000</option>
<option value="65000">£65'000</option>
<option value="60000">£60'000</option>
<option value="55000">£55'000</option>
<option value="50000">£50'000</option>
<option value="45000">£45'000</option>
<option value="40000">£40'000</option>
<option value="35000">£35'000</option>
<option value="30000">£30'000</option>
</select></td>
</tr>
<tr>
<td><font size="2" face="Verdana, Arial, Helvetica, sans-serif"> </font></td>
<td colspan="5"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"> </font></td>
</tr>
<tr>
<td><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Bedrooms</font></td>
<td colspan="5"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
<select name="bedrooms" id="bedrooms">
<option value="any">Any</option>
<option value="1>">1+</option>
<option value="2>">2+</option>
<option value="3>">3+</option>
<option value="4>">4+</option>
<option value="5>">5+</option>
</select>
</font></td>
</tr>
<tr>
<td> </td>
<td colspan="5"> </td>
</tr>
<tr>
<td colspan="5"> </td>
<td> </td>
</tr>
</table>
<table width="90%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td colspan="4"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">*
If No area's are selected below you will receive property information
for all area's.</font></td>
</tr>
<tr>
<td colspan="4"> </td>
</tr>
<tr>
<?php $horizcount=0; do {
$areaname = $row_area['area'];
if (!$areaname) { $areaname = "No Area"; }
$count = $row_area['count'];
echo "<td><input type="checkbox" value="$areaname"> $areaname ($count)</td>";
$horizcount +=1;
if ($horizcount == 4) { echo "</tr><tr>"; $horizcount=0; }
} while ($row_area = mysql_fetch_assoc($area)); ?>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td><input type="submit" name="Submit" value="Submit"></td>
</tr>
</table>
</form>
</body>
</html>
<?php
mysql_free_result($area);
?>feyd | Please use
Code: Select all
andCode: Select all
tags where approriate when posting code. Read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url][/color]