I Need Help...
Ok, I own an online magazine & I need an "archiver" for interviews & reviews.
I have this so far [ignore the database error]:
Couldn't execute query: ".mysql_error()."</p>");
// loop through the query results
while ($row = mysql_fetch_array($result))
{
echo $row['title']."
";
}
?>
And I know to use this to generate alphabet links:
foreach(range('A', 'Z') as $link)
{
print("".$link." ");
}
Then I know to add this in the Show_Finds.php section:
if(isset($_REQUEST["page"]))
{
$Find_It = $_REQUEST["page"].'%';
$sql = "SELECT title
FROM tblReviews
WHERE ReviewTitle LIKE '$Find_It'";
}
However, I was wondering how to go about setting this up exactly? As you can see, I already have the codes, so that's not the problem. The problem is fixing them up on my site. That's it. Has anyone done this before?
I have this so far [ignore the database error]:
Couldn't execute query: ".mysql_error()."</p>");
// loop through the query results
while ($row = mysql_fetch_array($result))
{
echo $row['title']."
";
}
?>
And I know to use this to generate alphabet links:
foreach(range('A', 'Z') as $link)
{
print("".$link." ");
}
Then I know to add this in the Show_Finds.php section:
if(isset($_REQUEST["page"]))
{
$Find_It = $_REQUEST["page"].'%';
$sql = "SELECT title
FROM tblReviews
WHERE ReviewTitle LIKE '$Find_It'";
}
However, I was wondering how to go about setting this up exactly? As you can see, I already have the codes, so that's not the problem. The problem is fixing them up on my site. That's it. Has anyone done this before?
