Frank: Datenbankabfrage erweitern - bitte um Hilfe!

Beitrag lesen

Mach doch einfach zwei Schleifen...

$count=0;
for ($letter = A; $letter <> AA; $letter++)
  {
    $query="select title from $mytable where title like '$letter%' order by title";
   $result = @mysql_db_query($dbname,$query,$db) or die(mysql_error());
       while ($row = mysql_fetch_row($result))
   {
     $count=1;
     $title=$row[0];
      $t = urlencode($title);
      $title=str_replace("<br>","",$title);
             echo $title;
    }
   if ($count==0)
    echo "Keine Einträge";
  }

$count=0;
for ($letter = 0; $letter <= 9; $letter++)
  {
    $query="select title from $mytable where title like '$letter%' order by title";
   $result = @mysql_db_query($dbname,$query,$db) or die(mysql_error());
       while ($row = mysql_fetch_row($result))
   {
     $count=1;
     $title=$row[0];
      $t = urlencode($title);
      $title=str_replace("<br>","",$title);
             echo $title;
    }
   if ($count==0)
    echo "Keine Einträge";
  }