Converting mysql result set into an array?

[bretheartbobby]

Could someone tell me the best way to convert a mysql result set into a php array please? Basically what I need to do (unless there's a better way) is to perform a query and then convert this into an array. I then need to perform a second query, convert that into an array and insert the second array into each of the first arrays members. So I end up with this:

 From query 1
        From query 2
        From query 2
        From query 2
From query 1
        From query 2
        From query 2
        From query 2
From query 1
        From query 2
        From query 2
        From query 2

I then need to convert the array into a HTML list. If anyone could offer any guidance with any of this it would be much appreciated.

Thanks.

[Admin]

Hello Bobby,

I'd really love to be able to help you on this one, however our programmer is away and i mainly do design work... So this one is slightly over my head, although i'll be sure to point him in this direction when he returns.

[rick22]

sorry buddy...
i am new to designing... i dont know much about SQL