| 00:11.32 | mindjuju | anybody around? |
| 00:37.18 | mgeary | yeah |
| 00:37.27 | mgeary | what's up, mindjuju |
| 01:04.02 | *** join/#uphpu _psychic_ (n=_psychic@raisinbread.fttp.xmission.com) |
| 01:04.02 | *** mode/#UPHPU [+v _psychic_] by ChanServ |
| 01:39.03 | *** join/#uphpu Utah_Dave (n=David@c-67-172-225-101.hsd1.ut.comcast.net) |
| 01:39.03 | *** mode/#UPHPU [+o Utah_Dave] by ChanServ |
| 01:56.45 | *** join/#uphpu beandog (n=sdibb@gentoo/developer/beandog) |
| 01:56.45 | *** mode/#UPHPU [+v beandog] by ChanServ |
| 03:22.08 | *** join/#uphpu beandog (n=sdibb@gentoo/developer/beandog) |
| 03:22.08 | *** mode/#UPHPU [+v beandog] by ChanServ |
| 03:22.38 | beandog | any good movies out? |
| 03:28.02 | beandog | anyone awake? :) |
| 03:29.28 | *** join/#uphpu Lone_Wanderer (n=Dan@c-67-169-246-153.hsd1.ut.comcast.net) |
| 03:29.28 | *** mode/#UPHPU [+v Lone_Wanderer] by ChanServ |
| 03:29.32 | beandog | ey Lone_Wanderer |
| 03:29.48 | *** part/#uphpu Lone_Wanderer (n=Dan@c-67-169-246-153.hsd1.ut.comcast.net) |
| 03:29.52 | beandog | maybe I should just go to bed |
| 04:35.16 | *** join/#uphpu eggyknap (n=jtolley@c-67-182-227-82.hsd1.ut.comcast.net) |
| 04:35.16 | *** mode/#UPHPU [+v eggyknap] by ChanServ |
| 04:35.16 | *** join/#uphpu romanovic (n=romanovi@c-67-182-248-31.hsd1.ut.comcast.net) |
| 04:35.16 | *** join/#uphpu jtsnow (n=chatzill@VDSL-151-118-130-129.DNVR.QWEST.NET) [NETSPLIT VICTIM] |
| 04:35.21 | *** join/#uphpu macnewbold (n=mac@hao.codegreene.com) |
| 04:35.21 | *** mode/#UPHPU [+o macnewbold] by ChanServ |
| 04:47.10 | *** join/#uphpu Utah_Dave1 (n=David@97-126-223-64.slkc.qwest.net) |
| 06:12.00 | *** mode/#UPHPU [+o utah_dave] by ChanServ |
| 14:03.41 | *** join/#uphpu Utah_Dave (n=David@c-67-172-225-101.hsd1.ut.comcast.net) |
| 14:03.41 | *** mode/#UPHPU [+o Utah_Dave] by ChanServ |
| 16:51.16 | *** join/#uphpu Utah_Dave1 (n=David@c-67-172-225-101.hsd1.ut.comcast.net) |
| 17:57.27 | *** join/#uphpu Utah_Dave (n=David@c-67-172-225-101.hsd1.ut.comcast.net) |
| 17:57.27 | *** mode/#UPHPU [+o Utah_Dave] by ChanServ |
| 18:57.32 | *** join/#uphpu Utah_Dave1 (n=David@c-67-172-225-101.hsd1.ut.comcast.net) |
| 19:17.46 | *** mode/#UPHPU [+o Utah_Dave] by ChanServ |
| 19:33.11 | *** join/#uphpu blendmaster1024 (n=olpc@75-169-194-67.slkc.qwest.net) |
| 20:03.01 | macnewbold | ~yow |
| 20:18.56 | *** join/#uphpu DexterTheDragon (n=admin@oalug/member/blackchaos) |
| 20:18.56 | *** mode/#UPHPU [+v DexterTheDragon] by ChanServ |
| 20:41.31 | *** join/#uphpu justincarmony (n=justinca@97-126-228-68.slkc.qwest.net) |
| 20:41.31 | *** mode/#UPHPU [+v justincarmony] by ChanServ |
| 20:46.11 | *** join/#uphpu blendmaster1024 (n=olpc@75-169-194-67.slkc.qwest.net) |
| 20:46.15 | *** part/#uphpu Utah_Dave (n=David@c-67-172-225-101.hsd1.ut.comcast.net) |
| 21:30.41 | *** join/#uphpu justincarmony_ (n=justinca@63-224-106-98.slkc.qwest.net) |
| 21:37.46 | *** join/#uphpu justincarmony_ (n=justinca@63-224-106-98.slkc.qwest.net) |
| 21:49.21 | *** join/#uphpu Utah_Dave1 (n=David@97-126-223-64.slkc.qwest.net) |
| 21:54.46 | *** join/#uphpu Utah_Dave2 (n=David@c-67-172-225-101.hsd1.ut.comcast.net) |
| 21:57.55 | *** mode/#UPHPU [+o Utah_Dave] by ChanServ |
| 22:07.50 | *** join/#uphpu Citrus (n=Citrus@pool-173-63-39-114.nwrknj.fios.verizon.net) |
| 22:08.34 | Citrus | can anyone tell me what's wrong with this |
| 22:08.35 | Citrus | $getmin = "SELECT MIN(comment_id) FROM comment WHERE comment_chosen_id = $featureid"; |
| 22:12.00 | DexterTheDragon | Citrus: MIN() is an aggregate function and needs a GOURP BY, I believe |
| 22:12.14 | Citrus | what's that |
| 22:12.59 | DexterTheDragon | s/GOURP BY/GROUP BY/ |
| 22:13.14 | DexterTheDragon | Citrus: http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html#function_min |
| 22:13.15 | Citrus | i have no idea what that means couldy ou explain |
| 22:19.18 | Citrus | hello? |
| 22:23.05 | justincarmony_ | what are you trying to get the min of? |
| 22:24.32 | Citrus | i am making comments |
| 22:24.35 | Citrus | err |
| 22:24.38 | Citrus | trying to display comments |
| 22:24.44 | Citrus | so each comment has it's own id |
| 22:24.46 | Citrus | 1-whatever |
| 22:24.49 | Citrus | and then each comment |
| 22:24.55 | Citrus | has a post_id it is associated with |
| 22:25.05 | Citrus | so what i am doing is finding the minimum comment ID |
| 22:25.08 | Citrus | for each post_id |
| 22:26.23 | DexterTheDragon | SELECT comment_id FROM comment WHERE comment_chosen_id=$featureid ORDER BY comment_id ASC LIMIT 1 |
| 22:26.27 | DexterTheDragon | is that what you want? |
| 22:27.37 | Citrus | i dont klnow |
| 22:27.38 | Citrus | maybe? |
| 22:27.39 | Citrus | lol |
| 22:27.40 | Citrus | ill try it |
| 22:35.41 | Citrus | that did the trick |
| 22:35.43 | Citrus | thanks a lot dexter |
| 22:35.51 | Citrus | (dexterthedragon) |