Getting a single row into an array

[generik99]

Hey, got a Q about mysql with an array.

Say I've done a query that returns 3 rows. I know I need the 2nd row, but can i extract that single row from the results, into an associative array?

mysql_fetch_array() would work fine if I could specify the actual row I want.

Any suggestions?

Thanks,
Generik99

[generik99]

eh I got er, mysql_data_seek()... reminds me of good ol turbo pascal 😉

Cheers,
Generik99

[GSHelpBoy]

Assuming the rows have IDs you could do this:

$sql = "SELECT * FROM `table` WHERE `id` = '2' LIMIT 1";
$query = mysql_query($sql);
$array = mysql_fetch_array($query);