[Resolved] Space when swithing from a to b as start letter an so on

[MichaelHe]

I have a simpel list from a database scripted like this

$sql = "SELECT * FROM Titler WHERE 1 $opt1 $opt2 $opt3 $opt4 ORDER BY `Titel`";
$result = mysql_query($sql);
{
while ($row = mysql_fetch_array($result)) {

?>

  <tr>
     <td width='200'><?echo "<a href=\"Sangdata.php?Titel=$titel\">$titel</a>";?></td> 
    <td width= '60'><?echo $row['Stil'];?></td> 
    <td width= '70'><?echo $row['Hastighed'];?></td>
    <td width='120'><?echo $row['Kvalitet'];?></td>
   </tr>
<?;
}}

It is ordered by Title and I wish to have a blank space when the start letter changes, so it lookes like this ex.

Bring Me Back
Bring Us Back Again

Dream
Drømme

Er Du Fri

Let The Peace Into Your Heart
Looking For A Love

How do I do that... I can't seem to figure it out...

Michael

[devinemke]

a simple example:

<?php
$sql = 'SELECT Titel, SUBSTRING(Titel, 1, 1) AS first_letter FROM Titler ORDER BY Titel';
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result))
{
	$array[$row['first_letter']][] = $row['Titel'];
}

foreach ($array as $key => $value)
{
	foreach ($value as $row) {echo $row . '<br>';}
	echo '<br>';
} 
?>

[MichaelHe]

OK... so normally I have the script

<tr> 
     <td width='200'><?echo "<a href=\"Sangdata.php?Titel=$titel\">$titel</a>";?></td> 
    <td width= '60'><?echo $row['Stil'];?></td> 
    <td width= '70'><?echo $row['Hastighed'];?></td> 
    <td width='120'><?echo $row['Kvalitet'];?></td> 
   </tr> 

between the {} of the WHILE command.

You have put this

 $array[$row['first_letter']][] = $row['Titel']; 

between the {} of the WHILE..
I can see that this script lists the titles as it should, but how do I get my table correct listed.

I mean how do I get my table shown correctly as above, in your $array[$row['first_letter']][] = $row['Titel']; script... ?

[MichaelHe]

Thanks to your substring command which was new to me, I have found out how to do it...

$sql = "SELECT * FROM Titler WHERE 1 $opt1 $opt2 $opt3 $opt4 ORDER BY `Titel`";
$result = mysql_query($sql);
{
while ($row = mysql_fetch_array($result)) {
$titel=$row['Titel'];

$letter1 = substr($row['Titel'], 0, 1);
if ($letter1 <> $letter2) {$letter3 = "1";} else {$letter3 = "0";}
$letter2 = substr($row['Titel'], 0, 1);


if ($letter3 == "1") {?>
  <tr>
    <td width= '20'>&nbsp;</td>
    <td width='200'>&nbsp;</td> 
    <td width= '60'>&nbsp;</td> 
    <td width= '70'>&nbsp;</td>
    <td width='120'>&nbsp;</td>
    <td width= '20'>&nbsp;</td>
  </tr><?}

?><tr>
    <td width= '20'><?echo "<a href='Lydklip/".$row['Lydklip'].".mp3'><img src='Grafik/Lydicon.gif' width='20' height='20' border='0'></a>";?></td>
    <td width='200'><?echo "<a href=\"Sangdata.php?Titel=$titel\">$titel</a>";?></td> 
    <td width= '60'><?echo $row['Stil'];?></td> 
    <td width= '70'><?echo $row['Hastighed'];?></td>
    <td width='120'><?echo $row['Kvalitet'];?></td>
    <td width= '20'><?echo "<a href='mailto:".$row['Kontakt']."'><img src='Grafik/Mail.gif' width='20' height='20' border='0'></a>";?></td>
  </tr><?;
}}

mysql_close($conn);

This way I set the $letter3 to "1" if the start letter changes, and it will then echo an extra empty <tr> if $letter3 is "1"

Very simple :o)