It IS following your \n, but HTML doesn't know what a newline is. Do
a vbiew source and you'll see that it's got line breaks.
You need to use <BR> or <P> tags so that *HTML* knows what you want
from it.
As for property_type, print_r($row) in the while statement to see
what's coming out of the db.
--- Addison Ellis <[EMAIL PROTECTED]> wrote:
> 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
> [EMAIL PROTECTED]
> [EMAIL PROTECTED]
> subsidiaries of small independent publishing co.
> [EMAIL PROTECTED]
> [EMAIL PROTECTED]
=====
Mark Weinstock
[EMAIL PROTECTED]
***************************************
You can't demand something as a "right" unless you are willing to fight to death to
defend everyone else's right to the same thing.
-Stolen from the now-defunct Randy's Random mailing list.
***************************************
__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php