[PHP] Help with SQL statement

2003-03-03 Thread Sarah Heffron
I have a database that holds a start date and an end date and I have a form with a start date and an end date. The report would be to get everything in the database's date ranges that overlap the form's date range. I am having trouble figuring out how to get this to work, any help is appreciated.

[PHP] Bi-weekly pay period

2003-02-03 Thread Sarah Heffron
I'm writing a quick little thing to act as a time clock since people are writing out by hand and it's not so accurate. It's basically click a button to clock in and click a button to clock out. What I also want to do is create a report (well I've already created the report) but I want to limit it

[PHP] Form won't submit when pressing enter key

2003-01-15 Thread Sarah Heffron
I have a form created by this code (I don't know if it's important): if ($_POST[submit]) { //do form stuff } else { echo html; echo head; echo titleForm/title; echo /head; echo body; echo h3Lookup Customer/h3; echo Enter the customer's uhome/u phone

[PHP] Suggestions on how I should handle this

2002-12-23 Thread Sarah Heffron
I have an application I've written for a pet sitting service. So someone calls and says they need a pet sit and we take their info and pick a sitter. We call that sitter to see if they can take the job, but if they say no, then we have to change it to a new sitter who can take the job. I want to