Resource id, Array contents of variable

[dougmcc1]

Very easy question:

How do you retrieve a value from a mySQL database field and store it into a PHP variable? I always get 'Resource id #4' or 'Array' as the value of the variable.

[barand]

$sql = "SELECT fielda, fieldb FROM mytable";
$result = mysql_query($sql);

At this point, $result holds a pointer to your results; you need to fetch the rows returned by the query.

You have lots of choices

while ($row = mysql_fetch_row($result)) {
   $vara = $row[0];
   $varb = $row[1];
   //process the data
}

while (list($vara, $varb) = mysql_fetch_row($result)) {

   //process the data
}

while ($row = mysql_fetch_array($result)) {
   $vara = $row['fielda'];
   $varb = $row['fieldb'];
   //process the data
}

Theres also [man]mysql_fetch_assoc/man and [man]mysql_fetch_object/man

hth

[dougmcc1]

Thanks barand, that's one of the best replies I've ever gotten. I think I understand this now. Showing me the diferent ways to do it really helps. Thanks again.