Ne Luck

The coding for the search page would go like this...

You can save this as whatever you want (search.php, browse.php etc.)

PHP Code:

<title>Scotts Game Room Portal - Reviews - Browse</title>
<?php

echo "<a href='?id=a'>A</a> <a href='?id=b'>B</a> <a href='?id=c'>C</a> <a href='?id=d'>D</a> 
<a href='?id=e'>E</a> <a href='?id=f'>F</a> <a href='?id=g'>G</a> <a href='?id=h'>H</a> 
<a href='?id=i'>I</a> <a href='?id=j'>J</a> <a href='?id=k'>K</a> <a href='?id=l'>L</a> 
<a href='?id=m'>M</a> <a href='?id=n'>N</a> <a href='?id=o'>O</a> <a href='?id=p'>P</a> 
<a href='?id=q'>Q</a> <a href='?id=r'>R</a> <a href='?id=s'>S</a> <a href='?id=t'>T</a> 
<a href='?id=u'>U</a> <a href='?id=v'>V</a> <a href='w'>W</a> <a href='?id=x'>X</a> 
<a href='?id=y'>Y</a> <a href='?id=z'>Z</a>";

if(!isset($_GET['id'])) echo "</br></br><b>Please select a letter above to browse through the reviews!</b>

";

else
{
$id = $_GET['id'];

include 'db_connect.php';

$query="SELECT * FROM reviews WHERE title LIKE '$id%'";
$result=mysql_query($query);
$num=mysql_numrows($result);

if($num == 0) echo "</br></br><b>No results found!</b>";

else {echo "</br></br><b>$num Results found!</b>";

echo "<table border>";
$i=0;
while ($i < $num) {

$url=mysql_result($result,$i,"id");
$name=mysql_result($result,$i,"title");

echo "    <tr>
        <td><p><a href='review.php?id=$url'>$name</a></td>
    </tr>";

$i++;
}
echo "</table>";}
}
?>

This will just create a simple page..But if you want..if you create a layout you want for the page I could put the PHP into it for you..

-James

How you getting on with this?

-James

soz mate been away for the last few weeks in and out of it you know! so im gona have a proper go at it tomrow. also when i tried the databse connect page out quickly it returned a could not be displayed page, and i am using freeola as a host so it comes up witht here personal error page which i can not change!

i have tried again and i get an erro ron line 8 of the db_connect page!