What is this you ask? Well, this tutorial demonstrates how to alternate colors in a table when you are displaying records.

Multiple Reports with One SQL Statement. How to dynamically write reports? This is a simple way of querying your database for specific instances and only having to write one SQL query that does it all. This example is something I wrote for an Inventory Management System at my job. Here is the Results Page with the SQL Statement. Select columnname1, columnname2? Urlwhatever means you can name this url. This basically checks the data and if the field is blank, returns a? June 05, 2009.

I wrote this when I had to monitor several websites. I grabbed the first 10 characters and if they did not equal the error page then it gave the green light, but if there was a problem it gave the blinking red light. The META tag refreshes, and therefore re-executes the script as often as you have it set. The number 60 means 60 seconds. But this is the basis of it.

Include the variables file so one change updates all templates - -. Get all records from the database that match this users credentials - -. Simple HTML form at the top to insert a user into the database - -.