Re: Weird result from query...?

|Ryan A wrote: | |> Hey everyone, |> Thanks for your response, |> |> I did try the query without the single quote, with double quotes but didnt |> work. |> I do think that a dot is valid in the URL coz it seems to be working if |> there are 2 zeros in the |> decimal part. I even tried running the SQL in PHPMyAdmin with same |> results... |> and I did try this: |> |> total='".$p."'"; |> |> I wonder if "total" is a mysql reserved word or something.... |> |> Like I said before, i took that out and everythings running fine 'n |> dandy...but am just curious as |> to what was wrong...never know if it may come up again in future. |> |> Cheers, |> -Ryan |> |> |> Sounds to me like your variable is being passed/interpreted as a string. As such, 4 will never equal 4.00. 2.1 will never equal 2.10. You should probably look at the printf() or sprintf() function to make sure that your $p will be inserted into your query string as you expect it. I'm not up on sprintf() format, but you would probably want something like <?php $sql_p = sprintf("%1.2f", $p); ?> then use $sql_p in your sql querystring. HTH Jeff -- Registered Linux user #304026. | 52FC 20BD 025A 8C13 5FC6 gpg key: B0890FED | 68C6 9CF9 46C2 B089 0FED http://pgp.mit.edu:11371/pks/lookup?op=get&search=0xB0890FED Responses to this message should conform to RFC 1855. ======================================================================== A: Because it messes up the conversation. Q: Why is top posting bad? A: Top posting. Q: What's the most annoying thing on mailing lists?