MySQL UPDATE Problems [SOLVED]

[aaron]

That doesn't work?

Thank
Aaron

[wide_load]

That doesn't work?

Thank
Aaron

then put

Line number On/Off | Expand/Contract | Select all

1. echo mysql_error();

somehwere after the query and see what the problem is.

could be a permissions thing.

[aaron]

I get this error message:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''totals'' at line 1

Aaron

[aaron]

Ahh, I figured it out, I had to remove the ' ' around "totals" in the query.

Thanks for all your help
Aaron

[aaron]

Now that that is sorted, I'm looking to be able to validate an input to only allow numeric values and one decimal point. Any help?

Thanks
Aaron

[wide_load]

Now that that is sorted, I'm looking to be able to validate an input to only allow numeric values and one decimal point. Any help?

Thanks
Aaron

php has a function called is_numeric(); it pretty much does this for you.

i cant link to the page because the forum is being SILLY still