necrotic — Mon, 07 Oct 2002 18:55:44 +0000

Awesome! That cut the size of the file down EMINSLY(sp?)! Thanks alot

Mark Hensler — Mon, 07 Oct 2002 05:22:19 +0000

I removed the reference...

<?php
echo (\"<TABLE BORDER=0 WIDTH=\\"100%\\" HEIGHT=\\"100%\\" BGCOLOR=\\"#FFFFFF\\" CELLPADDING=\\"2\\" CELLSPACING=\\"1\\" VALIGN=\\"TOP\\">\n\");

// initiallize our array of letters
// (the NULL is needed as the first element is skipped in the loop below)
$letters = array(NULL, 'a', 'b', 'c', 'd', 'e', 'f');

// initialize our index counter
$i=0;

// get a recordset with our pre-sorted album titles
$result = mysql_query(\"SELECT albumtitle,id FROM `ata_albums` ORDER BY albumtitle ASC\");

// loop through the album list
while ($row = mysql_fetch_assoc($result)) {
    $title = $row[\"albumtitle\"];
    $id = $row[\"id\"];
    
    // get the first letter of our album title
    $first_letter = substr($title, 0, 1);
    
    // if the first letter of the album title doesn't match the letter we're on
    while (strtolower($first_letter)!=strtolower($letters[$i])) {
        // if we have more letters to go through
        if ($i<count($letters)) {
            // go to the next letter
            $i++;
        }
        else {
            // we've already been through all of our letters
            // break out of two while loops
            break 2;
        }
        
        // print the heading for the next letter
        echo (\"<TR BORDER=0 WIDTH=\\"100%\\" HEIGHT=\\"100%\\" BGCOLOR=\\"#FFFFFF\\" CELLPADDING=\\"0\\" CELLSPACING=\\"0\\" VALIGN=\\"TOP\\">\n\");
        echo (\"  <TD BORDER=0 WIDTH=\\"100%\\" HEIGHT=\\"100%\\" BGCOLOR=\\"#FFFFFF\\" CELLPADDING=\\"0\\" CELLSPACING=\\"0\\" VALIGN=\\"TOP\\">\n\");
        echo (\"    <CENTER><FONT CLASS=\\"xxxlarge\\"><B>\" . ucfirst($letters[$i]) . \"</B></FONT></CENTER>\n\");
        echo (\"  </TD>\n\");
        echo (\"</TR>\n\");
    }
    
    // print the album title
    echo (\"<TR BORDER=0 WIDTH=\\"100%\\" HEIGHT=\\"100%\\" BGCOLOR=\\"#FFFFFF\\" CELLPADDING=\\"0\\" CELLSPACING=\\"0\\" VALIGN=\\"TOP\\">\n\");
    echo (\"  <TD BORDER=0 WIDTH=\\"100%\\" HEIGHT=\\"100%\\" BGCOLOR=\\"#FFFFFF\\" CELLPADDING=\\"0\\" CELLSPACING=\\"0\\" VALIGN=\\"TOP\\">\n\");
    echo (\"    <FONT CLASS=\\"content\\">\n\");
    echo (\"      <A HREF=\\"$site[url]/mp3/details.php?id=$id\\">$title</A>\n\");
    echo (\"    </FONT>\n\");
    echo (\"  </TD>\n\");
    echo (\"</TR>\n\");
    
}

echo (\"</TABLE>\n\");
?>

Mark Hensler — Mon, 07 Oct 2002 05:19:54 +0000

That method is less desired as it executes one query per letter and contains a WHERE clause.

I'm not sure why my script didn't work. But at any rate, I didn't do a desk check. Looking at it know I see that it would have omitted records in some circumstances.

I've not tested this... comments inset so you can follow my thought process.

<?php
echo (\"<TABLE BORDER=0 WIDTH=\\"100%\\" HEIGHT=\\"100%\\" BGCOLOR=\\"#FFFFFF\\" CELLPADDING=\\"2\\" CELLSPACING=\\"1\\" VALIGN=\\"TOP\\">\n\");

// initiallize our array of letters
// (the NULL is needed as the first element is skipped in the loop below)
$letters = array(NULL, 'a', 'b', 'c', 'd', 'e', 'f');

// set reference $letter to the first letter in our $letters array
$letter =& $letters[0];

// initialize our protection counter
$i=0;

// get a recordset with our pre-sorted album titles
$result = mysql_query(\"SELECT albumtitle,id FROM `ata_albums` ORDER BY albumtitle ASC\");

// loop through the album list
while ($row = mysql_fetch_assoc($result)) {
    $title = $row[\"albumtitle\"];
    $id = $row[\"id\"];
    
    // get the first letter of our album title
    $first_letter = substr($title, 0, 1);
    
    // if the first letter of the album title doesn't match the letter we're on
    while (strtolower($first_letter)!=strtolower($letter)) {
        // if we have more letters to go through
        if ($i<count($letters)) {
            // go to the next letter
            $letter++;
            $i++;
        }
        else {
            // we've already been through all of our letters
            // break out of two while loops
            break 2;
        }
        
        // print the heading for the next letter
        echo (\"<TR BORDER=0 WIDTH=\\"100%\\" HEIGHT=\\"100%\\" BGCOLOR=\\"#FFFFFF\\" CELLPADDING=\\"0\\" CELLSPACING=\\"0\\" VALIGN=\\"TOP\\">\n\");
        echo (\"  <TD BORDER=0 WIDTH=\\"100%\\" HEIGHT=\\"100%\\" BGCOLOR=\\"#FFFFFF\\" CELLPADDING=\\"0\\" CELLSPACING=\\"0\\" VALIGN=\\"TOP\\">\n\");
        echo (\"    <CENTER><FONT CLASS=\\"xxxlarge\\"><B>\" . ucfirst($letter) . \"</B></FONT></CENTER>\n\");
        echo (\"  </TD>\n\");
        echo (\"</TR>\n\");
    }
    
    // print the album title
    echo (\"<TR BORDER=0 WIDTH=\\"100%\\" HEIGHT=\\"100%\\" BGCOLOR=\\"#FFFFFF\\" CELLPADDING=\\"0\\" CELLSPACING=\\"0\\" VALIGN=\\"TOP\\">\n\");
    echo (\"  <TD BORDER=0 WIDTH=\\"100%\\" HEIGHT=\\"100%\\" BGCOLOR=\\"#FFFFFF\\" CELLPADDING=\\"0\\" CELLSPACING=\\"0\\" VALIGN=\\"TOP\\">\n\");
    echo (\"    <FONT CLASS=\\"content\\">\n\");
    echo (\"      <A HREF=\\"$site[url]/mp3/details.php?id=$id\\">$title</A>\n\");
    echo (\"    </FONT>\n\");
    echo (\"  </TD>\n\");
    echo (\"</TR>\n\");
    
}

echo (\"</TABLE>\n\");
?>

necrotic — Mon, 07 Oct 2002 01:20:19 +0000

Awesome! It works. Thanks nike_guy_man!

nike_guy_man — Sun, 06 Oct 2002 23:35:19 +0000

Oops!
My mistake on the code
Try this:

<?php
$letters = \"a,b,c,d,e,f\";
$split = explode(\",\", $letters);
foreach ($split as $k => $val) {
$result = mysql_query(\"SELECT albumtitle,id FROM `ata_albums` WHERE (albumtitle) LIKE ('$val%') ORDER BY albumtitle ASC \");
$row = mysql_fetch_assoc($result);
$title = $row[albumtitle];
$id = $row[id];

       echo (\"<TR BORDER=0 WIDTH=\\"100%\\" HEIGHT=\\"100%\\" BGCOLOR=\\"#FFFFFF\\" CELLPADDING=\\"0\\" CELLSPACING=\\"0\\" VALIGN=\\"TOP\\">\n\");
        echo (\"  <TD BORDER=0 WIDTH=\\"100%\\" HEIGHT=\\"100%\\" BGCOLOR=\\"#FFFFFF\\" CELLPADDING=\\"0\\" CELLSPACING=\\"0\\" VALIGN=\\"TOP\\">\n\");
        echo (\"    <FONT CLASS=\\"content\\">\n\");
        echo (\"      <A HREF=\\"$site[url]/mp3/details.php?id=$id\\">$title</A>\n\");
        echo (\"    </FONT>\n\");
        echo (\"  </TD>\n\");
        echo (\"</TR>\n\");

}
?>

necrotic — Sun, 06 Oct 2002 21:42:12 +0000

Same, No results >< This is pissing me of soooo bad! I wanted to have this script done 2 nights ago!

nike_guy_man — Sun, 06 Oct 2002 20:05:54 +0000

<?php
$letters = \"a,b,c,d,e,f\";
$split = explode(\",\", $letters);
foreach ($split as $k => $val) {
$result = mysql_query(\"SELECT albumtitle,id FROM `ata_albums` WHERE (albumtitle) LIKE ('$val') ORDER BY albumtitle ASC \");
$row = mysql_fetch_assoc($result);
$title = $row[albumtitle];
$id = $row[id];

       echo (\"<TR BORDER=0 WIDTH=\\"100%\\" HEIGHT=\\"100%\\" BGCOLOR=\\"#FFFFFF\\" CELLPADDING=\\"0\\" CELLSPACING=\\"0\\" VALIGN=\\"TOP\\">\n\");
        echo (\"  <TD BORDER=0 WIDTH=\\"100%\\" HEIGHT=\\"100%\\" BGCOLOR=\\"#FFFFFF\\" CELLPADDING=\\"0\\" CELLSPACING=\\"0\\" VALIGN=\\"TOP\\">\n\");
        echo (\"    <FONT CLASS=\\"content\\">\n\");
        echo (\"      <A HREF=\\"$site[url]/mp3/details.php?id=$id\\">$title</A>\n\");
        echo (\"    </FONT>\n\");
        echo (\"  </TD>\n\");
        echo (\"</TR>\n\");

}
?>

Maybe try that?

necrotic — Sun, 06 Oct 2002 19:37:00 +0000

Now I get no results:
http://audio.anitrade.net/mp3/a-f.php
at least before I was getting results, even if it wouldn't stop ><

Mark Hensler — Sun, 06 Oct 2002 06:19:40 +0000

try this:

<?php
function Print_Letter($result, $letter) {
    
    $letter = strtolower($letter);
    
    echo (\"<TR BORDER=0 WIDTH=\\"100%\\" HEIGHT=\\"100%\\" BGCOLOR=\\"#FFFFFF\\" CELLPADDING=\\"0\\" CELLSPACING=\\"0\\" VALIGN=\\"TOP\\">\n\");
    echo (\"  <TD BORDER=0 WIDTH=\\"100%\\" HEIGHT=\\"100%\\" BGCOLOR=\\"#FFFFFF\\" CELLPADDING=\\"0\\" CELLSPACING=\\"0\\" VALIGN=\\"TOP\\">\n\");
    echo (\"    <CENTER><FONT CLASS=\\"xxxlarge\\"><B>\" . ucfirst($letter) . \"</B></FONT></CENTER>\n\");
    echo (\"  </TD>\n\");
    echo (\"</TR>\n\");
    
    $row = mysql_fetch_assoc($result);
    $title = $row[\"albumtitle\"];
    $id = $row[\"id\"];
    $first_letter = substr($title, 0, 1);
    
    while (strtolower($first_letter) == $letter) {
        echo (\"<TR BORDER=0 WIDTH=\\"100%\\" HEIGHT=\\"100%\\" BGCOLOR=\\"#FFFFFF\\" CELLPADDING=\\"0\\" CELLSPACING=\\"0\\" VALIGN=\\"TOP\\">\n\");
        echo (\"  <TD BORDER=0 WIDTH=\\"100%\\" HEIGHT=\\"100%\\" BGCOLOR=\\"#FFFFFF\\" CELLPADDING=\\"0\\" CELLSPACING=\\"0\\" VALIGN=\\"TOP\\">\n\");
        echo (\"    <FONT CLASS=\\"content\\">\n\");
        echo (\"      <A HREF=\\"$site[url]/mp3/details.php?id=$id\\">$title</A>\n\");
        echo (\"    </FONT>\n\");
        echo (\"  </TD>\n\");
        echo (\"</TR>\n\");
        
        $row = mysql_fetch_assoc($result);
        $title = $row[\"albumtitle\"];
        $id = $row[\"id\"];
        $first_letter = substr($title, 0, 1);
    }
}


$result = mysql_query(\"SELECT albumtitle,id FROM `ata_albums` ORDER BY albumtitle ASC\");

echo (\"<TABLE BORDER=0 WIDTH=\\"100%\\" HEIGHT=\\"100%\\" BGCOLOR=\\"#FFFFFF\\" CELLPADDING=\\"2\\" CELLSPACING=\\"1\\" VALIGN=\\"TOP\\">\n\");

Print_Letter($result, 'A');
Print_Letter($result, 'B');
Print_Letter($result, 'C');
Print_Letter($result, 'D');
Print_Letter($result, 'E');
Print_Letter($result, 'F');

echo (\"</TABLE>\n\");
?>