Just playing around with the camera on a rainy night. I like the way it came out. Leave me a comment with your thoughts.

This is an update for a small business located in south Georgia near Savannah. The original site was mostly text with some information about the business. The new design more closely matches the brochure for the company. The company does not usually have customers searching for products on the web, but with the growing increase of users on the web, this will help the company with future growth as the world changes.

View the site here

This website was developed for an event firm that found me through other examples for websites in the Florida area. The site was mostly a registration form with several pages of information about the trip. The form was then dynamically emailed to the event firm with a backup copy also saved to a local database. It also utilized some of the ajax features included in dreamweaver cs3 to minimized the amount of space required to display the form on the screen.

You can view the website by clicking here

This has been a very handy script for displaying results from a database. Most people don’t want to scroll through hundreds of records on a single page. The answer is to limit the return of the data to the browser and then give the user a link to the next page. Here are the basics.

Write a query to pull the data you wish to show to the end user

$sql1 = "SELECT * FROM " . $mytable . " ORDER BY createdon DESC";

Store the total number of rows returned by your query.
Also determine how many results you want to show on each page. For this example, I am using 10.


$results = mysql_query($sql1) or die(mysql_error());
$rowcount = mysql_num_rows($results);
$perpage = 10;


Now we know how many records exist and how many we are going to display on each page. Lets find out what number the last page is going to be.

$last = ceil($rowcount/$perpage);

(continue reading…)