[RESOLVED] Quick question

[LiamBailey]

when I run a mysql query that brings two rows of results. Is there any way I can seperate the rows and turn each row into a seperate associative array? I know how to create an associative array with one result row but I need to create a seperate associative array for two result rows to achieve what I am after.

Thanks in advance

[tomhath]

http://mysql.openmirrors.org/doc/refman/5.1/en/c-api-multiple-queries.html

[LiamBailey]

Link no good, I'm working in PHP not C.

[examancer]

well, if you want two rows within one multi-dimensional array, you could do the following:

$rows = array();
while ($row = mysql_fetch_array($result)) { $rows[] = $row; }

if you want two separate arrays, it would more like this:

$row1 = mysql_fetch_array($result);
$row2 = mysql_fetch_aray($result);

[LiamBailey]

Thanks so much Examancer, I always thought that the second option you suggested would simply return the same data twice, but I used it and it works a charm. I had actually manages to achieve the desired result by doing a second query but this way id much better, thanks again.