Re: Problems with implode

Okay, tested in the following manner: for ($i=12300;$i<12801;$i++){ // List is filled with integers, in the correct charset from PHP $list[] = $i; } $pidList = implode(',', $list); mail('your@email.dom, 'debug implode', var_export(array($pidList, $list),1)); And I got the same error, which indicates that perhaps implode works just as it should but the representation is off. that in it self would be okay, but how then do we control that the query is actually correct ? If we cannot trust the debug output how then can we trust that the query is doing what it is supposed to do ? Regards, Toke Toke Herkild skrev:

As stated before, packet size not the problem, data is delivered perfectly from MySQL. Problem seems to be when the result string is diplayed. I'll try to do a test with a numeric array: $list = array(12300..12800); and see what happens. regards, Toke Andrea Giammarchi skrev:

What about MySQL max_allowed_packet setting? is it bigger than produced string?

To: php-general@lists.php.net Date: Tue, 24 Mar 2009 15:23:20 +0100 From: th@ezl-data.dk Subject: Re: [PHP] Problems with implode Per Jessen skrev:

Andrea Giammarchi wrote:

Dunno why you guys started talk about utf-8 problems, he has a list of ids which should contain only unsigned integers, otherwise I do not get how that query could work with an implode(',', $whatever)

Very good point - maybe the OP has not yet tested his code that far? Is there a possibility that some of the id's are _not_ just plain integers made up of 0-9? /Per

And exatly the reason I tried the following: $list[] = $row['uid']; $list[] = intval($row['uid']); $list[] = mb_convert_encoding($row['uid'], 'iso-8859-1'); $list[] = mb_convert_encoding(intval($row['uid']), 'iso-8859-1'); My best bet as for now: It isn't implode there's the problem, but the length of the string -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

_________________________________________________________________ More than messages–check out the rest of the Windows Live™. http://www.microsoft.com/windows/windowslive/

As stated before, packet size not the problem, data is delivered perfectly from MySQL. Problem seems to be when the result string is diplayed. I'll try to do a test with a numeric array: $list = array(12300..12800); and see what happens. regards, Toke Andrea Giammarchi skrev:

What about MySQL max_allowed_packet setting? is it bigger than produced string?

To: php-general@lists.php.net Date: Tue, 24 Mar 2009 15:23:20 +0100 From: th@ezl-data.dk Subject: Re: [PHP] Problems with implode Per Jessen skrev:

Andrea Giammarchi wrote:

Dunno why you guys started talk about utf-8 problems, he has a list of ids which should contain only unsigned integers, otherwise I do not get how that query could work with an implode(',', $whatever)

Very good point - maybe the OP has not yet tested his code that far? Is there a possibility that some of the id's are _not_ just plain integers made up of 0-9? /Per

And exatly the reason I tried the following: $list[] = $row['uid']; $list[] = intval($row['uid']); $list[] = mb_convert_encoding($row['uid'], 'iso-8859-1'); $list[] = mb_convert_encoding(intval($row['uid']), 'iso-8859-1'); My best bet as for now: It isn't implode there's the problem, but the length of the string -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

_________________________________________________________________ More than messages–check out the rest of the Windows Live™. http://www.microsoft.com/windows/windowslive/