Re: note 101984 modified in function.mysql-fetch-array by thiago

I normally would, but in this case I thought the comment was good enough to keep it. Thiago Henrique Pojda +55 41 8856-7925 On Fri, Jan 21, 2011 at 2:08 PM, Daniel P. Brown <daniel.brown@parasane.net>wrote: > You don't have to remove non-English, only remove if there's no > English at all. > > > On Fri, Jan 21, 2011 at 11:14, <thiago@php.net> wrote: > > If you use implode() with the return value by mysql_fetch_array, if you > use MYSQL_BOTH on parameter 2, the result is not really what you're > expecting. > > For example : > > my sql database contains "Amine, Sarah, Mohamed"; > > > > $array = mysql_fetch_array($resource,MYSQL_BOTH); > > or $array = mysql_fetch_array($resource); > > echo implode(" - ", $array); > > > > the result is : Amine-Amine-Sarah-Sarah-Mohamed-Mohamed > > and we expect just : Amine-Sarah-Mohamed > > > > You must use MYSQL_NUM or MYSQL_ASSOC on parameter 2 to resolve the > problem. > > > > --was-- > > If you use implode() with the return value by mysql_fetch_array, if you > use MYSQL_BOTH on parameter 2, the result is not really what you're > expecting. > > For example : > > my sql database contains "Amine, Sarah, Mohamed"; > > > > $array = mysql_fetch_array($resource,MYSQL_BOTH); > > or $array = mysql_fetch_array($resource); > > echo implode(" - ", $array); > > > > the result is : Amine-Amine-Sarah-Sarah-Mohamed-Mohamed > > and we expect just : Amine-Sarah-Mohamed > > > > You must use MYSQL_NUM or MYSQL_ASSOC on parameter 2 to resolve the > problem. > > > > -------------------------------------------------------------- > > > > Si vous utilisez implode() qui prend en parametre la valeur retournée > mysql_fetch_array, si vous mettez en 2eme parametre MYSQL_BOTH (ou rien) le > resultat retourné n'est pas vraiment le resultat que vous attendez : > > par exemple: > > > > Ma sql database contient "Amine, Sarah, Mohamed"; > > > > $array = mysql_fetch_array($resource,MYSQL_BOTH); > > or $array = mysql_fetch_array($resource); > > echo implode(" - ", $array); > > > > Le resultat affiché est : Amine-Amine-Sarah-Sarah-Mohamed-Mohamed > > alors que nous attendons : Amine-Sarah-Mohamed > > > > Vous devez utiliser MYSQL_NUM or MYSQL_ASSOC en 2eme parametre pour > resoudre le probleme. > > > > http://php.net/manual/en/function.mysql-fetch-array.php > > > > -- > > PHP Notes Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > > -- > </Daniel P. Brown> > Dedicated Servers, Cloud and Cloud Hybrid Solutions, VPS, Hosting > (866-) 725-4321 > http://www.parasane.net/ > > -- > PHP Notes Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >