function decodeText($_str, $_form) {
$trans_tbl = get_html_translation_table (HTML_ENTITIES);
$trans_tbl = array_flip ($trans_tbl);
$_str = strtr($_str, $trans_tbl);
if ($_form) {
$_nl = "\r\n";
} else {
$_nl = "
";
}
$_str = str_replace("#BR#", "$_nl", $_str);
return($_str);
}
$searchstart = $_GET['searchstart'];
$numresults = $_GET['numresults'];
$show = $_GET['show'];
$showto = $_GET['showto'];
?>
Briers Art - Artwork by Salome Briers
 |
My Artwork
Note: Click on the small image to view in a bigger size.
|
$getQuery = "select id, artHeading, artDescription, artPicture, artPrice, artStatus from artwork where artHeading is not null order by artStatus, artHeading";
$getQueryRes = mysql_query($getQuery);
$countNum = mysql_num_rows($getQueryRes);
if ($countNum > 0){
$getRes = mysql_fetch_array($getQueryRes);
$numresults = 14;
$showto = $showto + $numresults;
if ($showto == 0){
$showto = $countNum;
}
if ($countNum < $showto){
$displayto = abs($countNum);
}else{
$displayto = $showto;
}
?>
1){?>results}else{?>result}?> found (Showing to )
|
$a=0;
$i=0;
while ($i < $countNum){
if ($i >= 0 && $i >= $searchstart && $i < $showto){
$artStatus = $getRes[artStatus];
if ($artStatus == 0){
$artStatusv = "For Sale @ R" . $getRes[artPrice];
}
if ($artStatus == 1){
$artStatusv = "Sold";
}
if ($artStatus == 2){
$artStatusv = "Demo only. Not for sale.";
}
$artPic = $getRes[artPicture];
$artPicSml = str_replace("artImg", "sml", $artPic)
?>
. - Size:
0){?>

}else{?>

}?>
|
if ($a == 1){
?>
|
}
}
$i++;
$a++;
if ($a==2){$a=0;}
$getRes = mysql_fetch_array($getQueryRes);
}
?>
if ($numresults > 0){
if($searchstart > 0)
echo "Previous " . $numresults . "";
if($searchstart > 0 && $countNum > ($searchstart + $numresults))
echo " | ";
if ($countNum <= ($searchstart + $numresults + $numresults)){
$nextnumresults = abs($countNum - $searchstart - $numresults);
}else{
$nextnumresults = $numresults;
}
if($countNum > ($searchstart + $numresults))
echo "Next " . $nextnumresults . "";
if ($countNum > 20){
//echo " | ";
echo $alphastring;
}
}
?>
|
}else{
?>
There are no artwork to display ... |
}
mysql_free_result($getQueryRes);
?>
|