MySQL Training

Training 2 You > Education Directory > Web Design Training > MySQL Training

7) { echo ''; } while ($data=mysql_fetch_array($result)) { $content = $data["Content"]; $url2 = $data["Url"]; $id = $data["id"]; $Title = $data["Title"]; $Description = $data["Description"]; if($numrows>1){ echo ""; echo ""; } else { echo ""; } echo $Title; echo "
"; echo $Description; echo "

"; } // next we need to do the links to other results /* if ($offset==1) { // bypass PREV link if offset is 0 $prevoffset=$offset-25; print "PREV \n"; } */ // calculate number of pages needing links $pages=intval($numrows/$limit); // $pages now contains int of pages needed unless there is a remainder from division if ($numrows%$limit) { // has remainder so add one page $pages++; } if($pages!=1){ print "More Results "; for ($i=2;$i<=$pages;$i++) { // loop thru $newoffset=$limit*($i-1); print "$i \n"; } } /* check to see if last page /* check to see if last page if (!(($offset/$limit)==$pages) && $pages!=1) { // not last page so give NEXT link $newoffset=$offset+$limit; print "NEXT

\n"; } */mysql_close($dbh); ?>

Add Your Training or Educational Resource to our Directory