Ik ben bezig met mijn archief op www.cliptop40.nl/archief.php nu heb ik gemaakt dat ik met letters door mijn database kan zoeken. Dit doe ik door: uit mijn table te lezen de kolom letter die word standaard gevuld met het eerste teken van de naam (lowercase) van de artiest op mijn site. Maar nu wil ik ook de overige tekens selecteren. Hoe doe ik dat :?
Ik heb net mijn database verbouwd met die letters :( Omdat ik van horen zeggen het snelste was.
Dit is het eerste gedeelte van mijn code van het archief:
<?php
session_start();
include("header.php");
include("connect.php");
$limits=array(
'min_limit' =>30,//the minimum amount of products per page
'max_limit' =>30,//the maximum of products per page
'norml_limit' =>30,//the default value
'page_diff' =>1,//de difference between page number, example if page 25: 23,24,25,26,27
);
include("functions.php");
if($_GET['action'] == changeletter)
{
if($_GET['letter'] == 09 OR $_GET['letter'] == a OR $_GET['letter'] == b OR $_GET['letter'] == c OR $_GET['letter'] == d OR $_GET['letter'] == e OR $_GET['letter'] == f OR $_GET['letter'] == g OR $_GET['letter'] == h OR $_GET['letter'] == i OR $_GET['letter'] == j OR $_GET['letter'] == k OR $_GET['letter'] == l OR $_GET['letter'] == m OR $_GET['letter'] == n OR $_GET['letter'] == o OR $_GET['letter'] == p OR $_GET['letter'] == q OR $_GET['letter'] == r OR $_GET['letter'] == s OR $_GET['letter'] == t OR $_GET['letter'] == u OR $_GET['letter'] == v OR $_GET['letter'] == w OR $_GET['letter'] == x OR $_GET['letter'] == y OR $_GET['letter'] == z)
{
$letter = $_GET['letter'];
}
}
else
{
$letter = "a";
}
$limits=limit();
$items= mysql_num_rows(mysql_query("SELECT * FROM clip WHERE letter='". $letter ."'"));
$pages=pages(ceil($items/$limits));
$query = mysql_query("SELECT * FROM clip WHERE letter='". $letter ."' ORDER BY artiestnaam,clipnaam LIMIT ".($pages['page']*$limits).",".$limits.";");
Kweenie wa dit moet zijn maaruh ...
<?
if($_GET['action'] == changeletter)
{
if($_GET['letter'] == 09 OR $_GET['letter'] == a OR $_GET['letter'] == b OR $_GET['letter'] == c OR $_GET['letter'] == d OR $_GET['letter'] == e OR $_GET['letter'] == f OR $_GET['letter'] == g OR $_GET['letter'] == h OR $_GET['letter'] == i OR $_GET['letter'] == j OR $_GET['letter'] == k OR $_GET['letter'] == l OR $_GET['letter'] == m OR $_GET['letter'] == n OR $_GET['letter'] == o OR $_GET['letter'] == p OR $_GET['letter'] == q OR $_GET['letter'] == r OR $_GET['letter'] == s OR $_GET['letter'] == t OR $_GET['letter'] == u OR $_GET['letter'] == v OR $_GET['letter'] == w OR $_GET['letter'] == x OR $_GET['letter'] == y OR $_GET['letter'] == z)
{
$letter = $_GET['letter'];
}
}
?>
String moeten gequote worden ... dus "changeletter" en "a"
