Problem with negative Numbers in Query

[solidefy]

I have a database with positive & negative numbers in it. I have a select query that pulls records out of the database based on the value of that number.

Now here's whats wierd, when the number is positive, it works but when it's negative it doesn't. I know for a fact that the negative number is in the database, but I still get an error saying that Supplied Argument is not a valid MySQL Resource.

The Positive number works perfectly and prints the desired result.

I've tried different datatypes in the database, decimals, intergers, floats, varchar, etc., but with no success.

Any help or suggestions would be great, I am really stumped

Thanks

[Weedpacket]

I suggest posting some code so that we can better see what you're talking about and what your problem is.

I also suggest a strategic use of mysql_error() to see what MySQL reckons the problem is.

[solidefy]

Okay this is basically what is happening

Lets say there is a record in the database where field n is '-25.3456'. and a record where the same field is '21.4648'.

the query:

"SELECT * FROM table WHERE n = '21.464'";

would return the record and the script would do everything it's supposed to, no problem.

however, the query:

"SELECT * FROM table where n = '-25.3456'";

returns an error.

I used mysql_error() and got this result:

You have an error in your Syntax near 'n = -25.3456' at line 1

So hope that makes it a little clearer

Thanks