| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32
Comments:
<0> SELECT *
<0> FROM orders
<0> WHERE attendee_records LIKE '%".$ATTENDEE_ID."|%'
<0> sorry!
<1> chasep_work :)
<1> chasep_work, i guess i have a bit of lag
<2> mindamp: are you using mysql? because mysql didnt start supporting sub queries till pretty recently
<0> yes mysql... but yes, my server does support nested queries...
<0> ATTENDEE_ID being the field from table 1
<3> mindamp: you're probably going to have to use PHP to pull one list from one table, extract the values in to soemthing sane, and then reconstruct the query for the next table.
<0> like exploding the | delimeted fields...
<3> mindamp: another option would be to create a temporary table of values to check for, and then to execute the join on the temp table
<0> and then matching them to the other table field?
<0> ah
<1> jiggster, yes, like etc...
<4> short of listing them all manually, i'm really not sure :\
<3> mindamp: sounds like a legacy database design though, it should be repaired, especially if the tables are, or could get big
<4> perhaps try more of a regex channel?
<1> jiggster, so i have to do like, for instance, "abcdefghijklmnopqrstuvwxyz", "ABCDEFGHIJKLMNOPQRSTUVWXYZ"
<5> !+mre
<6> [MRE] 'Meal, Ready to Eat' used by the military in the field and others during a disaster as they have a long shelf life. But you probably wanted 'MRE - Mastering Regular Expressions' the bible of regex http://www.oreilly.com/catalog/regex2/ Use this online tool for learning/understanding/troubleshooting your RegEx --> http://www.weitz.de/regex-coach/
<1> jiggster, i'll try
<0> but couldn't i really do this... SELECT * FROM table1 WHERE attendee_records = %"SELECT field2 FROM table2%|"... something something im retarded
<0> ?
<3> mindamp: I'm not sure what you're trying to accomplish there
<1> jiggster,you did that one for me the other day
<5> caffinated (subquery)
<4> i'm pretty sure i didnt :P
<3> Jymmm: not from where I'm sitting.
<1> jiggster, i thinh was you
<5> caffinated Ok, a ****ed up, dont have a clue, sub-select. How's that?
<4> hmm
<1> jiggster, or you helped, i'm not sure :)
<3> mindamp: I suppose you could use a regex pattern on a subquery, that would have the same effect as doing an unindexed temp table join
<1> jiggster, and is working great, but in meantime i discovered i need to allow western european chars
<3> mindamp: it will be very, very slow
<5> ASCII RULES!
<4> hm :P
<0> caffinated... i have two tables. one table has a field with a number. the second table has a field with several numbers... 3|4|1|445| etc...
<3> mindamp: i realize that.
<0> i need to display the records from the first table where the field number can be found in the second tables field with the |'s
<1> Jymmm, it sould be... like what language do you sound like? ASCII!
<3> mindamp: thank you for reiterating what we already know.
<0> its a one time operation
<0> to pull bunked orders
<0> well..
<0> could someone point me to the quickest and easiest way to accomplish this?
<7> caffinated: are u a starbuck fan?
<3> hydralisk: what does that have to do with anything?
<1> /me loves expresso from starbuck's
<4> i need to get some tonight
<1> hehehe
<7> word ***ociated
<0> anyways...
<7> i read caffinated and ***ociated that with starbucks
<5> jiggster loves queers <4> i need to get some tonight
<7> coffe?
<7> *espresso
<8> b1n0ry: I am totally hosed up here with what we were talking about here.... Can you ***ist me with an example of what I need.
<5> !+clues
<6> Due to high demand, we are having a clue sale: One for $1, two for $5, three for $10, and our best value yet... Four for $20! While supplies last. Call now, operators are standing by! 1-900-CLUE4$
<4> Jymmm, dont set yourself up to be knocked down, i wont be in your neighborhood tonight
<1> brazilian expresso beens are known worldwide. however, now living in brazil, i notice there are not so many places selling expresso
<0> "SELECT name_first FROM attendees WHERE ATTENDEE_ID = '%{ SELECT attendee_records FROM orders
<0> }%|'"
<5> jiggster: Glad to hear it... I'll be sure to warn all teh free clinics about you too!
<5> mindamp you really need to look at the sql courses
<4> :P
<5> !+sql
<6> [SQL] Structured Query Language - the language for most DB Systems. See http://www.w3schools.com/ http://www.sqlcourse.com/ http://www.onlamp.com/pub/ct/19 and #mysql, #postgresql or #sql
<0> ****ing christ
<0> it has to be one line of code...
<5> mindamp: caffinated already told you what you need, just becasue you dont like the answer doesn't change that fact.
<0> argh
<4> go to the bar more often, one liners never work :P
<0> this blows
<9> $good=bcsub(18446744073709551616, 18446744073709551519, 32); good=0.00000000000000000000000000000000 ? first i just used a regular - trying to subtract those numbers, then i was pointed to use bcmath for exact results, but now still this...what else can i do
<5> mutante dont use php for math.
<5> it's icky!
<4> like Jymmm's morning breath
<0> could someone point me to an example of how to accomplish what i asked?
<0> a link or a scrap
<0> or something?
<5> mindamp I did TWICE!
<5> here's #3...
<5> !+sql
<6> [SQL] Structured Query Language - the language for most DB Systems. See http://www.w3schools.com/ http://www.sqlcourse.com/ http://www.onlamp.com/pub/ct/19 and #mysql, #postgresql or #sql
<0> quit that ****
<0> its obnoxious
<5> mindamp AND.... since it's purely a sql issue, tatke it elsehwere from ##php
<0> its not purely an sql issue...
<4> sure it is
<0> im trying to write it in PHP
<0> ...
<4> it's a query you're asking about
<0> so how is it urely sql
<0> i know how do do a left join..
<5> mindamp I'm not gonna argue about it...
<4> i didnt see an ounce of php in what you were asking for help with
<0> you are...
<0> $sql =
<0> there
<10> when you have function ($foo="bar") { .. } that means that the DEFAULT value of $foo is bar. Thats only if there isnt a $foo provided.
<10> Sorry, its a little basic, I know.
<4> still, it's an sql query you need help with, not the php part
<5> mindamp last chance to drop it from ##php
<4> so go to the right source for the right problem
<0> bleh
<4> er right solution*
<7> ohh ****
<11> *golf
<4> screw that conservative crap, lets throw a party
<7> he got owned
<4> damn
<7> uhh
<0> ...
<7> i take that back
<12> mindamp: Just shut up, and behave.
<0> right
<5> kuja ...
<12> Jymmm: You too.
<11> and use the toliet rather than pissing in ##php
<12> Jymmm: !!
<13> function &test(&$obj_or_array) <- why does the function name have a n & before it?
<10> heh
<12> Jymmm: $5 sookie sookie?
<4> hey kuja, whats new?
<12> jiggster: libajuk, ported to Python... kind of new :)
<0> thats not php
<4> ahh cool stuff man
<0> take it elsewhere
<5> kuja Sure , you cna pay me $5 to have my way with your gf.... she does do windows right? Cause you know I aint gonna touch her after you have!
<12> Jymmm: **** you man... just... **** you :'(
<4> er, whos the woman in your relationship kuja? :P
<4> set an example man, jeez
<14> q: hello, anyone have any idea to solve this error "Notice: unserialize: Error at offset", php version 4.3.4 ?
<5> kuja SPEAK BITCH SPEAK!
<4> hydralisk: now you can say he was pwned
<12> You +q'ing son of a bitch :P
<3> haha
<7> +q'ing?
<3> kuja!
Return to
#php
or
Go to some related
logs:
#css
Python CheesShop
ruby-to-perl
secondlife-bin: error while loading shared libraries
#centos
mepis vimrc etc
49A120FD1135D466
#fedora
ubuntu apcid problem
#oe
|
|