Re: Weird result from query...?

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 [snip]

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. [/snip]

i think that means the dot DOESNT work hehe because with 0's or not, a 4.00 is a 4, while 4.11 wouldnt be the same thing without the dot and the things that follow... try an url like this: http://localhost/show_accounts.php?o=8927437717300145&n=shane&p=4%2E78 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

Try this: which runs the sql in show_accounts.php: SELECT *,now()-0 from ".$tcname." where oorder='".$o."' and nname='".$n."' and total=$p without the single quotes around $p Erwin Kerk Web Developer

- -- André Cerqueira -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFAPtCAaxdA/5C8vH8RAvPpAJ9Ay6WK9BsYaUh/TJsaNt+d6YaLtACg1gGE 8Z39+7oB32MAg1fKw/3sla8= =3/la -----END PGP SIGNATURE-----