[Resolved] Delay in display of page

[ywickham]

I have the following code that pulls links for a category from the database so that I can then create an "A to Z" anchor links line to navigate through all the available links alphabetically as many of the categories have well over 10 links:

	
//Check if page displayed is main category index page
if ($cid != 6) {

//Create Alphabet Search Link Listing
$i = 0;
$alphabet = range('A','Z');
$last_printed = "";
$count_of_links = 0;
$count_of_pages = 0;
$alpha_result = sql_query("select title from ".$prefix."_links_links where cid = $cid order by title", $dbi);

echo "<center>";

while ($alpha_row = mysql_fetch_array($alpha_result)) {

	$title = stripslashes($alpha_row['title']);
	$current_alpha_title = substr($title,0,1);

	if ($current_alpha_title != $last_printed) {

		while ($current_alpha_title != $alphabet[$i]) { #<--This is it!

			echo $alphabet[$i];
			$last_printed = $alphabet[$i];
			if ($alphabet[$i] != "Z") {
				echo " - ";
			}
			$i++;
		}

		echo "<b><a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=viewlink&cid=".
$cid."&orderby=".$orderby."&show=".$show.
"&min=".$count_of_pages."#".$alphabet[$i]."\">".$alphabet[$i]."</a></b>";
			$last_printed = $alphabet[$i];
			if ($alphabet[$i] != "Z") {
				echo " - ";
			}
			$i++;
		}

	//Increment page counter until a new page limit is reached
	if ($count_of_links >= $perpage) {
		$count_of_links = 0;
		$count_of_pages += $perpage;
	} else {
		$count_of_links++;
	}

}

//Create remainder of alphabet search line if at end of array
while ($i != 26) {
	if ($alphabet[$i] != "Z") {
		echo $alphabet[$i]." - ";
	} else {
		echo $alphabet[$i];
	}
	$i++;
}

echo "</center>";
}

I have gone through section by section, commenting out code to determine where the problem lies and have limited the problem down to the while section that has the "#<--This is it!" comment. The problem I am encountering is that it takes forever for the page to display the links section. This seems to occur with categories that have over 10 links in them. What am I missing? Is there a better way to create such a feature?

Thanks!

[ywickham]

Anyone?

[TTT]

just quessing ...

do { 

            echo $alphabet[$i]; 
            $last_printed = $alphabet[$i]; 
            if ($alphabet[$i] != "Z") { 
                echo " - "; 
            } 
            if($current_alpha_title == $alphabet[$i+1]) {
             $i += 2; 
            } else { 
              $i++;
            }
        } while ($current_alpha_title != $alphabet[$i]);




[code=php]

[ywickham]

I tried this and it actually made my lists with a shorter number of links lock up as well.

So I decided to walk through it and believe that it is not right for my solutions, as I would need to check for "A" in the listing and I would have no way of making "A" a link if there was a listing for "A" since it would have already printed it before it did the check on the conditional. (Does that make sense?)

Thank you, though!

So, any other ideas? Anyone?

[ywickham]

As I work with this more, I'm beginning to think it is more of a memory problem in that maybe when there are too many records, the computer can't create the alphabetical listing because it runs out of memory. Does this sound like a feasible issue to anyone? If so, how might I go about solving this problem? I've already attempted to remove the sort from the query itself (found in the above code), sorting the fetched array afterwards and then cycling through with an each(). The code is changed as follows:

		$alpha_result = sql_query("select title from ".$prefix."_links_links where cid = $cid", $dbi);

	//Get title array
	$title_array = mysql_fetch_array($alpha_result);

	//Run sort on title array
	sort($title_array);
	reset($title_array);

	echo "<center>";

	while (list($key, $val) = each($title_array)) {

		$title = stripslashes($val);
		$title_first_letter = substr($title,0,1);

		if ($title_first_letter != $last_printed) {

			while ($title_first_letter != $alphabet[$i]) {

Unfortunately, it's still producing similar results (meaning, it's messed up some other things, but the main "non display" problem still exists.) Any ideas?

[ywickham]

Here was the solution that did it for me:

		$alphabet = range('A','Z');
		$alpha_result = sql_query("select title from ".$prefix."_links_links where cid = $cid order by title", $dbi);

	// Pull titles from database into an array of the first letters
	while ($row = mysql_fetch_array($alpha_result)) {

		//Clean current title
		$current_title = stripslashes($row['title']);
		//Get first letter
		$first_letter = substr($current_title, 0, 1);
		//Dump letter in table
		$letters[$i] = $first_letter;
		$i++;
	}

	// Construct header row
	for ($i = 0; $i < 26; $i++) {

		if( $i != 0 ) {

			$raw_header .= " - ";
		}

		$raw_header .= $alphabet[$i];
	}

	// Setup raw header for single letter replacement
	$raw_header = " ".$raw_header." ";

	// Get count of letters found in category
	$total_link_count = count($letters);
	$link_count = 1;
	$page_count = 0;

	// Loop through letters array to replace letters in header string with links to bookmarks
	for ($i = 0; $i < $total_link_count; $i++) {

		// Get current letter from array and format for replacement search
		$current_letter = " ".$letters[$i]." ";

		// Create replacement string
		$replacement = " <b><a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=viewlink&cid=".
$cid."&orderby=".$orderby."&show=".$show."&min=".$page_count."#".$letters[$i]."\">".$letters[$i]."</a></b> ";

		// Replace letter with replacement string in header row
		$raw_header = ereg_replace($current_letter, $replacement, $raw_header);

		// Increment link counter until limit is reached for the page
		if ($link_count >= $perpage) {
			$link_count = 1;
			$page_count += $perpage;
		} else {
			$link_count++;
		}
	}

	echo $raw_header;

I hope this can help someone else out as well.