Re: [PHP] Weird result from query...?

2004-02-27 Thread Jeff Harris
|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

Re: [PHP] Weird result from query...?

2004-02-26 Thread Erwin Kerk
Ryan A wrote: which runs the sql in show_accounts.php: SELECT *,now()-0 from .$tcname. where oorder='.$o.' and nname='.$n.' and total='$p' 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

Re: [PHP] Weird result from query...?

2004-02-26 Thread André Cerqueira
-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

Re: [PHP] Weird result from query...?

2004-02-26 Thread Ryan A
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...

Re: [PHP] Weird result from query...?

2004-02-26 Thread Daniel Clark
p=4.78 I wonder if a dot is a valid character for a URL adderss? Hi, Just been getting some weird results from a query...can anybody tell me why..? Basically am sending 3 variables via a link on the page... http://localhost/show_accounts.php?o=8927437717300145n=shanep=4.78 which runs the

Re: [PHP] Weird result from query...?

2004-02-26 Thread Erwin Kerk
Daniel Clark wrote: p=4.78 I wonder if a dot is a valid character for a URL adderss? Yup. Just tried it, it works. Erwin Kerk Web Developer -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Weird result from query...?

2004-02-26 Thread Ryan A
Hi, Just been getting some weird results from a query...can anybody tell me why..? Basically am sending 3 variables via a link on the page... http://localhost/show_accounts.php?o=8927437717300145n=shanep=4.78 which runs the sql in show_accounts.php: SELECT *,now()-0 from .$tcname. where