function cuttext($dtext, $dchar) {
		if (strlen($dtext) > $dchar) {
			$dtext = substr($dtext, 0, $dchar);
			$dtext .= "...";
		}
		return $dtext;
	}
	$db = mysql_connect($dbhost,$dbuser,$dbpass) or die(mysql_error());

	mysql_select_db($dbname,$db);
	if (@!$page) {
		$howmany = mysql_query("Select id FROM rides", $db);
		$result = mysql_query("Select * FROM rides order by id desc limit $resultsperpage", $db);
	} else {
		$timesrpp = $page * $resultsperpage;
		$offset = $timesrpp - $resultsperpage;
		$howmany = mysql_query("Select id FROM rides", $db);
		$result = mysql_query("Select * FROM rides order by id desc limit $offset,$resultsperpage", $db);
	}

	$count = 0;
	while ($total = mysql_fetch_array($howmany)) {
		$count++;
	}
	$pages = ceil($count / $resultsperpage);

	print ("
          <tr>
            <td>
              <small><small>$count Total Rides Posted - 
	");

	if (@!$page) {
		echo "<font color=666666>Prev</font> ";
	} elseif (@$page == 1) {
		echo "<font color=666666>Prev</font> ";
	} else {
		$prev = $page - 1;
		echo "<a href=\"".$basehref."index.php?page=$prev\">Prev</a> ";
	}
	for ($i = 0; $i < $pages + 0; $i++){
		$pnum = $i + 1;
          	if (@!$page && $pnum == 1) {
			echo "$pnum ";
		} elseif (@$page == $pnum) {
			echo "$pnum ";
		} else {
			echo "<a href=\"".$basehref."index.php?page=$pnum\">$pnum</a> ";
		}
	}

	if (!$page) {
		if ($pnum > 1) {
			echo "<a href=\"".$basehref."index.php?page=2\">Next</a> ";
		} else {
			echo "<font color=666666>Next</font> ";
		}
	} else {
		if ($page == $pnum) {
			echo "<font color=666666>Next</font> ";
		} else {
			$next = $page + 1;
			echo "<a href=\"".$basehref."index.php?page=$next\">Next</a> ";
		}
	}

	print ("</small></small>
            </td>
          </tr>
        </table>
	");

	while ($row = mysql_fetch_array($result)) {
		$cid = $row["id"];
		$cname = $row["tname"];
		$cyear = $row["tyear"];
		$cmake = $row["tmake"];
		$cmodel = $row["tmodel"];
		$cfab = $row["tfab"];
		$cown = $row["town"];
		$cdesc = $row["tdesc"];
		$cimg1 = $row["timg1"];

		print ("

        <table width=\"80%\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\" height=\"235\" bordercolor=\"#CCCCCC\">
          <tr bgcolor=\"#CCCCCC\"> 
            <td bordercolor=\"#CCCCCC\" height=\"13\" bgcolor=\"#CCCCCC\"> 
              <div align=\"center\"><b><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"2\" color=\"#003366\">". stripslashes($cname) ."</font></b></div>
            </td>
          </tr>
          <tr> 
            <td align=\"center\" valign=\"middle\"> 
              <table width=\"97%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" height=\"232\">
                <tr> 
                  <td width=\"51%\" align=\"center\" valign=\"middle\" height=\"123\"><img src=\"$basehref$imgdir$cimg1\" width=\"200\" height=\"150\"></td>
                  <td width=\"49%\" height=\"123\"> 
                    <p><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"2\"><b>Year</b>: 
                      ". stripslashes($cyear) ."<br>
                      <b>Make</b>: ". stripslashes($cmake) ."<br>
                      <b>Model</b>: ". stripslashes($cmodel) ."<br>
                      <b>Fabricator</b>: ". stripslashes($cfab) ."<br>
                      <b>Owner</b>: ". stripslashes($cown) ."</font></p>
                    <p><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"2\">" . cuttext(stripslashes($cdesc), 200) . "</font></p>
                    <p><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"2\"><a href=\"".$basehref."ride.php?id=$cid\">more...</a></font></p>
				  </td>
                </tr>
              </table>
            </td>
          </tr>
        </table>
		");
	}

	print ("
        <table width=\"80%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">
          <tr>
            <td>
              <small><small>$count Total Rides Posted - 
	");

	if (@!$page) {
		echo "<font color=666666>Prev</font> ";
	} elseif (@$page == 1) {
		echo "<font color=666666>Prev</font> ";
	} else {
		$prev = $page - 1;
		echo "<a href=\"".$basehref."index.php?page=$prev\">Prev</a> ";
	}
	for ($i = 0; $i < $pages + 0; $i++){
		$pnum = $i + 1;
          	if (@!$page && $pnum == 1) {
			echo "$pnum ";
		} elseif (@$page == $pnum) {
			echo "$pnum ";
		} else {
			echo "<a href=\"".$basehref."index.php?page=$pnum\">$pnum</a> ";
		}
	}

	if (!$page) {
		if ($pnum > 1) {
			echo "<a href=\"".$basehref."index.php?page=2\">Next</a> ";
		} else {
			echo "<font color=666666>Next</font> ";
		}
	} else {
		if ($page == $pnum) {
			echo "<font color=666666>Next</font> ";
		} else {
			$next = $page + 1;
			echo "<a href=\"".$basehref."index.php?page=$next\">Next</a> ";
		}
	}

	print ("</small></small>
            </td>
          </tr>
        </table>
	");

	mysql_close($db);

	include("footer.php");

?>