> 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
What does the print_r() actually look like? Make sure the cases match,
$row->Test is not the same as $row->TEST.
---John Holmes...
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
