I manage to get a solution, I put all the data into an array, then looped the array how I needed to access the data.
Thanks for the help- Matt -----Original Message----- From: Hugh Bothwell [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 3:40 PM To: Matt Babineau Subject: Re: [PHP-WIN] Re: How do I access a mysql result array? ----- Original Message ----- From: "Matt Babineau" <[EMAIL PROTECTED]> To: "'Hugh Bothwell'" <[EMAIL PROTECTED]> Sent: Sunday, December 08, 2002 8:29 PM Subject: RE: [PHP-WIN] Re: How do I access a mysql result array? > Pretty much exactly that. > > I want to get a result set into an array that I can access in a weird > order. > > I know the mysql results are in some sort of array format, but > couldn't access it. Almost always, a MySQL connection is buffered - that is, it *does* have the data you need stored internally. But it is possible to have an unbuffered connection. For this reason, the data is only accessible serially. You could retrieve the next row you want manually using mysql_data_seek(), but I would expect this to be much slower, and I really wouldn't recommend it. Again, what exactly are you trying to accomplish? ie, *why* do you need to access the rows in a "weird" order? Is there some way to presort the data so MySQL returns it in the order you need - then you can just cycle through it as usual? -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
