MySQl getting Result into Array

tiger_baiter

Hello,

I am trying to keep my DB access code separate from the rest of my code.

I have a MySQL query which retrieves multiple rows. What I want to do is put those into a multidimensional array from which I can retrieve the values elsewhere.

Does anyone know if I can do this using a MySQL function without writing a complex routine?

TIA

leatherback

Hi,

Not really. Of course you can echo all your output straight into an array, but if you really want that? I htink your code become more ugly then you'd want. Especially because you end up with going through your data twice (Once for retrieving it from the database, and once more to get it from your array).

Have a look at this thread before you decide

tiger_baiter

Thanks Leatherback.

I've had to include the mysql code at the front end for this. Oh well.

It's much easier than some conplex routine, I agree.