= 2) { $currkey = trim($keywords2[$i]); $squery = $squery." && (title like '%$currkey%')"; } } $squery = $squery.")"; if (!$All) { $fquery = "&& ((categories = 'goatmilk')"; if ($VHS) $fquery = $fquery." || (format = 'VHS')"; if ($DVD) $fquery = $fquery." || (format = 'DVD')"; if ($CDROM) $fquery = $fquery." || (format = 'CD-Rom')"; if ($VHSEP) $fquery = $fquery." || (format = 'VHS-EP Mode')"; if ($VHSSP) $fquery = $fquery." || (format = 'VHS-SP Mod')"; if ($PAL) $fquery = $fquery." || (format = 'PAL')"; if ($SECAM) $fquery = $fquery." || (format = 'SECAM')"; if ($MPAL) $fquery = $fquery." || (format = 'MPAL')"; if ($NPAL) $fquery = $fquery." || (format = 'NPAL')"; if ($MESECAM) $fquery = $fquery." || (format = 'MESECAM')"; $fquery = $fquery.")"; } $resultquery = "select title, invid, price, format from inventory where $squery $fquery and status = 'v' order by title"; $title = "Titles containing any of the words \"$keywords\""; } else { ?> 0) { $totalPages = round($trecs/$countperpage) + 1; } else { $totalPages = round($trecs/$countperpage); } mysql_data_seek($cquery, $currRec); } ?>
Sorry, there are no titles pertaining to your request. | |
&ref="> $ |
3 && $incr <= 25 && (($i == (11+($incr-1)*40) && $i < $currPages) || ($i == (22+($incr-1)*40) && $i < $currPages) || ($i == (32+($incr-1)*40) && $i < $currPages))) { ?> 25 && (($i == (9+($incr-1)*40) && $i < $currPages) || ($i == (20+($incr-1)*40) && $i < $currPages) || ($i == (30+($incr-1)*40) && $i < $currPages) || ($i == (38+($incr-1)*40) && $i < $currPages))) { ?> 1) { ?>-40 <<-40 <<>> +40>> +40 |