----- Original Message -----
From: yousuf hussain
</table>
</form>
</td>
</tr>
</table>
</body>
</html>
....................................................................................................................
<?php
$searchText = $_REQUEST["search"];
include "header.php";
?>
include "connection.php";
if($searchText=="syard"){
$mySQL = "select * from addbunglow where syard='$searchText' and
isactive=1 order by bangid";
echo "syard:".$searchText;
}
else if($searchText=="price"){
$mySQL = "select * from addbunglow where price='$searchText' and
isactive=1 order by bangid";
echo "price:".$searchText;
}
else {
$mySQL = "select * from addbunglow where unit='$searchText' and
isactive=1 order by bangid";
echo "unit:".$searchText;
}
$result = mysql_query($mySQL);
$counter = 1;
while($row = mysql_fetch_array($result))
{
?>
<tr >
<td ><?php echo $counter;?></td>
<td ><?php echo $row["syard"];?></td>
<td ><?php echo $row["street"];?></td>
<td ><?php echo $row["phase"];?></td>
<td ><?php echo $row["unit"];?></td>
<td ><?php echo $row["catagory"];?></td>
<td ><?php echo $row["price"];?></td>
<td><?php echo $row["comments"];?></td>
</tr>
<?php
$counter = $counter + 1;
If this is EXACTLY how you're code looks there seem to be some mistakes in
how some of your query variables are written....
...from addbunglow where unit='".$searchText "' and is active-1....
My understanding is you have to concatenate variables while writing your sql
queries
[Non-text portions of this message have been removed]
