Life is a life... We are the humans...
тока что в ирке)
читать дальше
[23:42] You have joined #php
[23:42] The topic is 'PHP 5.2.1 && PHP 4.4.6 | PHP Manual: php.net/manual/ru/ | Код помещаем на http://pastebin.ru, за любым копипастом в канал следует бан | Статусы в никах, флуд и автореджойн не одобряются администрацией | садист ищет мазахиста для приятного времяпровождения' (set by leonid_p)
[23:42] ChanServ enables 'Voice' status for MrXaK
[23:47] leonid_p has joined
[23:47] ChanServ enables 'Voice' status for leonid_p
[23:47] nnmcc_нету is now known as никагонед
[00:01] ShadowL|ght: i'm having an error when trying to insert data in a db but i can't figure out what's wrong
[00:01] ShadowL|ght: http://www.pastebin.ca/417300
[00:01] ShadowL|ght: if somebody would be kind to lookup my code
[00:02] leonid_p: woow
[00:02] leonid_p: ShadowL|ght , where are you from ?
[00:02] ShadowL|ght: canada
[00:02] ShadowL|ght: why ?
[00:02] leonid_p: english speaking people on this channel.. is very rare -)
[00:02] MrXaK: Do you have any error messages?
[00:02] ShadowL|ght: ho really?
[00:03] leonid_p: yes, really
because it's rusnet
[00:03] leonid_p: it's russian speaking channel.. how you get here ?
[00:03] ShadowL|ght: mrxak yep it says an error about bad argument for the join function inside my sql query
[00:03] ShadowL|ght: maybe get kick for my next copy paste heheh
[00:03] ShadowL|ght: This code generate the following output :
[00:03] ShadowL|ght: 208.65.60.77,mtl.a46.018,paul,mcsherry,paul mcsherry,366 charleston drive,,dundee,NA,dd2 4bd,GB,01382 610540,[email protected]
[00:03] ShadowL|ght: and the following error when i try to insert this info in the db:
[00:03] ShadowL|ght: 1136: Column count doesn't match value count at row 1
[00:03] ShadowL|ght: survived
[00:04] ShadowL|ght: Warning: join(): Bad arguments. in /home/Admin/SyrsA2/test/mysql_db.php on line 111
[00:04] leonid_p: ShadowL|ght , don't flood here plz
[00:05] ShadowL|ght: sorry leonid_p
[00:05] leonid_p: anyway, you didn't define $data_db anywhere
[00:05] cerr has disconnected: "Leaving"
[00:05] leonid_p: and don't pass this variable as parameter
[00:05] ShadowL|ght: i thought it would be useless to create a pastebin for that output.
[00:05] ShadowL|ght: in the while
[00:05] ShadowL|ght: while loop
[00:05] MrXaK: That means that you DB structure is not same as you SQL-request
[00:05] leonid_p: yes but this loop is after query..
[00:06] leonid_p: look at line 45
[00:06] ShadowL|ght: ok
[00:06] MrXaK: Try to check all columns in you DB table
[00:06] ShadowL|ght: i should put my query inside the loop than?
[00:06] MrXaK: and columns in sql-request
[00:06] Elemental: http://udaff.com/image/407/40781.jpg
[00:06] Крейт has disconnected: "Goodbye, cruel world!"
[00:06] ShadowL|ght: mrxak i compare the output of the data_db content with my db structure and they are the same
[00:06] _злое_бу_: вот вас пучит...
[00:06] leonid_p: ShadowL|ght yes
[00:06] ShadowL|ght: ok i'll try that leonid_p
[00:07] carnal`desires has joined
[00:07] ChanServ enables 'Voice' status for carnal`desires
[00:07] leonid_p: ok -)
[00:07] ShadowL|ght: damn that mean i'll do a query 300 times
[00:07] ShadowL|ght: is there a way to do the same result but without having my query in the while?
[00:07] MrXaK: You have this error on creating tables or when you select data?
[00:07] ShadowL|ght: when inserting MrXaK
[00:07] leonid_p: ShadowL|ght of course
[00:07] ShadowL|ght: do you have an example how i could proceed?
[00:08] leonid_p: you can use INSERT IGNORE... SELECT syntax
[00:08] leonid_p: and what you want with just one query
[00:08] leonid_p: *do what you want
[00:08] MrXaK: Try to execute this code in PHPMyAdmin or in mysql command line
[00:08] MrXaK: блин) давно с иностранцами не общался0
[00:09] leonid_p: INSERT IGNORE INTO table (field1, field2) SELECT fieldX,fieldY from table2
[00:09] leonid_p: like this -)
[00:09] ShadowL|ght: hoooo
[00:09] ShadowL|ght:

[00:09] ShadowL|ght: second MrXaK think i found a way to get away my while loop and that could fix my error
[00:10] ShadowL|ght: hehehe thanks leonid_p think that will be the best way to do it
[00:10] leonid_p:
[00:10] MrXaK: )
[00:10] _злое_бу_:
[00:11] ShadowL|ght: leonid_p with this syntax, is value replaced by select ?
[00:12] Xor has joined
[00:12] ChanServ enables 'Voice' status for Xor
[00:13] ShadowL|ght: ho my god, it works

[00:13] ShadowL|ght give a tons of beer to leonid_p
[00:13] leonid_p give a tons of beer to ShadowL|ght
[00:13] MrXaK: =)
[00:13] leonid_p: no, but you can delete all records in table first..
[00:13] MrXaK: дайте мне тонну пива)
[00:13] leonid_p: or.. probably.. use replace into instead of insert into =_
[00:13] ShadowL|ght: mm sound good
[00:14] leonid_p: heh , ShadowL|ght , budweiser plz
[00:14] leonid_p: ShadowL|ght , so how do you get here ?
[00:14] leonid_p: why not undernet/efnet ?
[00:14] leonid_p: but rusnet?
[00:14] ShadowL|ght: bud really? you do not prefer boreal or leffe ?
[00:15] ShadowL|ght: php.net support link
[00:15] MrXaK: фигасе)
[00:15] leonid_p: well never tried them -) but bud is really good
[00:15] leonid_p: ShadowL|ght really ? where ?
[00:15] ShadowL|ght: undernet are snog and higher mind kind. Corrupted by the evil internet power
[00:15] leonid_p: heh -)) not really..
[00:15] ShadowL|ght: when you click on support in php.net you have a link for direct help (instanteanous) and in the list they have a link for here
[00:16] leonid_p: ShadowL|ght hmm i don't see support link in php.net ..
[00:16] leonid_p: on main page at least
[00:16] ShadowL|ght: getting support
[00:16] ShadowL|ght: in the small menu on top
[00:16] ShadowL|ght: Instant Resource Center
[00:16] ShadowL|ght: Otherwise known as IRC or Internet Relay Chat. Here you can usually find experienced PHP people sitting around doing nothing on various channels with php in their names. Note that there is no official IRC channel. Check OFTC or any other major network (EFNet, IRCNet, QuakeNet, DALNet and freenode).
[00:17] DVSNetKiller has disconnected: Connection reset by peer
[00:18] leonid_p: hmm yet but there is link to rusnet?
[00:18] leonid_p: i don't see it...
[00:18] leonid_p: кто нить видит там линк на руснет ?
[00:18] leonid_p: yet = yes
[00:19] DVSNetKiller has joined
[00:19] ChanServ enables 'Voice' status for DVSNetKiller
[00:19] MrXaK: хз) но наверное где-то есть)
[00:19] MrXaK: раз чел зашёл
[00:22] Pretender: блин.. полчаса читал и тока щас вдуплил что на инглише
[00:22] Pretender: пора отдыхать от работы
[00:22] MrXaK: ыы)
[00:23] leonid_p: ггг
[00:23] leonid_p: ShadowL|ght , hellooo
[00:23] leonid_p: нету там на руснет
[00:23] leonid_p: ссылок
[00:23] ShadowL|ght: wha i can't decode the character you are using
[00:23] leonid_p:
because it's russian ..
[00:24] leonid_p: it's cyrillic
[00:24] leonid_p: so where do you find link to this channel ?
)) i can't find on php.net site..
читать дальше
[23:42] You have joined #php
[23:42] The topic is 'PHP 5.2.1 && PHP 4.4.6 | PHP Manual: php.net/manual/ru/ | Код помещаем на http://pastebin.ru, за любым копипастом в канал следует бан | Статусы в никах, флуд и автореджойн не одобряются администрацией | садист ищет мазахиста для приятного времяпровождения' (set by leonid_p)
[23:42] ChanServ enables 'Voice' status for MrXaK
[23:47] leonid_p has joined
[23:47] ChanServ enables 'Voice' status for leonid_p
[23:47] nnmcc_нету is now known as никагонед
[00:01] ShadowL|ght: i'm having an error when trying to insert data in a db but i can't figure out what's wrong
[00:01] ShadowL|ght: http://www.pastebin.ca/417300
[00:01] ShadowL|ght: if somebody would be kind to lookup my code
[00:02] leonid_p: woow
[00:02] leonid_p: ShadowL|ght , where are you from ?
[00:02] ShadowL|ght: canada
[00:02] ShadowL|ght: why ?
[00:02] leonid_p: english speaking people on this channel.. is very rare -)
[00:02] MrXaK: Do you have any error messages?
[00:02] ShadowL|ght: ho really?
[00:03] leonid_p: yes, really

[00:03] leonid_p: it's russian speaking channel.. how you get here ?
[00:03] ShadowL|ght: mrxak yep it says an error about bad argument for the join function inside my sql query
[00:03] ShadowL|ght: maybe get kick for my next copy paste heheh
[00:03] ShadowL|ght: This code generate the following output :
[00:03] ShadowL|ght: 208.65.60.77,mtl.a46.018,paul,mcsherry,paul mcsherry,366 charleston drive,,dundee,NA,dd2 4bd,GB,01382 610540,[email protected]
[00:03] ShadowL|ght: and the following error when i try to insert this info in the db:
[00:03] ShadowL|ght: 1136: Column count doesn't match value count at row 1
[00:03] ShadowL|ght: survived
[00:04] ShadowL|ght: Warning: join(): Bad arguments. in /home/Admin/SyrsA2/test/mysql_db.php on line 111
[00:04] leonid_p: ShadowL|ght , don't flood here plz
[00:05] ShadowL|ght: sorry leonid_p
[00:05] leonid_p: anyway, you didn't define $data_db anywhere
[00:05] cerr has disconnected: "Leaving"
[00:05] leonid_p: and don't pass this variable as parameter
[00:05] ShadowL|ght: i thought it would be useless to create a pastebin for that output.
[00:05] ShadowL|ght: in the while
[00:05] ShadowL|ght: while loop
[00:05] MrXaK: That means that you DB structure is not same as you SQL-request
[00:05] leonid_p: yes but this loop is after query..
[00:06] leonid_p: look at line 45
[00:06] ShadowL|ght: ok
[00:06] MrXaK: Try to check all columns in you DB table
[00:06] ShadowL|ght: i should put my query inside the loop than?
[00:06] MrXaK: and columns in sql-request
[00:06] Elemental: http://udaff.com/image/407/40781.jpg
[00:06] Крейт has disconnected: "Goodbye, cruel world!"
[00:06] ShadowL|ght: mrxak i compare the output of the data_db content with my db structure and they are the same
[00:06] _злое_бу_: вот вас пучит...
[00:06] leonid_p: ShadowL|ght yes
[00:06] ShadowL|ght: ok i'll try that leonid_p
[00:07] carnal`desires has joined
[00:07] ChanServ enables 'Voice' status for carnal`desires
[00:07] leonid_p: ok -)
[00:07] ShadowL|ght: damn that mean i'll do a query 300 times
[00:07] ShadowL|ght: is there a way to do the same result but without having my query in the while?
[00:07] MrXaK: You have this error on creating tables or when you select data?
[00:07] ShadowL|ght: when inserting MrXaK
[00:07] leonid_p: ShadowL|ght of course
[00:07] ShadowL|ght: do you have an example how i could proceed?
[00:08] leonid_p: you can use INSERT IGNORE... SELECT syntax
[00:08] leonid_p: and what you want with just one query
[00:08] leonid_p: *do what you want
[00:08] MrXaK: Try to execute this code in PHPMyAdmin or in mysql command line
[00:08] MrXaK: блин) давно с иностранцами не общался0
[00:09] leonid_p: INSERT IGNORE INTO table (field1, field2) SELECT fieldX,fieldY from table2
[00:09] leonid_p: like this -)
[00:09] ShadowL|ght: hoooo
[00:09] ShadowL|ght:


[00:09] ShadowL|ght: second MrXaK think i found a way to get away my while loop and that could fix my error
[00:10] ShadowL|ght: hehehe thanks leonid_p think that will be the best way to do it

[00:10] leonid_p:

[00:10] MrXaK: )
[00:10] _злое_бу_:

[00:11] ShadowL|ght: leonid_p with this syntax, is value replaced by select ?
[00:12] Xor has joined
[00:12] ChanServ enables 'Voice' status for Xor
[00:13] ShadowL|ght: ho my god, it works


[00:13] ShadowL|ght give a tons of beer to leonid_p
[00:13] leonid_p give a tons of beer to ShadowL|ght
[00:13] MrXaK: =)
[00:13] leonid_p: no, but you can delete all records in table first..
[00:13] MrXaK: дайте мне тонну пива)
[00:13] leonid_p: or.. probably.. use replace into instead of insert into =_
[00:13] ShadowL|ght: mm sound good
[00:14] leonid_p: heh , ShadowL|ght , budweiser plz

[00:14] leonid_p: ShadowL|ght , so how do you get here ?

[00:14] leonid_p: why not undernet/efnet ?
[00:14] leonid_p: but rusnet?

[00:14] ShadowL|ght: bud really? you do not prefer boreal or leffe ?
[00:15] ShadowL|ght: php.net support link

[00:15] MrXaK: фигасе)
[00:15] leonid_p: well never tried them -) but bud is really good
[00:15] leonid_p: ShadowL|ght really ? where ?
[00:15] ShadowL|ght: undernet are snog and higher mind kind. Corrupted by the evil internet power
[00:15] leonid_p: heh -)) not really..
[00:15] ShadowL|ght: when you click on support in php.net you have a link for direct help (instanteanous) and in the list they have a link for here
[00:16] leonid_p: ShadowL|ght hmm i don't see support link in php.net ..
[00:16] leonid_p: on main page at least
[00:16] ShadowL|ght: getting support
[00:16] ShadowL|ght: in the small menu on top
[00:16] ShadowL|ght: Instant Resource Center
[00:16] ShadowL|ght: Otherwise known as IRC or Internet Relay Chat. Here you can usually find experienced PHP people sitting around doing nothing on various channels with php in their names. Note that there is no official IRC channel. Check OFTC or any other major network (EFNet, IRCNet, QuakeNet, DALNet and freenode).
[00:17] DVSNetKiller has disconnected: Connection reset by peer
[00:18] leonid_p: hmm yet but there is link to rusnet?

[00:18] leonid_p: i don't see it...
[00:18] leonid_p: кто нить видит там линк на руснет ?
[00:18] leonid_p: yet = yes
[00:19] DVSNetKiller has joined
[00:19] ChanServ enables 'Voice' status for DVSNetKiller
[00:19] MrXaK: хз) но наверное где-то есть)
[00:19] MrXaK: раз чел зашёл
[00:22] Pretender: блин.. полчаса читал и тока щас вдуплил что на инглише
[00:22] Pretender: пора отдыхать от работы
[00:22] MrXaK: ыы)
[00:23] leonid_p: ггг
[00:23] leonid_p: ShadowL|ght , hellooo

[00:23] leonid_p: нету там на руснет
[00:23] leonid_p: ссылок
[00:23] ShadowL|ght: wha i can't decode the character you are using
[00:23] leonid_p:

[00:24] leonid_p: it's cyrillic
[00:24] leonid_p: so where do you find link to this channel ?
