| |
| |
| |
|
Page: 1 2 3 4
Comments:
<0> hello!
<1> hi
<0> somebody can help me
<1> try a shrink
<2> heh, just ask
<0> i have "select * from PP where AA='$TT'"
<0> $tt is a php variable
<1> ..... very slowly
<1> deep breath..
<0> can put $TT="*" by display all register (or something)
<0> sory . but my inglish not is good
<2> Elfo, if it's a php question, it should be asked on #php
<1> actually I think it is a SQL question
<1> he just have no idea what he is asking
<1> Elfo: http://www.kfwebs.net/links/6 for SQL
<1> learn SQL..
<0> no beedum . is a sql question. nevermind php
<1> you might want to concider the LIKE operator
<0> i need displayed all register with a WHERE AA=
<1> so why have a WHERE clause in the first place..
<0> but i cant use LIKE
<2> ah, i see
<2> yes, like would probably be what you need
<1> so it is a mixture of PHP logic to construct the SQL query, or utilizing SQL's abilities
<1> why can't you use LIKE?
<0> ok, i try with like. thanks anywhere
<0> K_F LIKE in my sql is very slowly
<1> so construct the query properly
<2> you can also use the % wildcard
<1> as in no WHERE clase
<1> beebum: only when using the LIKE operator and not =
<1> :)
<2> ah
<0> ok i try. thanks to booth
<2> AA is a set number of characters?
<1> Elfo:what you should do is to not have a where clause at all
<0> AA is a field of a table
<1> Elfo: construct the query properly in PHP
<1> everything else is just a workaround
<0> ok
<2> Elfo, just so you know, K_F can program circles arround most people when it comes to mysql. listen to his advice. ;)
<0> beebum i dont understan you very well
<2> i'm saying that K_F knows mysql very well. he gives very good answers
<2> if you are trying to do something a bad way, he will tell you the right way
<0> ohhh . i understand... yes. k_f is good
<0> ok beebum thanks for your comments
<2> your welcome
<1> thank you for the kind words, beebum :)
<1> anyways, good night.
<2> later K_F
<3> hi all
<3> im looking for a little bit of help to setup an exchange book system
<3> got a bit of problems with mysql
<4> hahaha
<4> i didnt touch anything!
<4> LOL
<5> Hello, I have a table containing numeric values (in a column named 'value') how I can retrieve the total of the values (addition) with a SELECT query?
<6> BEER!
<7> i cannot find my mysql config file! help!
<8> put out an amber alert
<7> i need to connect from an ip, i dont have a config file, how?
<7> ...
<7> hi i created a database with mysqlcc and i added a table..
<7> now wheni modify the table it says geekbsd.1 database does not exist
<7> error 1146
<7> [Webserver] ERROR 1146: Table 'mysql.1' doesn't exist
<7> i get it for that too
<7> is anyone here?
<9> salut
<10> salut
<1> heya Abaris
<1> ... and oceanBlue
<10> heya kristian
<9> hi K_F
<9> you know what happened here with lanshark?
<1> nothing really
<1> you'll just find him in #asp more often than in here
<1> and no, he isn't on this exact moment :)
<9> he's like 16 or something? :P
<1> whom? lanshark?
<9> yup
<1> hehe, not at all
<10> well i have no clue but he`s acting like thet
<9> yeah. he did a no no :)
<10> that*
<1> hmm
<1> Abaris: <-- LanShark has quit (Read error: Connection reset by peer) (at 0908 in this channel)
<1> utc+1
<9> nevermind... :)
<9> figured out initrd. thanks for the help.
<1> nice
<1> is http://www.sqlwhores.com down?
<1> rephrase, can anyone give me the IP of sqlwhores.com ?
<10> Dns resolved sqlwhores.com to 72.29.74.23
<1> there, notified the owner of the DNS servers..
<1> danke
<9> i can reach it.
<10> it was up arownd 3 am this morning
<1> now I just have to remember the p***word
<1> [kristianf@localhost xchatlogs]$ dig @ns1.veraperez.net sqlwhores.com
<1> dig: couldn't get address for 'ns1.veraperez.net': not found
<1> [kristianf@localhost xchatlogs]$ whois sqlwhores.com | grep -i "name server"
<1> Name Server: NS1.VERAPEREZ.NET
<1> Name Server: NS2.VERAPEREZ.NET
<1> Abaris: you're probably only using a cached IP
<1> ... in your DNS server..
<10> root@warewolf:~# dig @ns1.veraperez.net sqlwhores.com
<10> ; <<>> DiG 9.3.1 <<>> @ns1.veraperez.net sqlwhores.com
<10> ; (1 server found)
<10> ;; global options: printcmd
<10> ;; Got answer:
<10> ;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 17072
<10> ;; flags: qr aa rd ra; QUERY: 1, ANSWER: 1, AUTHORITY: 2, ADDITIONAL: 2
<9> possibly
<10> ;; QUESTION SECTION:
<10> ;sqlwhores.com. IN A
<10> ;; ANSWER SECTION:
<10> sqlwhores.com. 14400 IN A 72.29.74.23
<10> ;; AUTHORITY SECTION:
<10> sqlwhores.com. 14400 IN NS ns515.dizinc.com.
<10> sqlwhores.com. 14400 IN NS ns514.dizinc.com.
<10> ;; ADDITIONAL SECTION:
<10> ns514.dizinc.com. 14957 IN A 72.29.74.24
<10> ns515.dizinc.com. 51911 IN A 72.29.74.25
<10> ;; Query time: 478 msec
<10> ;; SERVER: 72.29.74.24#53(72.29.74.24)
<10> ;; WHEN: Thu Feb 9 06:17:31 2006
<10> ;; MSG SIZE rcvd: 126
<1> hmm
<1> okay, so something is fubar on my end
<11> hi abaris
<1> grazzy: http://digg.com/linux_unix/Microsoft_Vs._Linux:_Get_the_facts_-_The_real_ones
<1> bah, where is...
<1> he'll come back
<9> his linux crashes >:)
<2> wow, glad that's over. i was floating in the darkness of cyberspace between servers and i heard a screem. then the lights came back on and here i was with you guys. ;D
<1> hehe
<1> how are you beebum ?
<1> someone put my article on digg :) http://digg.com/linux_unix/Microsoft_Vs._Linux:_Get_the_facts_-_The_real_ones
<2> catching up. how are you?
<2> yes, i saw that. cool
<1> reading Current Management Accounting
<2> well, when you get done come over here and straiten out my company
<2> you can also be the IT guy since we don't currently have one
<1> hehe
Return to
#mysql
or
Go to some related
logs:
blah bleh proxy
shady hajja
pt messenger
#linux
foto verga
gn0mez
#linuxhelp
#windows
sourcefire is5800
#linuxhelp
|
|