store result in variable

[pietbez]

can someone please point out where i m going wrong.

 

this code is working fine, but i need the results in a variable

$result = mysql_query("SELECT * FROM `gifts` WHERE `id` =$id ");

while($row = mysql_fetch_array($result))

  {
  echo  $row['price'] , $row['units'];
  }

so, when i do this, i only get the first variable???

$result = mysql_query("SELECT * FROM `gifts` WHERE `id` =$id ");

while($row = mysql_fetch_array($result))

$price = $row['price'];
$units = $row['units'];

  {
  echo  $price , $units;
  }

please help.

[litebearer]

look at the placement of your braces

also variable DOT variable, NOT comma

[mac_gyver]

echo actually does accept a comma separated list of arguments.

[pietbez]

thanks, got it