Hey, Chris

How would I go about listing this page from A-Z

[code]<?
function stripslashes2($string) {
$string = str_replace("\\\"", "\"", $string);
$string = str_replace("\\'", "'", $string);
$string = str_replace("\\\\", "\\", $string);
return $string;
}
?>
<?
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=2><a href=index.php?page=characters>BACK TO CHARACTERS</a><br><Br>";
printf("<font size=3 color=#FFfff><b>%s</b></font> <font color=white size=1><b></b></font> <font color=#ffffff size=1></font><font face=Verdana size=2> ", $myrow["newsname"], $myrow["newsby"]);
printf("<Br><Br><font face=Verdana size=2>%s", $myrow["newsbody"]);

}
?>[/code]
Someone gave me this code below but I can't get it work

[code]$first_char = $_GET['firstchar']
if ($first_char <> "" {
$sql="SELECT * FROM characters WHERE newsname LIKE '" . $first_char . "%' ORDER BY newsname
ASC";
} else {
$sql="SELECT * FROM characters ORDER BY newsname ASC";
}[/code]
PLEASE HELP

andy

What's it a script for? More info

------

These http://www.phpfreaks.com/forums/index.php?act=idx are the best forums for PHP Help. I usually get an answer within an hour. It's great.

It's a script for this page http://www.castlefm.net/hogsmeade/index.php?page=characters

just lists characters and then when you click in, details about them

I would just try something like this:

FIND:
$ncount=$ncount+1;

REPLACE WITH:
$ncount++;
if (isSet($letter) {
$name = $myrow["newsname"];
if ($name[0] == $letter) {
// print out link to character here
$printing = 'true';
}
if ($printing != 'true')
echo "No characters under the letter $letter";
} else {
echo "Please choose a letter";
}