get values from row 2 in array

How do I get values from row 2 in the array $myrow? I would like to refer to the name of the field aswell.

$result = mysql_query("SELECT * FROM likvid",$db);
$myrow = mysql_fetch_array ($result);

value="<? echo $myrow["DEPOT"]; ?>"

Thanks!

$myrow["DEPOT"][$i]

so the second row would be $myrow["DEPOT"][1]

Ian

thanks!

It was a long time since I posted the original message and I haven't used your code.

I've found out that your code fetches the second letter of the resultsset not the second row. Do you have any other ideas?

Thanks / Henrik

Henrik

I am sorry - here is the revised code you require. I assume that you want row 2 3 4 and so on.

$result = mysql_query("SELECT * FROM likvid",$db);
$i = 0;
while ($myrow = mysql_fetch_array($result))
{
value[$i] = $myrow["depot"];
$i++;
}

this will give you an array of values containing the "depot" field from your query

alternatively for just one specific row

$result = mysql_query("SELECT * FROM likvid",$db);
$rownumber = 1;
$field = "depot";
$value = mysql_result($result,$rownumber,$field);

the $field argument is optional and if ommited would return $value as an array of field for that row.

hope that is better...I feel like an idiot for missing the orginal point

Ian

Thank you for taking your time again!

Best regards, Henrik