Killer Surf Links  
SURF MUSIC   
Buy.com End of the Month Blowout Sale valid 10/26/04 - 10/31/04  
Live Surf Music (Shows)
Your Link Here
Surf Bands
Your Link Here
 Listen Now
Your Link Here
Join KSL Online Today!
Come on in..............

Share KSL with a bro
 

Killer Surf Links- Your Surfing Search Engine! SURFERS ONLY.

KSL Search Results
\n", $myrow["sitename"], $myrow["sitetext"]); printf("
"; $fontfamily = "tahoma, helvetica"; $fontsize = "13px"; $fontcolor = "#000000"; $inactivecolor = "#666666"; // Color for when there is no link $fontweight = "700"; $textdecoration = "none"; /*==========================================*/ /*==Window Status of individual page links==*/ /*==========================================*/ function pageStatus($i) { echo " Click to View Page $i"; } /*==================================================*/ /*==If thisOffset not set, set to zero==============*/ /*==================================================*/ if (!isset($thisOffset) || $thisOffset < 0) $thisOffset=0; if ($action==search) $thisOffset = $thisOffset - 1; /*==================================================*/ /*==This is to count the line index of the results==*/ /*=============if not set, set to zero==============*/ /*==================================================*/ if (!isset($lineIndex) || $lineIndex < 0) $lineIndex=0; if ($action==search) $lineIndex = $lineIndex - 1; /*========================================*/ /*==Set Base SQL Statement for the query==*/ /*========================================*/ $sql="SELECT * FROM websites WHERE category like '%music%' ORDER BY rank"; //$sql="SELECT * FROM websites WHERE keywords like waves ORDER BY rank"; /*======================================*/ /*==Query for the total number of rows==*/ /*======================================*/ $getTotalRows = mysql_query($sql, $db); $totalRowsNum = mysql_num_rows($getTotalRows); /*==========================================*/ /*==Append the limit and offset to the sql==*/ /*==========================================*/ $sql.=" Limit $thisOffset,$recordLimit"; /*===================================================*/ /*==Query and fetch array with the limit and offset==*/ /*===================================================*/ $result = mysql_query($sql, $db); if ($myrow=mysql_fetch_array($result)) { /*=================================*/ /*==Increment the line index by 1==*/ /*=================================*/ $lineIndex++; /*============================================*/ /*====== Your results layout goes here =======*/ /*============================================*/ do { printf("\n"); printf("\n", $myrow["sitename"], $myrow["sitetext"]); printf("
%s - %s
Check It Out

\n"); } while ($myrow = mysql_fetch_array($result)); } else { echo "Oh man, no records were found with your keyword(s) try again."; } /*===================================================================*/ /*==If the number of returned is less than the limit, show nothing===*/ /*===================================================================*/ if ($totalRowsNum <= $recordLimit) { // less than recordLimit returned. } else { /*==============================================*/ /*==If the current offset is not equal to zero==*/ /*==Show the link. Else (if>0) show just text===*/ /*==============================================*/ if ($thisOffset!=0) { $prevOffset = intval($thisOffset-$recordLimit); echo "" ."$prevLink "; } else { echo "$prevLink "; } /*================================================================*/ /*==Divide total rows by record limit to get the number of pages==*/ /*================================================================*/ $totalPages = intval($totalRowsNum/$recordLimit); /*===========================================================*/ /*==If remainder is left from division increment totalPages==*/ /*===========================================================*/ if ($totalRowsNum%$recordLimit) $totalPages++; /*===========================================================*/ /*==Using a for() loop, Display links for each page. 1 2 3===*/ /*===========================================================*/ for ($i=1;$i<=$totalPages;$i++) { /*==================================================================*/ /*==If the page being viewed is the current page, disable the link==*/ /*==================================================================*/ if ((intval($thisOffset/$recordLimit)) == (intval($i-1))) { echo " $i "; } else { /*========================================================*/ /*==If not current page, set nextOffset and display link==*/ /*========================================================*/ $nextOffset= intval($recordLimit*($i-1)); echo " $i "; } } /*==========================================================================*/ /*==If the page is not the last page, set the nextOffset and show the link==*/ /*==============If the page is the last page disable the link===============*/ /*==========================================================================*/ if (!(intval(((intval($thisOffset/$recordLimit))+1))==$totalPages) && $totalPages!=1) { $nextOffset = intval($thisOffset+$recordLimit); echo " $nextLink

\n"; } else { echo " " ."$nextLink

"; } } //END OF CODE THAT WORKS WITH 1 SEARCH WORD AND CATEGORY ?> \n"); printf("

%s - %s
Check It Out

\n"); } while ($myrow = mysql_fetch_array($result)); } else { echo "Sorry, no records were found!"; } */ ?>


Look Deeper into the KSL Directory


Surf Boards | Surf Shops | Surf Cams | Magazines | Videos | Organizations | Surf Accessories | Surf Apparel | Lifestyle
Body Surfing | Surf Music | Surf Travel | Photography | Surf Contests | FREE KSL Web Page | KSL Contests | KSL Home Page

Add Your Surf Site   Advertise on KSL   Membership Form   Investor Relations   Feedback/Contact

Contents © 2000. KillerSurFLinks.com. All rights reserved.