Yes, it's the last time.
It's collated, then used the output into the mysql query.
Just odd that it works on the test page, but not here.
There is no other part to it, except for when $price is used in the update query.
Why doesn't mysql allow *apostrophies* into fields?
Moderator: General Moderators
-
simonmlewis
- DevNet Master
- Posts: 4435
- Joined: Wed Oct 08, 2008 3:39 pm
- Location: United Kingdom
- Contact:
Re: Why doesn't mysql allow *apostrophies* into fields?
Love PHP. Love CSS. Love learning new tricks too.
All the best from the United Kingdom.
All the best from the United Kingdom.
-
simonmlewis
- DevNet Master
- Posts: 4435
- Joined: Wed Oct 08, 2008 3:39 pm
- Location: United Kingdom
- Contact:
Re: Why doesn't mysql allow *apostrophies* into fields?
The field type is an INT.
I've replaced it with your code, but still it isn't altering anything.
I've replaced it with your code, but still it isn't altering anything.
Love PHP. Love CSS. Love learning new tricks too.
All the best from the United Kingdom.
All the best from the United Kingdom.
-
simonmlewis
- DevNet Master
- Posts: 4435
- Joined: Wed Oct 08, 2008 3:39 pm
- Location: United Kingdom
- Contact:
Re: Why doesn't mysql allow *apostrophies* into fields?
Ok.... it did work, sort of.
I had an escape string that killed it.
But now it is rounding it up.
13997.56 becomes 13998.

I had an escape string that killed it.
But now it is rounding it up.
13997.56 becomes 13998.
Love PHP. Love CSS. Love learning new tricks too.
All the best from the United Kingdom.
All the best from the United Kingdom.
-
simonmlewis
- DevNet Master
- Posts: 4435
- Joined: Wed Oct 08, 2008 3:39 pm
- Location: United Kingdom
- Contact:
Re: Why doesn't mysql allow *apostrophies* into fields?
Bingo - thx.
Never knew about float 8,2.
Never knew about float 8,2.
Love PHP. Love CSS. Love learning new tricks too.
All the best from the United Kingdom.
All the best from the United Kingdom.
Re: Why doesn't mysql allow *apostrophies* into fields?
For prices and other values involving money I'd recommend decimal - it's exact format and calculations involving it do not tend to loose precision (unlike float).