|The home page of|
Appointment scheduling in MySQL29 Oct 2012 18:30
Recently I had to write an appointment scheduling application.
CREATE TABLE `tbl_visit` (
A stored procedure used to generate a daily diary of appointments to be e-mailed by the scheduling application could use the following in a WHERE clause to select out visit records from tbl_visit that should occur today:
The checks on the other part of the date are a lot simpler i.e. does the value in tbl_visit match today or is it null?
1 Comment | Comment on this
VillaDesk 3.5 Released!18 Jun 2011 16:33
Version 3.5 of the VillaDesk holiday home booking and enquiry management system is now available. If you are an existing user of the software, you can update to the new version by running the update checker from within the software, otherwise, you can download the software from http://www.villadesk.com/ The new version adds support for multiple currencies .i.e. it is now possible to enter payments in the original currency and the system will automatically calulate the payment amount in your selected base currency, based on the exchange rates set up in the software.
15 Comments | Comment on this
Gadgets and things20 Mar 2011 19:40
If 10 years ago someone had told me that in 2011 pretty much everybody would be walking around with what is in essence a powerful, pocket sized, touch-screen computer with reasonably fast Internet access and the added ability to make and receive telephone calls, I would have laughed. Then again, back then I had a Nokia 5110 with a 5 line monochrome display IIRC.
1 Comment | Comment on this
TinyMCE24 Nov 2010 21:50
I am trying out the TinyMCE WYSIWYG HTML editor on the part of the site where I add posts. It seems OK, I might use it. This is what it looks like out of the box on the textarea where I enter posts:
42 Comments | Comment on this
Countdown Solver20 Nov 2010 20:06
The Countdown solver can now produce solutions to the numbers game. Hopefully people will find it useful.
52 Comments | Comment on this
Welcome to my newly renovated website!17 Nov 2010 21:52
As you can see I have finally gotten round to redesigning my website. Since I don't do Twitter or Facebook, I have added a blog section here that I will update when and if I think of anything to write about. My old site did have a blog than ran off Livejournal, but it wasn't very easy to update and it never worked too well. I have also updated the gallery/photo blog so that I can upload pictures remotely. In hindsight that actually sounds like a somewhat fundemental feature for a photo blog but it was missing from my old photo blog. The photo blog also no longer stores photo captions in an .ini file...
Comment on this
Ben Mason is a computer programmer from Reading in England. This is his personal website and blog.
Posts by MonthMarch(0)
Posts by CategoryMySQL(1)
|Copyright © MM-MMX, Ben Mason|