Looking for a script like this [example link]

Sha

I own an online entertainment site & it does become quite a hassle for some people to simply search for an interview/review.

Example:

http://movieweb.com/movies/reviews

You see how they have their category listing in alphabetical order? That's exactly what we need for interviews & reviews. I've already searched on HotScripts.com & other places, but could not find anything. It would make things much easier.

Does anyone know where I can get a good script like this? I have looked everywhere.

Blag

Do you mean the alphabetical links????
ABCDE......Or am i wrong????

Blag :evilgrin:

Sha

Hey-

Yeah, that's what I mean. I need that for the interviews & reviews, so visitors can click on a letter & be taken to the pages of interviews/reviews that start with that certain letter.

Arc

It's pretty simple, just enter your reviews into a database with review title and review body fields then do a simple SQL statement like

SELECT * FROM tblReviews WHERE ReviewTitle LIKE '$Letter%'

That will select all reviews that begin with what ever letter is chosen....

$Letter is that variable that holds the value of the letter 🙂 and % just tells it to get anything after the $Letter

Sha

To be honest, I'm not that experienced with this. Not that I don't know PHP at all. I'm just not sure on how to write this up exactly.

rachel2004

As far as the query to use, Arc is correct. So when you say you're not experienced with this, what part do you need assistance with? How to use PHP to talk to your database so you can run Arc's query? Please be specific.

Sha

How to use PHP to talk to your database so you can run Arc's query?

Yeah, that's the part I need help with.

rachel2004

<?php
// use constants to define your db-related values
define('DB_USERNAME', 'username');
define('DB_PASSWORD', 'secret');
define('DB_HOST', 'localhost');
define('DB_NAME', 'mydb');

// create your db connection
$connection = @mysql_pconnect(DB_HOST, DB_USERNAME, DB_PASSWORD)
    or die("<p>Couldn't connect to database: ".mysql_error()."</p>");

// select your db
$db = @mysql_select_db(DB_NAME, $connection) 
    or die("<p>Couldn't select database: ".mysql_error()."</p>");

// create your query
$sql = "SELECT title 
        FROM tblReviews 
        WHERE ReviewTitle LIKE '$Letter%'";

// execute query
$result = @mysql_query($sql, $connection)
    or die("<p>Couldn't execute query: ".mysql_error()."</p>");

// loop through the query results
while ($row = mysql_fetch_array($result))
{
    echo $row['title']."<br />";
}
?>

Here's a pretty good online article to help you out as well:
http://www.sitepoint.com/article/php-amp-mysql-1-installation

HTH

Blag

Use this to generate the alphabeth links:

foreach(range('A', 'Z') as $link)
{
print("<a href=\"Show_Finds.php?page=".$link."\">".$link."</a>&nbsp;");
}

Then......in the Show_Finds page or whatever its called...use this.....

if(isset($_REQUEST["page"]))
{
$Find_It = $_REQUEST["page"].'%';
$sql = "SELECT title 
        FROM tblReviews 
        WHERE ReviewTitle LIKE '$Find_It'";
//more code......
}

Blag :evilgrin:

Sha

Thanks! I owe you two one.

I'll check out the article as well.