array from while loop

[phpretard]

I am trying to form an array from thre value of $cost.

 

 

$result = mysql_query("SELECT * FROM table ");

while($row = mysql_fetch_array($result))
  {
  $cost=$row['cost'];
  }

 

$a=array(SOMTHING HERE);

 

any thoughts?

 

 

[MadTechie]

Very close

<?php
$result = mysql_query("SELECT * FROM table ");
$cost = array();
while($row = mysql_fetch_array($result))
{
  $cost[] =$row['cost'];
}
?>

 

i normally do this (may not work on yours)

<?php
$result = mysql_query("SELECT * FROM table ");
$cost = array();
while($row = mysql_fetch_array($result))
{
  $cost[$row['uID']] =$row['cost']; //uID = my unique id
}
?>

[phpretard]

On that note ... I may be approaching this wrong...

 

I am looking to add all the $cost together.

 

$result = mysql_query("SELECT * FROM table ");

while($row = mysql_fetch_array($result))
  {
  $cost=$row['cost'];
  }

 

 

$cost has as many values that are in the DB.  I just want to take the total of all the rows and echo it out.

 

 

[MadTechie]

okay to add it all up, try this

<?php

$result = mysql_query("SELECT * FROM table ");
$cost = 0;
while($row = mysql_fetch_array($result))
{
  $cost=$cost + $row['cost'];
}

?>

[phpretard]

Thank you for being patient with me.  I should have mentioned I would like the total from all the rows outside of the loop.

[MadTechie]

not sure what you mean now..

<?php

$result = mysql_query("SELECT * FROM table ");
$cost = 0;
while($row = mysql_fetch_array($result))
{
  $cost=$cost + $row['cost'];
}
echo $cost;
?>

or

<?php

$result = mysql_query("SELECT *, SUM(cost) as total FROM table ");
$cost = 0;
while($row = mysql_fetch_array($result))
{
  echo "total = ".$row['total'];
}
?>