retrieve individual rows from mysql_fetch_array not using while loop

[monomaniac21]

hi all

im querying a db for two rows which are always returned. how can i
reference each row and output its contents without using a while loop.
ive tried:

$row = mysql_fetch_array($result);
extract $row;
echo $var1[0]; //var 1 of row 0
echo $var1[1]; //var 1 of row 1
but this doesnt seem to be working?

kind regards

Marc

[Jahjah92]

if you talk about rows and not about columns, try this :

$row0 = mysql_fetch_array($result);
$row1 = mysql_fetch_array($result);
extract $row0;
extract $row1;
echo $row0[0]; //var 1 of row 0
echo $row1[0]; //var 1 of row 1

A+
"monomaniac21" <mc******@googlemail.coma écrit dans le message de news:
11**********************@i3g2000cwc.googlegroups.c om...

hi all

im querying a db for two rows which are always returned. how can i
reference each row and output its contents without using a while loop.
ive tried:

$row = mysql_fetch_array($result);
extract $row;
echo $var1[0]; //var 1 of row 0
echo $var1[1]; //var 1 of row 1
but this doesnt seem to be working?

kind regards

Marc

[Rik]

monomaniac21 wrote:

hi all

im querying a db for two rows which are always returned. how can i
reference each row and output its contents without using a while loop.
ive tried:

$row = mysql_fetch_array($result);
extract $row;
echo $var1[0]; //var 1 of row 0
echo $var1[1]; //var 1 of row 1

Nope, it won't.
You only retrieve 1 row, you call mysql_fetch_array just once.
Furthermore, extract will create vartiables named after you fieldnames or
aliasses deriving from the query.

I think you're looking for this:
$row0var1 = mysql_result($result,0,0); (or: mysql_result($result,0); for the
first value)
$row1var1 = mysql_result($result,1,0);

Grtz,
--
Rik Wasmus

[Petr Vileta]

"monomaniac21" <mc******@googlemail.compíse v diskusním príspevku
news:11**********************@i3g2000cwc.googlegro ups.com...

hi all

im querying a db for two rows which are always returned. how can i
reference each row and output its contents without using a while loop.
ive tried:

$row = mysql_fetch_array($result);
extract $row;
echo $var1[0]; //var 1 of row 0
echo $var1[1]; //var 1 of row 1
but this doesnt seem to be working?

You can to modify sql query for returning one row only (eg. using HAVING
....) or you can use
mysql_data_seek() before mysql_fetch_array().

Tip for you:
mysql_fetch_assoc() is more friendly then mysql_fetch_array().
--

Petr Vileta, Czech republic
(My server rejects all messages from Yahoo and Hotmail. Send me your mail
from another non-spammer site please.)