Tijden veranderen
Archief Cliptop40.nl
Marien
Deze doorzoek ik met een query in een speciaal aangemaakte kolom. De kolom: letter.
Die is gevuld met de eerste kleine letter van de artiest. Deze roep ik op met een where query ->
WHERE letter='a' bijvoorbeeld.
Maar nu bestaan er ook artiesten die niet beginnen met een letter maar met een cijfer. Hoe lees ik deze uit de database
Dat geeft alle records die beginnen met de letter a,
wil je alles beginnend met de letter b dan doe je:
WHERE letter='b%' enzovoort
Als dat niet werkt kun je nog de ''s vervangen door ""
Ik weet niet hoe je query er verder uitziet, maar is dat wat je wilt bedoeld?
Op www.w3schools.com/sql/ kun je meer informatie vinden
Gewijzigd op 07/07/2004 21:46:00 door John de Boer
1. WHERE letter LIKE 'a%'
2. <> of != gebruiken voor "ongelijk aan"
Gewijzigd op 07/07/2004 21:53:00 door John de Boer
En welke tekens dan? 0 tm 9?
voor letters/cijfers kan je werken met andere jokertekens in je query, dus dat zou er dan zo gaan uitzien (ik denk, maar weet niet zeker, dat het jokerteken voor een cijfer # was)
WHERE artiestnaam = "#%"
Veel geluk
$sql = "SELECT ... WHERE artiestnaam = '#%'"
Dit is het eerste gedeelte van mijn code van het archief:
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
<?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.";");
$i = ($pages['page']*$limits);
$titel = "Archief";
//snip ;)
?>
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.";");
$i = ($pages['page']*$limits);
$titel = "Archief";
//snip ;)
?>
Code (php)
1
2
3
4
5
6
7
8
9
2
3
4
5
6
7
8
9
<?
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'];
}
}
?>
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"
Volgens mij snappen jullie het verkeerd:
in mijn database staan ook andere clips met als letter 0 of < of ' enz hoe kan ik die selecteren via deze query?
Quote:
jah is een controletje die ik heb ingebouwd. Maar dat werkt wel.
Als het nou ook nog goede code was ...