Re: Weird result from query...?

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