[RESOLVED] Changing number format in a cell

[Jermizzle]

I have a field within a table which holds an average score. Because the averages are divided by 3, they often get as long as 6 decimal places. I want to change this is 2 decimal places and looked up printf.

I am confused on how to implement this into the cell.
Here is what i have done.

echo "<td><font face=Verdana size=-1>" printf ('%01.2f',$average) "</td>";

But this doesnt work because of the opening and closing quotes.

Help

Thanks

[laserlight]

You have to choose between using echo and sprintf(), or using printf() directly.

echo "<td><font face=Verdana size=-1>" . sprintf('%01.2f', $average) . "</td>";
// or
printf("<td><font face=Verdana size=-1>%01.2f</td>", $average);

Incidentally, I note that your HTML is not well formed (there is no closing font tag), and that CSS stylesheets should be preferred to specifying font via font elements.

[Kudose]

laserlight is faster

[Jermizzle]

thanks for the help laserlight

i have another problem. i want to send an email to some people when a new entry has been added to the database. i would like an email to be created once the submit button has been pressed. i first tried an IF statement. this is what i tried:

if ('submit'){
echo "mailto:[e-mail]";
}

but this echoed the text. then i remembered about a href but then i would have to add text so it would be like a hyperlink and that is something which i do not want.

i looked up mailto in PHP, and i came across sending emails without a link which was what i was looking for but it mentions that i can only be placed as a header.

<?php
header("Location: mailto:[e-mail]");
?> 

is there anyway i can get the email to appear by only clicking on the submit button.

Thanks

[Kudose]

You need the [man]mail[/man] function.

[scrupul0us]

i think he wants an email window from outlook to open up... not an automated mail using mail()