Jump to content

how do they....


nelquintin

Recommended Posts

here my code
<?php
mysql_connect("localhost","user","pass");
mysql_select_db("vap");  ?>
<style type="text/css">
<!--
.style1 {color: #000000}
-->
</style>

<table width="300" border="1" bgcolor="#9900FF">

<?
$type = $_POST["type"];
$price = $_POST["price"];
$minprice = $_POST["minprice"];
$maxprice = $_POST["maxprice"];
$query = "SELECT * FROM propertys WHERE type LIKE '%".$_POST['type']."%' AND price BETWEEN '".$_POST['minprice']."' AND '".$_POST['maxprice']."'";
$result = mysql_query($query);

if (mysql_num_rows($result)) {
    while ($row = mysql_fetch_array($result)) {
        $picture = $row["picture"];
        $price = $row["price"];
        $ref = $row["ref"];
        $type = $row["type"];
        $erf = $row["erf"];
        $size = $row["size"];
        $bed = $row["bed"];
        $bath = $row["bath"];
        $gar = $row["gar"];
?>
  <tr>
    <td width="150"><span class="style1"><?php echo "<image src=\"$picture ","\" style=\"border: 2px solid black;\">

"; ?></span></td>
    <td width="150"><span class="style1"><?php echo $ref['ref']; ?></span></td>
  </tr>

<?

  }
}
?>

all i need to do now is just add on a "click here for more details" which will open another page with more details.could any one please help my designer left this project half way and im trying to finish it myself.
Link to comment
https://forums.phpfreaks.com/topic/22118-how-do-they/
Share on other sites

thank you for that now i just want to dispaly the results in a new page. i tried this
<td width="150"><span class="style1"><a href="moredetails.php?'.$row['picture'].'&row='.$row['ref'].'"" title="More Details">Click here for more details</a><?php echo $ref['ref']; ?></span></td>
  </tr>
and then on moredetails.php
<?php
mysql_connect("localhost","user","pass");
mysql_select_db("vap");  ?>
$picture = $_GET['picture'];
$ref = $_GET['ref'];
<?
thanks again for your help.
Link to comment
https://forums.phpfreaks.com/topic/22118-how-do-they/#findComment-99512
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.