print_r($row);

From: Date: Tue, 04 Feb 2003 13:07:41 +0000
Subject: print_r($row);
Groups: php.db 
Request: Send a blank email to php-db+get-25408@lists.php.net to get a copy of this message
hello, i do print_r($row); and all my data is printing properly from my db. however, with the below code only one row is not printing: {$row->property_type} thank you for your time. addison <?
    // Begin Ad Block
    $count = 0;
    $id = 45;
    $obj = mysql_db_query($dbname,"select a.*,s.name as subcategory_name,c.name as category_name from ads a,subcategory s,
    category c where a.subcategory=s.id and s.category=c.id and a.subcategory=$id and a.que='checked'");
    if ($obj && mysql_num_rows($obj)>0) {
        while($row = mysql_fetch_object($obj))
        {
            $count++;
?>
          <? echo "{$row->bedrooms}Bedroom/{$row->baths}Bath {$row->property_type}<br>
          {$row->description}<br>
          {$row->distance} from campus.<br>
          Available: {$row->date_available}<br>
          {$row->price}<br>
          Contact: {$row->contact}";
?>
          </font><font color="#000000" size="2" face="Arial, Helvetica, sans-serif"><br />
          <br>
          <img src="../images/thin_line.gif" width="185" height="1"><br>
          <br>
          <?
         }
     }
     // End Ad Block
?> this is what is printing: 2Bedroom/2Bath great place less than 5 miles From Campus Available immediately $500.00/month Contact: 321-1791 -- Addison Ellis small independent publishing co. 114 B 29th Avenue North Nashville, TN 37203 (615) 321-1791 addison@bellsouth.net info@smipco.com subsidiaries of small independent publishing co. info@gloabaldog.com info@momandpocentral.com

« previous php.db (#25408) next »