Re: [PHP] Re: MySQL and PHP weirdness - RESOLVED

2012-02-15 Thread Richard S. Crawford
This has been resolved. A previous programmer had snuck in a function that would convert the value of the "description" field to a date value if it contained the word "Date". This has been fixed. On Tue, Feb 14, 2012 at 5:44 PM, David Robley wrote: > Richard S. Crawford wrote: > > > Bear with m

[PHP] Re: MySQL and PHP weirdness

2012-02-14 Thread David Robley
Richard S. Crawford wrote: > Bear with me here. I have a problem with PHP and MySQL that's been > stumping me for a couple of days now. I'm not even sure how to describe > it, so I'll just do my best. > > There's a row in our bugs database that looks like every other row in the > table, but when

[PHP] Re: MySQL and PHP math problem...

2002-11-09 Thread Peter
Thanks...the thing that I did wrong was I retrieved the number with FORMAT(SUM(amount), 2), which formats the number and return it in the string format...so that's what happened during the computation (it only took the number prior to the ','. I miss the type-checking in C. :-) Thanks, -Peter "@

[PHP] Re: MySQL and PHP math problem...

2002-11-09 Thread @ Edwin
Hello, "Peter" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... ...[snip]... > the result of echo, $tmp is displayed as '0.0002'. What's wrong here? The > problem only occurs when the value is greater than a 1,000? Could the ',' >

[PHP] Re: MySQL and PHP

2002-01-17 Thread Philip Hallstrom
Does your query have a semicolon in it when you run it in PHP? Or did you paste the below from a mysql session? -p On Thu, 17 Jan 2002, Brandon Orther wrote: > Hello, > > I am trying to use mysql through php. When I try to run the following > query it does nothing. I am trying to figure out

[PHP] RE: MySQL and PHP problem

2001-09-23 Thread Ben Edwards
4.0.6, yes, douse this mean you have a possible solution -:) At 06:54 A 23/09/01 , you wrote: >SpamCop - Report spam: >http://members.spamcop.net/mcgi?action=logreport&id=10282302 > >I assume you mean PHP 4.06? > >-- >Billy Cravens > >-Original Message- >From: Ben Edwards [mailto:[EMAIL P