$ad='googlessad.txt';
require("/home/nandayco/www/dc/bodystart3.txt")
?>
Artist Database
Selected entries from the Digital Consciousness Artist Database |
$o="ORDER BY lastname,firstname";
$limit=999999;
if ($w=="")
{$firstname=AddSlashes($firstname); $lastname=AddSlashes($lastname); $search=AddSlashes($search);
if ($firstname=='*new*' || $lastname=='*new*')
{$w="pageurl LIKE ' %'";}
else {
$w="firstname LIKE '$firstname%' AND lastname LIKE '$lastname%'
AND (bio LIKE '%$search%' OR country LIKE '%$search%'
OR medium LIKE '%$search%' OR othermedia LIKE '%$search%'
OR style LIKE '%$search%' OR otherstyle LIKE '%$search%'
OR subject LIKE '%$search%' OR othersubject LIKE '%$search%')";
}
}
$table="registered";
$artistsURL="/artists";
$PrevButton="Previous page";
$NextButton="Next page";
$PageButton="Go to page";
if ($submit==$PrevButton) {$s=$s-$max;}
if ($submit==$NextButton) {$s=$s+$max;}
if ($submit==$PageButton && $pagenum>0 && $pagenum<=$pages) {$s=($pagenum-1)*$max;}
$w=StripSlashes($w);
# maximum number of entries to show per page
$max = 5;
if ($limit>0 && $limit<$max) $max=$limit;
if ($s=="") {$s=0;}
if ($w!="") $where="WHERE $w";
$result = mysql_query("SELECT * FROM $table $where $o LIMIT $s,$max");
$count=0;
#if ($row = mysql_fetch_array($result)) while($row = mysql_fetch_array($result)) {require("fnsOneEntry.php"); $count++;}
#else print "Sorry, no records were found!";
if ($row = mysql_fetch_array($result))
{
do {
require("fnsOneEntry.php");
# # save info from last entry displayed
# $firstname0=AddSlashes($row["firstname"]);
# $lastname0=AddSlashes($row["lastname"]);
# $pageurl0=$row["pageurl"];
# $timestamp0=$row["timestamp"];
$count++;
}
while($row = mysql_fetch_array($result));
}
else {print "Sorry, no records were found!";}
print " |
";
#determine how many total pages
$num = mysql_num_rows(mysql_query("SELECT * FROM $table $where $o LIMIT $limit"));
$pages=(int)(($num+$max-1)/$max);
$page=($s/$max)+1;
print " |
"; require("/home/nandayco/www/dc/menu1.txt") ?> |