print

From: Date: Sun, 02 Feb 2003 21:15:11 +0000
Subject: print
Groups: php.db 
Request: Send a blank email to php-db+get-25347@lists.php.net to get a copy of this message
hi, i still am having a problem. can you see what is wrong with what i've got. and... thank you. best regards, addison ellis this is what is printing: 2Bedroom/2Bath great From Campus Available imm 500.00 Contact: 321-1791 it is not printing the property_type and it is not following my \n commands. here's the code: <?
    // Begin Ad Block
    $count = 0;
    $id = 50;
    $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}\n
          {$row->description}\n
          {$row->distance} From Campus
          Available {$row->date_available}\n
          {$row->price}\n
          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
?> thanks again... -- 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 (#25347) next »