| Autor | Zpráva | ||
|---|---|---|---|
| tre-ska Profil * |
#1 · Zasláno: 17. 10. 2011, 14:16:40
dobry den,
Mam SQL dotaz GROUP_CONCAT(odkazy.link ORDER BY odkazy.datetime DESC) AS link1, A potom si to rozkuskujem do pola $link = Explode (",", $data['link1']);no a problem je to ze v premennej $data['link1'] Chcem sa spytat ci je niekde obmedzena dlzka premennej alebo sa to da nejako elegantnejsie vyriesit. dakujem za odpovet |
||
| DJ Miky Profil |
#2 · Zasláno: 17. 10. 2011, 15:15:13
v PHP to omezené není, ale v MySQL ano:
http://dev.mysql.com/doc/refman/5.1/en/group-by-functions.html#function_group-concat The result is truncated to the maximum length that is given by the group_concat_max_len system variable, which has a default value of 1024. The value can be set higher, although the effective maximum length of the return value is constrained by the value of max_allowed_packet. |
||
| tre-ska Profil * |
#3 · Zasláno: 17. 10. 2011, 15:28:51
uz som nasiel problem
lilmitoval to "GROUP_CONCAT" mysql_query("SET group_concat_max_len = 4096"); |
||
|
Časová prodleva: 14 let
|
|||
0