On Sat, February 16, 2008 11:53 pm, Johny Burns wrote: > I am having fields in my table where I put times like 4:30pm in string > format This is your first mistake... Use time fields for time, so you can do time operations on time fields. Otherwise, you are just re-inventing the wheel and re-writing a billion lines of code that the database geeks already wrote, tested, and QA-ed. Once you fix this, your question becomes a non-question... -- Some people have a "gift" link here. Know what I want? I want you to buy a CD from some indie artist. http://cdbaby.com/from/lynch Yeah, I get a buck. So? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php