Percentage

[shalomajay]

hi all,

wondering how to get precentages sorted out here. Here's my code, the first bit will return 1 & the second part gives value 5.

what i want to do is assign the result of the first code ie 1 to a variable & likewise do the same for second code then do something like (1/5)*100 to calculate the percentage

any ideas?

regards,
Joe

---

include("dbinfo.inc.php");
mysql_connect($localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query='SELECT COUNT() FROM country where currency_code = "INR"';
$result=mysql_query($query);
$num=mysql_fetch_row($result);
echo 'Total No. of completed migrations = '.$num[0];
//$sum = ($num[0]/10)100;
mysql_close();

include("dbinfo.inc.php");
mysql_connect($localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query='SELECT COUNT(*) FROM country';
$result=mysql_query($query);
$num=mysql_fetch_row($result);
echo 'Total No. of migrations = '.$num[0];
mysql_close();

---

[rincewind456]

I'd do it in one go like

include("dbinfo.inc.php");
mysql_connect($localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query='SELECT COUNT(*) FROM country where currency_code = "INR"';
$result=mysql_query($query);
$num=mysql_fetch_row($result);
echo 'Total No. of completed migrations = '.$num[0];
//$sum = ($num[0]/10)*100;
$Queryresult1 = $num[0];


$query='SELECT COUNT(*) FROM country';
$result=mysql_query($query);
$num=mysql_fetch_row($result);
echo 'Total No. of migrations = '.$num[0];
$Queryresult2 = $num[0];

mysql_close();

echo $Queryanswer = (($Queryresult1/$Queryresult2)/100);

[shalomajay]

thanks that worked really well. Any idea how to plot of a pie chart with the output?

I've seen a few chart codes but i dont know how to apply it to my situation. Any ideas would be great.

regards,
Joe

[rincewind456]

There's a nice class and an example here