// #php — 2007-07-17
1996
1997
1998
1999
2000
2001
2002
2003
2004
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
00:23:43 Topic Is: Welcome to #PHP | 5.2.3, 4.4.7 released | Read the rules first -> http://unix.org.au/php/ | Looking for a php & python dev for short contract, /msg eyecue
00:23:43 Set By: (MedNez) on: Tue Jun 12 18:13:01 2007
00:24:00 Mode: (by php) +v damian_
00:39:21 Quit: teq ([email protected]) Read error to teq: Connection reset by peer
00:39:21 Quit: freebsd ([email protected]) Write error to freebsd, closing link
00:41:43 <`Stebo> I have two tables, one of them with reference to another. I want to pull only distinct values from first table but also satisfify some conditions from the second table.
00:42:46 <`Stebo> Kinda hard to explain
00:45:20 <`Stebo> An example- Tables: IMAGES | PEOPLE. there multiple images of each person in the images table. I want to pull only one image of each person. I could do it in multiple queries but I want to do it in one query.
00:49:59 Quit: MedNez ([email protected]) Exit: Get MacIrssi - http://www.g1m0.se/macirssi/
01:46:39 <damian_> you can either use a nested statement, or a join
01:46:45 <damian_> i'm sure there's other ways, but those are the more common
01:47:08 <damian_> eg.
01:47:47 <damian_> SELECT people.firstname, images.imageid, images.imagename FROM images, people WHERE (people.personid = images.personid);
01:47:50 <damian_> or something along those lines
02:23:50 Quit: php ([email protected]) Ping timeout for php
02:24:07 Quit: brett_ ([email protected]) Read error to brett_: Connection reset by peer
02:24:14 Join: brett_ ([email protected]) to #php
02:24:17 Mode: (by ChanOP) +o brett_
02:25:02 Join: php ([email protected]) to #php
02:25:06 Mode: (by ChanOP) +o php
02:33:42 Join: teq ([email protected]) to #php
02:33:45 Join: freebsd ([email protected]) to #php
02:33:50 Mode: (by ChanOP) +o freebsd
02:34:41 Join: robert_ ([email protected]) to #php
02:35:12 Mode: (by php) +v robert_
02:36:34 Nick: robert_ is now known as robert_1
02:51:19 Nick: robert_1 is now known as robert_
05:07:19 <`Stebo> thanks for the help, night.
05:07:22 Quit: `Stebo ([email protected]) Exit:
08:16:56 Join: XIO ([email protected]) to #php
08:17:13 Quit: Reprobait ([email protected]) Ping timeout for Reprobait
09:04:11 <brett_> sup
09:32:37 Quit: XIO ([email protected]) Read error to XIO: Connection reset by peer
11:07:29 Quit: Carson ([email protected]) Ping timeout for Carson
11:08:08 Join: Carson ([email protected]) to #php
11:08:34 Mode: (by php) +v Carson
12:50:21 Join: Loserbait ([email protected]) to #php
12:53:43 Join: Reprobait ([email protected]) to #php
12:54:44 Quit: Reprobait ([email protected]) Exit: Leaving
12:57:21 Quit: Loserbait ([email protected]) Ping timeout for Loserbait
13:17:49 Join: Loserbait ([email protected]) to #php
13:37:21 Quit: fildo ([email protected]) Ping timeout for fildo
15:43:54 Quit: Loserbait ([email protected]) Ping timeout for Loserbait
15:50:56 Join: Loserbait ([email protected]) to #php
16:11:27 Quit: Loserbait ([email protected]) Ping timeout for Loserbait
16:12:12 Join: Loserbait ([email protected]) to #php
18:28:30 Join: keenly ([email protected]) to #PHP
18:40:10 Join: rofo ([email protected]) to #php
18:40:13 Mode: (by ChanOP) +o rofo
18:40:39 Mode: (by php) +v rofo
19:37:02 Join: isdf ([email protected]) to #php
19:37:11 Mode: (by php) +v isdf
19:41:46 Join: MedNez ([email protected]) to #php
19:41:49 Mode: (by ChanOP) +o MedNez
20:10:09 Join: eyecue ([email protected]) to #PHP
20:10:37 Quit: EyeCue1 ([email protected]) Ping timeout for EyeCue1
20:12:09 Nick: eyecue is now known as EyeCue1
20:17:47 Join: drexen ([email protected]) to #php
20:17:51 Mode: (by ChanOP) +v drexen
21:04:57 <drexen> grouphug
21:04:58 <php> <drexen> Okay, here's the whole story on this... I've been friends with a buddy of mine for like a few years now, over time I've met some of his friends, etc. Me and one of his pals have become pretty tight over the last year or so, and the mutual friend that introduced us became a big spaz. So, in a funny bit of happenings, we stopped hanging out with him. I just feel kinda bad because I stole his friend. But he deserved it, cuz he's a spaz. (297578103
21:04:58 <php> )
21:05:25 <drexen> spazzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz
21:05:31 * drexen has a headacheeeeeeeeeeeeeeeeeeeeeeeeeeee
21:10:10 <+rofo> FLCL?
21:10:19 <+rofo> try smacking your head on the desk
21:15:23 <MedNez> grouphug desk
21:15:24 <php> <MedNez> When I was in fifth grade, I sucked up to my teacher a lot. She was really hot. I would go up to her desk and ask her questions and while she explained something to me, I would look down her shirt. I think she knew but I regret it now. (532109471)
21:16:41 <MedNez> grouphug desk
21:16:41 <php> <MedNez> I didn't go talk to the night desk guy Saturday night, and I feel guilty. I can't stay up on weekdays, so now I can't see him for the rest of the week. (861292127)
21:18:42 <+rofo> grouphug jesus
21:18:43 <php> <rofo> Christmas night me and my friend stole my neighbors big neon light that said jesus. I realized that the people had made the sign themselves, very personalized. Its hanging up in my room. I dont feel bad about it, but that doesnt mean i cant confess it. (987978026)
21:18:56 <+rofo> grouphug jesus
21:18:56 <php> <rofo> we used to steal baby jesus from all the xmas decorations...so just to let you know if your lookin for him he is in my closet at home.... (943259009)
21:19:05 <+rofo> grouphug jesus
21:19:06 <php> <rofo> my best friend looks like jesus, i wanna fuck him. (359669951)
21:19:09 <+rofo> grouphug jesus
21:19:10 <php> <rofo> my girlfriend and i were together for almost 4 years. we broke up once at the beginning of college. i fooled around with another girl while we were broken up and she never found out. now we have broken up again but my girlfriend still comes over to sleep with me 2 or 3 times a week..... the worst part is, two weeks ago i was buying shoes and the girl i fooled around with was working the counter, so i quickly hurried out of the store. i got home o
21:19:10 <php> nly to realize the shoes were one size too big, so i made my ex-girlfriend go to the store and exchange them for the right size while talking to the girl i fooled around with, and she never knew the better.... also i broke up with her this summer of the telephone, while in another country to fool around with another girl, but now that we are back in the states, the girl found jesus again, and will have nothing to do with me (170567084)
21:19:56 <+rofo> good times for jesus
21:23:19 <drexen> lol
21:26:56 <+rofo> sup drexen?
21:27:12 <drexen> tired as a mofo
21:37:45 <+rofo> I've been so busy working I forgot about Eve and remembered IRC as a result
22:05:31 Quit: drexen ([email protected]) Exit: testing 1, 2, 3. can you hear me? is this thing on?
23:19:25 Quit: keenly ([email protected]) Exit: Teeny Little Super Guy, Pops right up before your eye. mIRC is just a multi-player notepad
Search this day's buffer: