Simple Formatting

[zmack]

Hi Guys, this question is purely cosmetic. I had read some post archives in the forum but still didnt quiet understand how too do it. Id like to format the output of the code below so that each result is nicely TABED away from its Heading, i want it too apply for all field results. For instance:

Area Code: 74348
City Name: blah blah
.
.

NOT

Area Code:90210 <----------this is what i get.

I've tried playing with the %nbsp, but keep erroring. Please go easy on me, im a beginner.:-)

#########################################

$result = mysql_query("select * from cites");
if ($result)
{
while ($row = mysql_fetch_array($result))
{

print "<b>Area Code:</b>";
print $row["area code"];
print "<br>\n";
print "<b>City name:</b>";
print $row["city"];
print "<br>\n";
print "<b>District:</b>";
print $row["district"];
print "<br>\n";
}
mysql_free_result($result);
}

[marcel]

You mean `&nbsp;' ?

echo 'Area Code:&nbsp;&nbsp;'.$row["area code"];
// and so on

PM

[Anon]

You mean:
tab or space?
Space, just add a space..

print "Area Code: ";

[zmack]

Hi Marcel and Chris,

I have tried both your suggestions, it still aint budging. With Christophers suggestion, i get a blank output if i put spaces in the code as such:-

print "Area Code: ";

Marcel - i get the same issue that i had initially, the records dont move at all.

ideally i'd like the output to show

City Name: (NICE TABS ENTERED HERE) London

as it stands, the output currently is :-
city name:London

Your suggestions are/were greatfully received.

-Abi

[kidestranged]

The best way to do this is to put the informatoin in cells in a table. This way the alignment will always be perfect.

$acode = $row["area code"];
$city = $row["city"];
$dist = $row["district"];
echo"
<table>
<tr>
<td align=right>Area Code:&nbsp;</td>
<td>$acode<td>
</tr><tr>
<td align=right>Your City:&nbsp;</td>
<td>$city</td>
</tr><tr>
<td align=right>District:&nbsp;</td>
<td>$dist</td>
</tr>
</table>";

[Anon]

If you don't want to use tables, you can get away with spaces within the quotes as stated earlier:

print "Area Code: $var";

or you can use print "Area Code:&nbsp;&nbsp;"
Remember the semicolon or it won't work for Netscape.

-Justin

[zmack]

Guys,

You have 'all' been great. I finally have it working with the use of tables. In turn, I hope to be of benefit to the php coding forum in the future.

Kind Regards

-Abi

[marcel]

sorry, looks like in the forum they don't escape `&amp;'
so, you should use(replace): &amp;nbsp; instead [SPACE]

echo 'Area Code:&amp;nbsp;&amp;nbsp;'.$row["area code"];
[this s what I meant to say in prev message]

PM