如何将变量的值传递给mysql foreach行

Question

 $sql = mysql_query("SELECT * From orders");

 while ($row = mysql_fetch_array($sql))
 {
     $datef = strtotime($row['Date1']);
     $dates = strtotime($row['Date2']);
     $rprice = $row['Pprice'];

     $datediff = floor(($datef + $dates ) / 86400);
     $total = $datediff * $rprice;

     echo $total; 
 }

After that code, i want to update a table and insert into a colum the price for each of the rows. as far as i echo $total i get back just 1 row...

Answer 1

try this if it works

  function total($date1,$date2,$price){

  $datedif = floor(($date1 + $date2 ) / 86400);
 $total = $datedif * $price ;
  return $total ;

 }
 $sql=mysql_query("SELECT * From orders");

 while ($row = mysql_fetch_array($sql)) 

{   $datef = strtotime($row['Date1']);
    $dates = strtotime($row['Date2']);
    $rprice=$row['Pprice'];
    echo total($datef,$dates,$rprice).'<br />' ;

 }

EDIT:

insert into ammounts (Total_Cost) VALUES ('total($datef,$dates,$rprice)')
WHERE id = '$row["id"]'