mysql_fetch_array($result) works too. It fetches the data from the current row and is
used in conjunction with a while loop:
while($array=mysql_fetch_array($result))
{
//stuff to do with the current array
}
Robbert van Andel
-----Original Message-----
From: Mike Mannakee [mailto:[EMAIL PROTECTED]
Sent: Monday, March 10, 2003 8:45 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP] MySQL and PHP arrays
You get at the data through $array = mysql_result($result,0,0);
Mike
"{R}Ichard Ashton" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> On Mon, 10 Mar 2003 22:34:44 +0800, Jason Wong wrote:
>
> >On Monday 10 March 2003 22:30, {R}ichard Ashton wrote:
> >> Is there a generally recommended way of storing an array created by PHP
> >> in a MySQL database field ?
> >
> >serialize() and unserialize().
> >
> >> What type of field should it be, and how do you get the whole array
> >> back in one go without reconstructing it row by row, if that is
> >> possible?
> >
> >Any text field will do, just make sure it's large enough for your data.
>
> Thanks that now makes much more sense. So when I look at the data in
> the database I see
> a:142:{i:1;s:52:[52characters];i:2;s:37:[37characters] and so on for
> the 142 elements of the array.
>
> But getting it out is not so easy.
>
> $result = mysql_query( " select post from posts where id = '$id' ")
>
> Gives $result as a Resource id #6 which is OK but I cant find the PHP
> MySQL command to get the whole field back to unserialize it :(
>
> {R}
>
>
>
> >--
> >Jason Wong -> Gremlins Associates -> www.gremlins.biz
> >Open Source Software Systems Integrators
> >* Web Design & Hosting * Internet & Intranet Applications Development *
> >------------------------------------------
> >Search the list archives before you post
> >http://marc.theaimsgroup.com/?l=php-general
> >------------------------------------------
> >/*
> >QOTD:
> > I'm not bald -- I'm "hair challenged".
> >
> > [I thought that was "differently haired". Ed.]
> >*/
> >
> >
> >--
> >PHP General Mailing List (http://www.php.net/)
> >To unsubscribe, visit: http://www.php.net/unsub.php
> >
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
