next and previous links
| From: | Mick Fitzpatrick | Date: | Fri, 05 Oct 2001 16:18:49 +0000 |
| Subject: | next and previous links | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-70109@lists.php.net to get a copy of this message | ||
Hello
After several days of reading various articles on the web I've 'finally' got
a basic database working. The database is for a massive collection of my
vinyl records. Therefore I would like to limit the results to about 20 per
page and move forward/backward with 'next' and 'previous' links.
I'd like to stress at this stage that I'm new to PHP and don't really know
and 'tech speak' related to it ... however I like to think I'm a quick
learner :-)
Below I've pasted a copy of the script I fashioned ... I suppose it's full
of mistakes but it does work!
Any assistance will be appreciated
TIA ... Mick
***********************************
<html>
<body>
<table border="1" width="100%"
cellspacing="0"><TR><TH><font
face=Arial>artists</TH><TH><font face=Arial>aside</TH><TH><font
face=Arial>bside</TH><TH><font face=Arial>label</TH><TH><font
face=Arial>number</TH><TH><font face=Arial>price</TH><TH><font
face=Arial>origin</TH><TH><font face=Arial>format</TH><TH><font
face=Arial>info</TH></TR>
<?php
file://THIS BLOCK IS THE MySQL DATABASE INFO AND LOCATION
mysql_connect ("xxxxxxxxxxxxxxx", "xxxxxc", "xxxxxx");
mysql_select_db ("xxxxxx");
if ($artists == "")
{$artists = '%';}
if ($aside == "")
{$aside = '%';}
if ($bside == "")
{$bside = '%';}
if ($label == "")
{$label = '%';}
if ($number == "")
{$number = '%';}
file://THIS ROW SETS THE SEARCH CRITERIA AND THE ORDER ITS DISPLAYED ASC is
ASCENDING
$result = mysql_query ("SELECT * FROM example WHERE artists LIKE '$artists%'
AND aside LIKE '$aside%' AND bside LIKE '$bside%' AND label LIKE
'$label%'
AND number LIKE '$number%' ORDER BY artists ASC");
if ($row = mysql_fetch_array($result)) {
do {
file://THIS BLOCK DEFINES THE ALTERNATE ROW COLOURS
$darkcolor="#EEEEEE";
$lightcolor="#FFFFFF";
$test=$colorcount%2;
if ($test==0){
$rowcolor=$darkcolor;}
else{
$rowcolor=$lightcolor;}
$colorcount++;
file://THIS BLOCK PUTS THE SEARCH RESULTS IN THE TABLE
echo("<tr valign=top bgcolor=$rowcolor></TD><TD><font size=1
face=Arial>" .
$row["artists"] . "</TD><TD><font size=1 face=Arial>" .
$row["aside"] .
"</TD><TD><font size=1 face=Arial>" . $row["bside"] .
"</TD><TD><font size=1
face=Arial>" . $row["label"] . "</TD><TD><font size=1
face=Arial>" .
$row["number"] . "</TD><TD><font size=1 face=Arial>" .
$row["price"] .
"</TD><TD><font size=1 face=Arial>" . $row["origin"] .
"</TD><TD><font
size=1 face=Arial>" . $row["format"] . "</TD><TD><font size=1
face=Arial>" .
$row["info"] . "</TD></TR>");
} while($row = mysql_fetch_array($result));
} else {print "<font face=Arial>Sorry, no records were found!";}
?>
</body>
</html>