-----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-----
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
