All pastes #482341 Raw Edit

Jstr

public php v1 · immutable
·published 2007-05-11 06:49 UTC
rendered paste body
<?php     require_once('core/db.php');    $query = "select id,mls_number,price,bedrooms,bathrooms,sq_ft,address,city,state,description               from listing ORDER by id";     if ( $rs = mysql_query($query) ) {?><html> <head>  <title></title><link rel='stylesheet' type='text/css'  href='list.css' /> </head><body>           <?php           $i = 0;           $len = @mysql_num_rows($rs);           $cols = 1;            while ( $i < $len )           {            echo "<div id='frame'>";            for ($x = 0; $x < $cols; $x++, $i++)           {            if ( $row = mysql_fetch_array($rs, MYSQL_ASSOC) )			echo "<div class='spacer'>&nbsp;</div>";			echo "<div class='display_order'>". $row["id"] ."</div>";            echo "<div class='mls'>MLS #:". $row["mls_number"] ."</div>";            echo "<div class='price'>". $row["price"] ."</div>";            echo "<div class='bed'>Bedrooms:". $row["bedrooms"] ."</div>";            echo "<div class='bath'>Bathrooms:". $row["bathrooms"] ."</div>";            echo "<div class='sq_ft'>Sq. Ft:". $row["sq_ft"] ."</div>";            echo "<div class='img'>House Image</div>";            echo "<div class='address'>". $row["address"] ."<br />"			. $row["city"] ."&nbsp;" . $row["state"] ."&nbsp;" . $row["zipcode"] ."</div>";            echo "<div class=\"details\">";            echo "<a href=\"listing_details.php?id=\"". $row["id"] ."\">Property Details</a></div>"; echo "<div class='clear'>&nbsp;</div>";           }            echo "</div>";           }         ?>         <? }?></table></body></html>