[Resolved] Formatting question

[Dolemite50]

Hello,
I have a table that echos a row of a list of 5 items that are numbered 1-5 like so:

$i = 1;
while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {
$stitle = prepOut($row['stitle']);
$songid	= $row['songid'];							
echo "<font color=\"#FFFFFF\">$i. </font><a href=\"song.php?songid=$songid\">$stitle<br></a>";
$i++;

This works great but just one problem. If the song title is long, and the word wrap kicks in, it aligns the rest of the text under the # instead of under the rest of the text. In other words it looks like this:

1. The song title
   is long.

but I want it to be:

1. The song title
   ....is long.
   (without the periods)

Any suggestions?

Thanks

[LarsLai]

just put your $i in one table cell and your text in another:

$i = 1; 
while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { 
$stitle = prepOut($row['stitle']); 
$songid    = $row['songid'];                             

echo "<tr><td><font color=\"#FFFFFF\">$i.</font></td><a href=\"song.php?songid=$songid\"><td>$stitle</td></tr></a>"; 
$i++;

a more elegant way of course is doing your layout with css

[tsinka]

Hi,

alternatively, use an ordered list:

echo "<ol>\n";
while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {
$stitle = prepOut($row['stitle']);
$songid    = $row['songid'];                           

echo "<li style=\"color:#FFFFFF\">";
echo "<font style=\"color:#000000\"><a href=\"song.php?songid=$songid\">"
    ."$stitle</a><br></font></li>\n";
}
echo "</ol>\n";

Thomas

[Dolemite50]

Thanks alot for the help.

Thomas, I tried your list idea and that was exactly what I want except for one thing. It seems to space the contents out within the cell. Is there a way to get it to align better?
It looks like this:

.....1....The song
...........title is
...........long.
.....2....The song
...........title is
...........long.
(without the periods)

instead of this:
1. The song title
is long.

Is there a remedy for this or is this just the nature of a numbered list.

Thanks again, I really appreciate it.

<td width="108" height="48" align="left" valign="top" bgcolor="#333333" class="hotNames">
			<?php 
			$getInfo = "SELECT stitle, songid FROM songs ORDER BY sdate DESC LIMIT 5";
						$rs = mysql_query($getInfo, $conn) or die(mysql_error());
						if(mysql_num_rows($rs)) { 
						$i = 1;
						echo "<ol>\n"; 
						while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { 
						$stitle = prepOut($row['stitle']); 
						$songid    = $row['songid'];                            

						echo "<li style=\"color:#FFFFFF\">"; 
						echo "<font style=\"color:#000000\"><a href=\"song.php?songid=$songid\">" 
							."$stitle</a><br></font></li>\n"; 
						} 
						echo "</ol>\n";
						$i++;
						}
			?>

[Dolemite50]

Hi,
I eventually got the split table method to go.

thanks again for the help.

[LarsLai]

hi!
although you seem to be satisfied, I would like to give a hint about formatting the list: use CSS.
you already have it in use:

"<li style=\"color:#FFFFFF\">

but you can do much much more than formatting only the color of your font with this.