Database entries assigned to Variables

[danosmanos]

Dear All,
At the moment I assign entries from a mysql database to variables like this;

while ($row =
mysql_fetch_array($sql_result)) {
$id= $row["id"];
$ref= $row["ref"];
$photoout=$row["photoout"];
$photoin = $row["photoin"];
$reading = $row["reading"];
$name = $row["name"];
$blurb = $row["blurb"];
$blurb2 = $row["blurb2"];
$price = $row["price"];
$type = $row["type"];
$dosage = $row["dosage"];
$largestorder = $row["largestorder"];
$filter1 = $row["filter1"];
$filter2 = $row["filter2"];
}

There must be a better way to do this. Do any of you know?

[jesus_hairdo]

you can use foreach
http://www.php.net/manual/en/control-structures.foreach.php

you would do something like
while ($row=mysql_fetch_array($sql))
{
foreach ($row as $key=>$value)
{
$key = $value;
}
}

in this key is the field name, and value is the value,
You would then have the list of variables as the long list you did.

Jamie