| 00:14.54 | mgeary | me too |
| 00:45.55 | orsonj | anyone remember the function that parses php code |
| 00:47.35 | fungus | eval? |
| 00:48.35 | orsonj | no, it broke up php code and told you what each part was |
| 00:50.23 | jnbek | i need help... |
| 00:52.47 | jnbek | i have two MySQL tables, in one, well call children, I have 50 results, in the other table, I have 5 single parents, i need to figure out how to get all childern belonging to one parent and send that parent an email about each child's schedule. |
| 00:52.51 | orsonj | ah, the tokenizer (I think) |
| 00:53.38 | orsonj | I'm assuming the child record has the id of the parent |
| 00:53.48 | jnbek | I know I need to use Join, and this is real basic MySQL stuff, but I've never done it |
| 00:54.09 | jnbek | yes, each child record has the id of the parent |
| 00:54.50 | orsonj | http://www.w3schools.com/Sql/sql_join.asp try reading through some of this |
| 00:56.55 | orsonj | Actually, you could probably get a list of the single parents, loop through each parent, selecting the children for that parent. |
| 00:57.15 | jnbek | i forgot to mention, some child records havce the same parent_id and i only want to send one email.... |
| 00:57.36 | orsonj | one email with information on all the different schedules though, correct |
| 00:57.51 | jnbek | yep |
| 00:57.55 | orsonj | brb, diaper duty |
| 00:58.44 | jnbek | k |
| 01:00.55 | *** join/#uphpu wps (n=wps@208.53.47.251) |
| 01:00.55 | *** mode/#UPHPU [+o wps] by ChanServ |
| 01:05.10 | orsonj | ok, back |
| 01:05.37 | orsonj | ~paste |
| 01:05.37 | jbot | well, paste is http://rafb.net/paste/, or see also pb, or http://bin.cakephp.org/ |
| 01:05.59 | jnbek | k, i'm looking at UNION as a possible solution |
| 01:09.32 | orsonj | http://rafb.net/p/KnfdXx10.html |
| 01:09.47 | orsonj | pseudo code for the approach I'd take |
| 01:13.50 | orsonj | select * from parents inner join children on parents.id = children.parent_id |
| 01:14.10 | orsonj | That gives you a list of all the children with their parents name attched to the children |
| 01:14.55 | orsonj | Not the approach I'd take for this example, but that's how you do the join |
| 01:16.18 | orsonj | If you wanted to send a separate email for each child, that would work though. but one email for each parent, I'd use my previous approach. |
| 01:17.41 | jnbek | ok |
| 01:19.22 | jnbek | just for a kick and a giggle, I see how it wouldn't apply here ( At least I think, lol) could one do a UNION with two SELECT statements containing JOINS? |
| 01:19.46 | jnbek | http://www.w3schools.com/sql/sql_union.asp |
| 01:20.08 | orsonj | I'm not familiar with unions, I'll take a look though |
| 01:21.05 | orsonj | ok, I don't see why it wouldn't work |
| 01:21.33 | jnbek | yea, very interesting |
| 01:23.43 | orsonj | I'd expect it wouldn't be very useful with a database that has been properly normalized though |
| 01:25.04 | jnbek | for sure, thanks :) I'm gonna go chew on that for a bit. |
| 01:25.56 | orsonj | no problem |
| 01:35.35 | orsonj | Were you hoping for a query that would return a row for each parent with fields that consolidated the children's info? |
| 01:47.53 | orsonj | SELECT parents.name, parents.email, COUNT(students.id) AS num_children FROM parents JOIN students ON parent.id = students.parent_id GROUP BY parents.name |
| 01:48.31 | orsonj | that gives parents with number of children, but no detailed info on each child |
| 01:48.59 | orsonj | Can't figure out a way to do it with just one select |
| 03:16.50 | *** join/#uphpu carmony (i=JustinCa@c-67-164-249-224.hsd1.ut.comcast.net) |
| 03:16.50 | *** mode/#UPHPU [+v carmony] by ChanServ |
| 03:19.10 | herlo | carmony: so nothing will be possible? |
| 03:23.15 | carmony | lol |
| 03:33.48 | *** join/#uphpu josephscott (n=josephsc@75-169-255-227.slkc.qwest.net) |
| 03:41.52 | *** join/#uphpu carmony (n=justinca@c-67-164-249-224.hsd1.ut.comcast.net) |
| 03:41.52 | *** mode/#UPHPU [+v carmony] by ChanServ |
| 04:00.41 | *** join/#uphpu _carmony (i=JustinCa@c-67-164-249-224.hsd1.ut.comcast.net) |
| 05:24.47 | *** join/#uphpu brasto (n=brasto@66-182-82-217.static.slcl007.digis.net) |
| 05:24.47 | *** mode/#UPHPU [+v brasto] by ChanServ |
| 05:32.49 | *** join/#uphpu brasto (n=brasto@66-182-82-217.static.slcl007.digis.net) |
| 05:32.49 | *** mode/#UPHPU [+v brasto] by ChanServ |
| 06:55.29 | *** join/#uphpu mgeary_ (n=mgeary@69.169.142.45.provo.static.broadweave.net) |
| 06:57.45 | *** mode/#UPHPU [+v mgeary] by ChanServ |
| 09:03.34 | *** part/#uphpu mgeary (n=mgeary@69.169.142.45.provo.static.broadweave.net) |
| 14:13.01 | *** join/#uphpu eggyknap (n=jtolley@jtolley.dsl.xmission.com) |
| 14:14.43 | *** join/#uphpu eggyknap (n=jtolley@jtolley.dsl.xmission.com) |
| 14:41.23 | *** join/#uphpu SunSparc (n=sparky@173.8.91.177) |
| 14:41.48 | *** mode/#UPHPU [+v SunSparc] by ChanServ |
| 14:50.09 | *** join/#uphpu Utah_Dave (n=David@72-166-51-162.dia.static.qwest.net) |
| 14:50.09 | *** mode/#UPHPU [+o Utah_Dave] by ChanServ |
| 15:49.06 | _carmony | morning :) |
| 15:49.43 | Utah_Dave | morning! |
| 15:49.57 | SunSparc | morning |
| 15:50.01 | SunSparc | ~morning |
| 15:50.04 | jbot | Good morning! |
| 15:50.09 | SunSparc | ~monday |
| 15:50.10 | jbot | [monday] when everything breaks for no apparent reason, creating so many problems that it takes you until friday to get back to normal. at which point one more thing breaks that takes you the whole weekend to fix |
| 15:50.18 | SunSparc | ~tuesday |
| 15:50.19 | jbot | Tuesday sucks, because it follows Monday (see monday). |
| 15:50.26 | SunSparc | :) |
| 15:55.23 | *** join/#uphpu josephscott (n=josephsc@75-169-255-227.slkc.qwest.net) |
| 15:59.22 | *** join/#uphpu fungus (n=olsonl@bromine.sosstaffing.com) |
| 15:59.22 | *** mode/#UPHPU [+o fungus] by ChanServ |
| 16:07.46 | _carmony | ugg, I hate bugs :P |
| 16:11.56 | *** join/#uphpu eggyknap (n=jtolley@c-67-171-126-25.hsd1.ut.comcast.net) |
| 16:35.40 | *** join/#uphpu mgeary (n=mgeary@166.70.44.49) |
| 16:35.40 | *** mode/#UPHPU [+v mgeary] by ChanServ |
| 16:36.39 | SunSparc | ~bug _carmony |
| 16:36.48 | mgeary | ~annoy SunSparc |
| 16:36.49 | jbot | ACTION dances around SunSparc, poking whenever possible, tickling or doing whatever necessary to annoy SunSparc to the maximum amount |
| 16:36.56 | _carmony | ~lart SunSparc :P |
| 16:36.56 | jbot | slaps SunSparc :P upside and over the head with one freakishly huge killer whale named hugh |
| 16:37.02 | SunSparc | :) |
| 16:38.48 | *** mode/#UPHPU [+v carmony] by ChanServ |
| 16:48.50 | *** join/#uphpu itimber (n=itimber@c-98-202-102-189.hsd1.ut.comcast.net) |
| 16:48.50 | *** mode/#UPHPU [+v itimber] by ChanServ |
| 16:57.51 | *** join/#uphpu thebigdog (n=thebigdo@70.103.91.98) |
| 16:57.51 | *** mode/#UPHPU [+o thebigdog] by ChanServ |
| 17:01.38 | itimber | sup guys |
| 17:01.45 | DexterTheDragon | word |
| 17:03.56 | carmony | ~lart DexterTheDragon |
| 17:03.56 | jbot | runs at DexterTheDragon with an origami Swiss Army knife, and inflicts a nasty paper cut |
| 17:04.14 | carmony | I'm just in a larting mood today for some reason :P |
| 17:04.22 | DexterTheDragon | ~dhit carmony |
| 17:04.23 | jbot | ACTION manages to land Gentoo Install Time on carmony, freezing him for days |
| 17:04.46 | *** join/#uphpu brasto (n=brasto@66-182-82-217.static.slcl007.digis.net) |
| 17:04.46 | *** mode/#UPHPU [+v brasto] by ChanServ |
| 17:11.22 | mgeary | ~yow |
| 17:59.43 | *** join/#uphpu eggyknap_ (n=jtolley@c-67-171-126-25.hsd1.ut.comcast.net) |
| 18:29.55 | *** join/#uphpu bradym (n=bmitchel@qst4fc.quinstreet.com) |
| 18:29.55 | *** mode/#UPHPU [+v bradym] by ChanServ |
| 18:40.42 | fungus | I think it's cool that wobbly windows is the defacto proof that it works for compiz stuff. |
| 18:41.02 | fungus | Not any of the useful plugins, but wobbly windows. hah. |
| 18:42.30 | tierra | that's typically the first plugin I turn off when I get compiz installed and runnning |
| 18:44.27 | fungus | I don't disable it, but I thing the "Scale" plugin is by far the most important. |
| 18:46.14 | brasto | fungus: what does the scale plugin do? |
| 18:46.31 | fungus | imitates Expose from the Mac |
| 18:46.56 | brasto | ah, where you point to a corner or edge of the screen and something happens? |
| 18:47.22 | fungus | no, where all the windows on your computer resize to show you all of them at once. |
| 18:47.33 | carmony | whew, hit revision 9000 with Dating DNA :) |
| 18:47.34 | brasto | ah, yea, I like that, too |
| 18:48.50 | brasto | fungus: I was thinking of the corner/edge events because I set top left corner to expose/scale |
| 18:50.15 | fungus | right, I don't like corner events, I seem to bump my mouse too often. |
| 18:50.15 | tierra | which I hate |
| 18:50.15 | tierra | it's completely useless imho |
| 18:50.15 | fungus | That is exactly what I was talking about. |
| 18:50.16 | fungus | I love it. |
| 18:50.16 | carmony | I love having 1 corner event |
| 18:50.16 | fungus | Easy to find misplaced windows. |
| 18:50.35 | tierra | on my mac, I typically have 20+ source files open at the same time though... when scaled, I can't tell which are which without hoving the mouse over each of them one by one |
| 18:50.58 | tierra | I usually end up going back to Finder or the Xcode project tree to find the file again |
| 18:51.24 | fungus | ah, well in that case it could be a problem. |
| 18:51.59 | fungus | I often have 5-10 terminals open at once, but they are color coded by host. |
| 18:52.10 | tierra | guess I should really just be using the Window menu |
| 19:06.15 | *** join/#uphpu carmony_ (n=justinca@c-67-164-249-224.hsd1.ut.comcast.net) |
| 20:08.11 | carmony | ugggg |
| 20:08.15 | carmony | ~lart CakePHP |
| 20:08.15 | jbot | stuffs CakePHP into a shiny new tin can and vacuum seals it |
| 20:08.25 | carmony | ~lart CakePHP |
| 20:08.25 | jbot | takes CakePHP to the vet for a "special" visit |
| 20:08.38 | carmony | ;) |
| 20:26.51 | mgeary | that good, eh? |
| 20:27.52 | jsmith | carmony: What did CakePHP do to you? |
| 20:29.07 | mindjuju | dag nab utah county! |
| 20:29.36 | mgeary | ?? |
| 20:29.53 | carmony | I'm just supose to use CakePHP for a project, and it seems like their "Book" isn't detailed ebough, and the "API Docs" aren't detailed in the right ways :P |
| 20:30.00 | mindjuju | have 1 rsvp for geek lunch |
| 20:30.06 | mindjuju | i should pull the plug on it |
| 20:30.22 | tierra | heh, this is why you haven't had one in Orem for some time ;) |
| 20:30.27 | *** join/#uphpu Lone_Wanderer (n=chatzill@c-24-10-162-205.hsd1.ut.comcast.net) |
| 20:30.27 | *** mode/#UPHPU [+v Lone_Wanderer] by ChanServ |
| 20:30.40 | Lone_Wanderer | Ahoy. |
| 20:30.42 | mindjuju | well, last one did pretty well, we had like 30 people there |
| 20:30.48 | mindjuju | sup lone_wanderer |
| 20:30.50 | Lone_Wanderer | at the last geek lunch? |
| 20:31.01 | mindjuju | at the last geek lunch in utah county |
| 20:31.08 | Lone_Wanderer | ahh, cool. I'm going to be at this one. |
| 20:31.17 | tierra | +2 now? |
| 20:31.18 | tierra | heh |
| 20:31.29 | mindjuju | at the highest attended geek lunch, it was like 35 ~ 40 at Rodizo Grill |
| 20:31.42 | mindjuju | that was some fun time |
| 20:31.43 | Lone_Wanderer | All PHP geeks, or do we get a good mix? |
| 20:31.43 | mgeary | hey that Brick Oven one we had was well attended |
| 20:31.54 | Lone_Wanderer | The Brick Oven is owned and operated by Satan. |
| 20:31.59 | Lone_Wanderer | (Just, you know. FYI.) |
| 20:32.03 | mindjuju | mgeary, that's the one that was between 20 ~ 25 |
| 20:32.06 | mindjuju | that one did well |
| 20:32.16 | Lone_Wanderer | (I used to work there.) |
| 20:32.29 | mindjuju | Lone_Wanderer, are you in town? |
| 20:32.30 | mgeary | that was the last utah county geek lunch??! |
| 20:32.38 | Lone_Wanderer | Yeah I'm back in Utah for good, more or less. |
| 20:32.43 | mindjuju | yeah, i said the last one did well |
| 20:32.53 | Lone_Wanderer | Scheduled for deployment in 2011 but who knows if that'll change. |
| 20:33.05 | mindjuju | that's awesome news Lone_Wanderer! |
| 20:33.12 | Lone_Wanderer | Yeah :) |
| 20:33.12 | mgeary | ~find Lone_Wanderer a wife |
| 20:33.16 | Lone_Wanderer | No kidding! |
| 20:33.34 | mindjuju | k, i've got to off for a quick meet, brb |
| 20:37.17 | mgeary | hahaha |
| 20:38.14 | fungus | wow, long delay |
| 20:38.22 | fungus | ~find nmap |
| 20:42.30 | mindjuju | k, meeting canceled |
| 20:43.03 | mindjuju | so yeah, we might need to cancel geek lunch |
| 20:43.24 | mindjuju | Lone_Wanderer - where you at? |
| 20:43.30 | mindjuju | aren't you in the SLC? |
| 20:43.31 | Lone_Wanderer | Orem |
| 20:43.41 | mindjuju | ah |
| 21:01.59 | mgeary | so, Lone_Wanderer, are you a burden to society now? You working? how you spending your time? |
| 21:02.10 | herlo | wait? what happened? |
| 21:02.24 | Lone_Wanderer | I pretty much just live off the government. |
| 21:02.41 | mgeary | so they pay you when you're not active? |
| 21:02.45 | mgeary | i didn't know that |
| 21:02.50 | Lone_Wanderer | Nah I was kidding :p |
| 21:02.56 | mgeary | psh |
| 21:02.56 | Lone_Wanderer | Working full time now. |
| 21:03.02 | Lone_Wanderer | I will be eventually though. |
| 21:03.16 | Lone_Wanderer | When I go to school I'll be getting a check every month just for being a student. How awesome is that? |
| 21:03.51 | mgeary | that's the GI bill, no? |
| 21:04.59 | Lone_Wanderer | GI bill plus a few other things, yeah. |
| 21:05.05 | Lone_Wanderer | ROTC pays pretty well. |
| 21:06.41 | mgeary | cool |
| 21:14.42 | *** join/#uphpu beandog (n=steve@gentoo/developer/beandog) |
| 21:14.42 | *** mode/#UPHPU [+v beandog] by ChanServ |
| 21:17.57 | beandog | I'm Henry the Eighth I am |
| 21:18.09 | Lone_Wanderer | heya beandog |
| 21:18.13 | beandog | hola |
| 21:18.19 | beandog | hows it going man |
| 21:18.45 | mindjuju | wow, a new way to detain robbers - i wonder if they teach it in Karate? http://www.ksl.com/?nid=148&sid=5618996 |
| 21:20.32 | thebigdog | mindjuju, when did they let you out? |
| 21:20.53 | SunSparc | Wow, he better not tell that story in prison, he will get beat up. |
| 21:21.16 | mindjuju | @thebigdog - out? |
| 21:21.39 | Lone_Wanderer | hey man, how's it going? |
| 21:22.07 | thebigdog | hehe |
| 21:22.19 | Lone_Wanderer | Tough chick, that Yvonne Morris. |
| 21:22.33 | beandog | mindjuju, lol |
| 21:22.35 | carmony | LOL |
| 21:22.42 | dataw0lf | what up bro. |
| 21:22.49 | beandog | I wonder if it was atomic |
| 21:22.53 | mindjuju | wait wait, no really, i'm in the market for some cinder blocks |
| 21:22.53 | Lone_Wanderer | Not much. Back in Utah now, coding. You still going to move to SLC? |
| 21:23.01 | dataw0lf | dunno thinking about it. |
| 21:23.06 | beandog | SLC ftw |
| 21:23.11 | Lone_Wanderer | You should. |
| 21:23.20 | Lone_Wanderer | You don't need no stinkin' Reno. |
| 21:23.59 | dataw0lf | true dat |
| 21:28.33 | mindjuju | holy CRAP! Two napoleon dynamites? - http://redeye.chicagotribune.com/red-top10celebtwins-pg,0,7781451.photogallery?index=10 |
| 21:28.58 | mindjuju | i think that invalidates string theory |
| 21:29.38 | beandog | heh |
| 21:40.06 | *** join/#uphpu josephscott (n=josephsc@75-169-255-227.slkc.qwest.net) |
| 21:47.23 | macnewbold | ~zippy |
| 21:48.26 | Lone_Wanderer | crossfit time, later all |
| 21:48.44 | mgeary | ~cookie |
| 21:50.58 | mgeary | psh |
| 21:51.00 | mgeary | ~cookie |
| 21:51.12 | mgeary | that's more like it |
| 22:16.57 | herlo | Utah_Dave: you around? |
| 22:24.14 | mgeary | i like how a "huge" MacBook sale means $70 discount |
| 22:26.01 | thebigdog | i found $100 off somewhere |
| 22:26.07 | thebigdog | that is huge though |
| 22:26.11 | mgeary | yeah |
| 22:26.18 | mgeary | Apple is very tight with their margins |
| 22:26.21 | thebigdog | and for $700 you can get a 2.5 ghz instead of the 2.4 |
| 22:28.37 | mindjuju | macs sux |
| 22:37.18 | josephscott | give into your hate mindjuju, you have no idea the power of the dark side |
| 22:39.14 | mindjuju | oh look, if you buy a mbp, you get a pair of birkenstocks to match the mbp |
| 22:40.36 | dataw0lf | get a LifeBook then. |
| 22:40.53 | *** join/#uphpu bradym (n=bmitchel@qst4fc.quinstreet.com) |
| 22:40.53 | *** mode/#UPHPU [+v bradym] by ChanServ |
| 22:42.18 | mindjuju | that looks pretty cool |
| 22:50.06 | thebigdog | mindjuju, has a hot pink once |
| 22:50.06 | thebigdog | one |
| 22:50.46 | mindjuju | sup, you jealous? |
| 22:51.00 | thebigdog | well..uh...yeah |
| 22:52.51 | mindjuju | http://despair.com/government.html :) |
| 23:35.08 | Utah_Dave | herlo: I'm here now |
| 23:35.58 | Utah_Dave | what's up? |
| 23:35.59 | Utah_Dave | mindjuju: that's awesome |
| 23:55.55 | Utah_Dave | mindjuju: I'm hoping to be there for the Geek Lunch |
| 23:56.02 | Utah_Dave | how many RSVP's does that make? |
| 23:56.09 | mindjuju | 3 |
| 23:56.14 | Utah_Dave | woot! |
| 23:56.21 | mindjuju | you, me and lone_wanderer |
| 23:56.32 | Utah_Dave | sweet |
| 23:56.35 | mindjuju | but in retrospect, i'd do it just as a welcome home for lone_wanderer |
| 23:57.21 | carmony | i |
| 23:57.22 | carmony | hate |
| 23:57.24 | carmony | shoveling |
| 23:57.25 | carmony | snow |
| 23:57.39 | mindjuju | i'll resend out promo for it here tonight and mention it'll also be to welcome back Dan |
| 23:57.46 | mindjuju | carmony, couldn't agree with you more |
| 23:57.51 | mindjuju | that's why i have a snow blower |
| 23:57.52 | Utah_Dave | ok |
| 23:57.57 | carmony | 6 inches of WET snow sucks |
| 23:58.26 | mindjuju | is that up in ogden carmony? |
| 23:58.43 | tierra | we have probably 6 here in bountiful |
| 23:58.52 | mindjuju | yuck |
| 23:58.57 | mindjuju | i wonder how much orem got |
| 23:59.12 | DexterTheDragon | wooooooooooooooooooooo snow |