Help with A-Z listing in script?

droms

Hi Guys,

I have just begun using MySQL databases with PHP so i'm not very advanced, I was wondering if you could help me with something

I have managed to build a portal for a 'Characters' section on my harry potter site. www.hogsmeadenews.com

however it's starting to get quite long, I was wondering if someone would be able to show me how I would go about listing it a-z?

here is the code I have


<? 
if ($newsid == "") { 
$sql="SELECT * FROM characters ORDER BY newsname ASC"; 
$result=mysql_query($sql); 
$ncount=0; 
echo "<font size=1> </font>"; 
while ($myrow=mysql_fetch_array($result)) { 
if ($ncount<300) 
{ 
$ncount=$ncount+1; 
$newsbody = str_replace("\'", "'", $newsbody); 
?> 
                            <font face="Verdana, Arial, Helvetica, sans-serif" size="1"> 
                            <table width="100%" border="0" cellspacing="0" cellpadding="0"  bordercolor="#999999"> 
                              <tr> 

                          <td width="99%"> 


  <li><a href=index.php?page=characterread&newsid=<? echo $myrow["newsid"]; ?> 


                             <b> 

                            <? echo $myrow["newsname"]; ?><Br> 
                            </b> </a> </a> 

    </a>           
                              </font> 



                              </td> 
                          </tr> 
                        </table> 

                      <div align="left"> <font face="Verdana, Arial, Helvetica, sans-serif" size="2"> 
                        </font> 
                        <table width="100%" border="0" cellspacing="0" cellpadding="8"> 
                          <tr> 
                            <td><font face="Verdana, Arial, Helvetica, sans-serif" size="2"><font face="Verdana, Arial, Helvetica, sans-serif" size="2"> 

                              </font></font></td> 
                          </tr> 
                        </table> 
                        <font face="Verdana, Arial, Helvetica, sans-serif" size="2"> 
                        </font></div> 
                      </font> 
                      <div align="left"> 
                        <? 
} 
} 
} else { 
$sql="SELECT * FROM characters WHERE newsid=$newsid"; 
$result=mysql_query($sql); 
$myrow=mysql_fetch_array($result); 
printf("<div align=left><font face=Verdana size=1><a href=index.php?page=characters>Characters</a> / %s", $myrow["newsname"], $myrow["newsby"]); 
printf("<Br><Br><font face=Verdana size=2>%s", $myrow["newsbody"]); 

} 
?>

that prints out the following page
http://www.castlefm.net/hogsmeade/i...page=characters

how i make that into a (A-B-C-D-E-F-G-H-I-J etc etc) listing?

any help you could give me would be so much appreciated guys!

Andy

halojoy

you can do a "for_each_loop"
using loop values a, b ,c, d ...., z
That would produce a href link to each letter
Then make a search for posts in database beginning with that letter

Someone clicks

<?php

// this is search.php
// and also displays serch results, if any hits

// someone clicked link:   <a href="search.php?letter=A">
$letter = $_GET[ 'letter' ];

$result = mysql( 'select all records begin with', $letter );

echo $result . "<br><br>";

// loop for_each_letter  $i   (=A-Z)
// display link  ?>
<a href="search.php?letter=<?php echo $i; ?>"><?php echo $i; ?></a>&nbsp;
<?php
// end loop

// end, exit, search.php script and wait for next click
exit;

?>

Sorry I have no such function to give you.
I could write one easy.
But there are plenty of these small A-Z functions at web
Only find them. Maybe google, maybe first search this forum

But I am sure someone else have such a function to put in next Reply here.
It is not uncommon such functions are used, when aving large amount of data
to select from.

/halojoy

TheDefender

On a side note, you may want to take a look at the [man]stripslashes[/man] function. If you want to know what I am referring to, on your website, go to the Awards section of the "Chamber of Secrets" book listing.

http://www.castlefm.net/hogsmeade/index.php?page=book2read&newsid=21

See how Scottish Arts Council Children\'s Book Award 1999 has that slash in it?

halojoy

This is
corrected link

from First post in this topic:

http://www.castlefm.net/hogsmeade/index.php?page=characters

where listing is made 'order by' first letter
and probably in future you may want to add 'A-Z' select option

The Defender wrote:
On a side note, you may want to take a look at the stripslashes function.
If you want to know what I am referring to, on your website,
go to the Awards section of the "Chamber of Secrets" book listing.

Awards 
Scottish Arts Council Children\'s Book Award 1999 
FCBG Children\'s Book Award 1998 Overall winner and Longer Novel Category 
British Book Awards 1998 Children\'s Book of the Year 
North East Book Award 1999 
Whitaker\'s Platinum Book Award 2001

Beside link provided by The Defender in previous post,

On handling with magic quotes and slashes in PHP
Study my info in this recent post:

"You will find some good links in these topics,
explaining about magic, quote and slash
and how is good (best) way to do this with PHP."

http://www.phpbuilder.com/board/showpost.php?p=10648432&postcount=4

/halojoy
need not often do any 'slash-operations' ( addslashes or stripslashes )
due to his sensible use of PHP ( halojoy knows how to handle slashes and text from data base files )