[SOLVED] First row from an array

[gerkintrigg]

Is my math wrong with this?

 

<?php 
include 'db.php';
$i=0;
$no_of_rows=mysql_result(mysql_query("SELECT COUNT(*) AS RECORDS FROM schedule
WHERE '$week_start2'
between start_date and end_date;"),0);
$pquery="SELECT cost, sup_percent 
FROM schedule, rate
WHERE schedule.rate_id = rate.rate_id
and '$week_start2'
between start_date and end_date;";
$pq=mysql_query($pquery);
while ($pr=mysql_fetch_array($pq)){
$i++;
if ($i==1){
	$price=$pr['cost'];
}
else{
	$percentage=($price/100)*$pr['cost'];
}
}
if ($no_of_rows==2){
$price=$price+$percentage;
}

echo $price;
?>

 

 

[Barand]

Is my math wrong with this?

 

That would depend on what you are trying to do.