Getting Rid of 0!

ESCForums_com

I am outputting some info from SQL.. it works great, but on the php side I don't want it listing numbers which are = 0

$myrow[3] = str_replace(".50",".5",str_replace(".00","",str_replace("0.00","",$myrow[3])));

I am using the above to get rid of pointless numbers that show up on the table, like I don't want 10.00, or 12.50 showing up, I want 12.5, and 10 showing up, and if a tables value is 0, just replace with nothing. The problem I'm having is that its take 0.00 literally, and replacing the 10.00's with 1, all the other numbers that are like this (20.00, 100.00 etc.. ) also are effected..otherwise this does exactly what I need it too.

So I do save my 10's? 😉

TIA!

-Phil

bernouli

try this

$myrow[3] = ereg_replace(",(.)*0"," ", $myrow[3]);

michael

floor()
ceil()
round()

This would be much faster.

Note: -Nevermind.

ESCForums_com

It doesn't seem to do anything 😕. The 10.00 outputs as 10.00, which it would regardless of that statement or my own.

bernouli

i tried my codes

<?php

$a = 10.00;
$b = 12.50450;

echo ereg_replace(",(.)*0"," ", $a);
//10
//12.5045
?>

and it delivers me the number, which you want

ESCForums_com

Its because my "$a" so to speak is in quotations "10.00"...oh and I don't know how to get it out lol, so is it still possible to do something?

bernouli

i see,
then try this code

$myrow[3] = ereg_replace(",(.)*0"," ", str_replace("\"","",$myrow[3]);

ESCForums_com

Nop 🙁, doesn't work at all, I even tried it on its own.

bernouli

ok, when you do

$myrow[3] = str_replace("\"","",$myrow[3]);

what did you get?

ESCForums_com

It outputs = 10.00

How do I know if it still has quotations or not???

bernouli

if it still has quotation mark, then the quotation mark will be printed too,
now try the code, after the quotation mark is gone

$myrow[3] = ereg_replace(",(.)*0"," ", $myrow[3]);

ESCForums_com

Its still a 10:00 lol, anyways your script only works for numbers, not a string...and my outputs are all in quotations 😕

bernouli

ive tried the codes, it work both for string or number

ESCForums_com

http://www.escforums.com/~mods/getmax.php

The code shown is 1 to 1 of whats in the file.

bernouli

ok now use this code

$a = "10.00";

$a = str_replace("\""," ",$a);
$a = ereg_replace("\.(.)*0"," ", $a);
echo $a;

run2web

Originally posted by bernouli
i tried my codes
<?php

$a = 10.00;
$b = 12.50450;

echo ereg_replace(",(.)*0"," ", $a);
//10
//12.5045
?>
and it delivers me the number, which you want [/B]

I tried this code and it works perfectly. The output that I get is 10.

I would double check your code. Maybe paste what you have here.

ESCForums_com

run2web :
My 10.00 is "10.00" , which makes the whole difference..
bernouli :
Ok I tried that, and now output is nothing. (I updated the example script)

run2web

Ok, so I don't understand why your 10.00 is "10.00" ????

ESCForums_com

Either do I! But that script is just an example btw! Here is what mines doing..
The SQL field example is "week1 decimal(4,2) NOT NULL default '0.00'"
And its code:

$result = mysql_query("SELECT * FROM " . $table_prefix ."coophours ORDER BY lastname ASC");
$myrow = mysql_fetch_row($result);

And $myrow[0] would be equal to "10.00" (with the quotes!) I don't know where the quotes are coming from.

run2web

Originally posted by ESCForums.com
The SQL field example is "week1 decimal(4,2) NOT NULL default '0.00'"
And its code:
$result = mysql_query("SELECT * FROM " . $table_prefix ."coophours ORDER BY lastname ASC");
$myrow = mysql_fetch_row($result);
And $myrow[0] would be equal to "10.00" (with the quotes!) I don't know where the quotes are coming from. [/B]

Well I am at a loss now as to how to help you. I think it has something to do with your code but I can't tell you how to fix it.

Let me ask you think, in your sql statement you have default '0.00'. What if you removed the single quotes from that and just used 0.00?