Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
Thread: Code Archive Script
05-08-2009, 08:15 PM #1
- Join Date
- Sep 2007
- Thanked 0 Times in 0 Posts
Code Archive Script
I'm looking to code something similar to this:
I have gotten the page similar, but can't figure out how to get my results to bring up only certain letters like their without creating a new page for that letter. Ideas?
Or maybe a similar script I can view to get an idea off of?
05-08-2009, 08:35 PM #2
- Join Date
- Sep 2002
- Saskatoon, Saskatchewan
- Thanked 2,662 Times in 2,631 Posts
You'd have to modify what you have so when you're selecting you're data you're only selecting based off of $chosen%. SQL is the best option for this on indexed fields since it will index by the first letter.
So, their code would have something like:
$criteria = '';
if (isset($_GET['l']) && strlen($_GET['l']) == 1 && ctype_alpha($_GET['l']))
$criteria = ' WHERE `title` = \'' . strtoupper($_GET['l']) . '%\'';
$sQry = "SELECT * FROM `games`" . $criteria;
Been gone for a few months, and haven't programmed in that long of a time. Meh, I'll wing it ;)PHP Code:
header('HTTP/1.1 420 Enhance Your Calm');