include('annabanana/connect.php'); if (!($limit)){ $limit = 5;} // Default results per-page. if (!($page)){ $page = 0;} // Default page value. $numresults = mysql_query("SELECT * FROM website WHERE premade='Yes' ORDER BY w_id DESC"); // the query. $numrows = mysql_num_rows($numresults); // Number of rows returned from above query. if ($numrows == 0){ echo("No results found matching your query - $query"); // bah, modify the "Not Found" error for your needs. exit();} $pages = intval($numrows/$limit); // Number of results pages. // $pages now contains int of pages, unless there is a remainder from division. if ($numrows % $limit) { $pages++;} // has remainder so add one page $current = ($page/$limit) + 1; // Current page number. if (($pages < 1) || ($pages == 0)) { $total = 1;} // If $pages is less than one or equal to 0, total pages is 1. else { $total = $pages;} // Else total pages is $pages value. $first = $page + 1; // The first result. if (!((($page + $limit) / $limit) >= $pages) && $pages != 1) { $last = $page + $limit;} //If not last results page, last result equals $page plus $limit. else{ $last = $numrows;} // If last results page, last result equals total number of results. ?>
All our clients have the ability to give us feedback in there control panel for there website. We do not control the comments from our clients. This allows you to see the pure honesty testimonials from our clients good or bad....(hopefully there is no bad).
$query = 'SELECT * FROM business ORDER BY c_id DESC'; $result = mysql_query($query); if($result) { while($row = mysql_fetch_array($result)){ $name=$row['name']; $feedback=$row['feedback']; if ($feedback=="") { echo""; } else { echo'"'.$feedback.'"
'.$name.'