Page 287 of 459
World's Longest Thread
Posted: Sat Sep 24, 2005 11:11 pm
by Red Squirrel
Wow been messing with sql for a while... these left joins and stuff can get pretty complicated when querying over 3 tables at once. my 900 page php/mysql book has been decent help though!
Archived topic from Anythingforums, old topic ID:4, old post ID:43089
World's Longest Thread
Posted: Sun Sep 25, 2005 8:19 am
by Mr Smith
?
Archived topic from Anythingforums, old topic ID:4, old post ID:43090
World's Longest Thread
Posted: Sun Sep 25, 2005 3:39 pm
by Red Squirrel
$hw=sbbs_query("DELETE ".$SBconf[dbprefix]."topics, ".$SBconf[dbprefix]."posts from ".$SBconf[dbprefix]."topics left join ".$SBconf[dbprefix]."posts ON ".$SBconf[dbprefix]."posts.pthreadid=".$SBconf[dbprefix]."topics.tid where ".$SBconf[dbprefix]."topics.tforumid='".$SBinfo[sect][f]."'");
Archived topic from Anythingforums, old topic ID:4, old post ID:43092
World's Longest Thread
Posted: Sun Sep 25, 2005 4:56 pm
by Reaper
Yaaaay!
Archived topic from Anythingforums, old topic ID:4, old post ID:43093
World's Longest Thread
Posted: Sun Sep 25, 2005 6:01 pm
by Red Squirrel
Took me a while to understand what I was doing when I wrote out that query.
Basically it deletes every post that belongs to every topic that belongs to a specific forum id.
Archived topic from Anythingforums, old topic ID:4, old post ID:43094
World's Longest Thread
Posted: Mon Sep 26, 2005 6:12 am
by Mr Smith
&nsbp;
Archived topic from Anythingforums, old topic ID:4, old post ID:43096
World's Longest Thread
Posted: Mon Sep 26, 2005 6:13 am
by Mr Smith
I think is the code for no post on v bulitten.
Archived topic from Anythingforums, old topic ID:4, old post ID:43097
World's Longest Thread
Posted: Mon Sep 26, 2005 4:09 pm
by Clueless
haha sweet, im gonna wear an afro to school tomorrow, for twin day, i found someone else with an afro! hahaha
Archived topic from Anythingforums, old topic ID:4, old post ID:43098
World's Longest Thread
Posted: Mon Sep 26, 2005 5:02 pm
by Reaper
Mr Smith wrote: &nsbp;
I know it's at least a space in HTML
Archived topic from Anythingforums, old topic ID:4, old post ID:43099
World's Longest Thread
Posted: Mon Sep 26, 2005 5:07 pm
by Mr Smith
Monday, yuck.
Archived topic from Anythingforums, old topic ID:4, old post ID:43100
World's Longest Thread
Posted: Mon Sep 26, 2005 5:41 pm
by Red Squirrel
It's probably that you wanted.
Archived topic from Anythingforums, old topic ID:4, old post ID:43101
World's Longest Thread
Posted: Mon Sep 26, 2005 10:49 pm
by Clueless
i feel somewhat ignored...
Archived topic from Anythingforums, old topic ID:4, old post ID:43102
World's Longest Thread
Posted: Tue Sep 27, 2005 1:43 am
by ycontrol
So what's happening over here?
Archived topic from Anythingforums, old topic ID:4, old post ID:43103
World's Longest Thread
Posted: Tue Sep 27, 2005 11:54 am
by Nirgal
I'm back!
Archived topic from Anythingforums, old topic ID:4, old post ID:43106
World's Longest Thread
Posted: Tue Sep 27, 2005 4:12 pm
by Mr Smith
Welcome back!
Archived topic from Anythingforums, old topic ID:4, old post ID:43107
World's Longest Thread
Posted: Tue Sep 27, 2005 5:56 pm
by Clueless
today was fun, wearing a giant afro to school got me alot of looks lol. a couple people were begging me to let them wear it and one of them tried to pay me a dollar to wear it, it was pretty funny, and people were laughing at me at walmart
Archived topic from Anythingforums, old topic ID:4, old post ID:43109
World's Longest Thread
Posted: Tue Sep 27, 2005 6:10 pm
by Red Squirrel
Hahaha.
sounds like fun.
Archived topic from Anythingforums, old topic ID:4, old post ID:43112
World's Longest Thread
Posted: Tue Sep 27, 2005 6:15 pm
by Clueless
i felt sorry for this little kid at walmart though, i think i scared him, my friend said he went crying to his mom
Archived topic from Anythingforums, old topic ID:4, old post ID:43114
World's Longest Thread
Posted: Tue Sep 27, 2005 6:28 pm
by Reaper
Clueless wrote: i feel somewhat ignored...
I am sorry I ignored you. But the 'fro thing was just kind of weird and. . . . . .just weird.
Archived topic from Anythingforums, old topic ID:4, old post ID:43115
World's Longest Thread
Posted: Tue Sep 27, 2005 6:30 pm
by Mr Smith
Clueless wrote: i felt sorry for this little kid at walmart though, i think i scared him, my friend said he went crying to his mom
Aww. Poor kid.
Archived topic from Anythingforums, old topic ID:4, old post ID:43116
World's Longest Thread
Posted: Tue Sep 27, 2005 6:30 pm
by Red Squirrel
Clueless wrote: i felt sorry for this little kid at walmart though, i think i scared him, my friend said he went crying to his mom
That's hilarious!
Archived topic from Anythingforums, old topic ID:4, old post ID:43117
World's Longest Thread
Posted: Tue Sep 27, 2005 6:30 pm
by Clueless
lol afros are awesome!!!!! everyone was touching my hair though, people even asked if it was really my hair.. crazy people
Archived topic from Anythingforums, old topic ID:4, old post ID:43118
World's Longest Thread
Posted: Tue Sep 27, 2005 6:58 pm
by Reaper
I love Gir.
Archived topic from Anythingforums, old topic ID:4, old post ID:43124
World's Longest Thread
Posted: Tue Sep 27, 2005 7:02 pm
by Clueless
haha girs awesome
Archived topic from Anythingforums, old topic ID:4, old post ID:43125
World's Longest Thread
Posted: Tue Sep 27, 2005 7:04 pm
by Reaper
My all time favorite cartoon character.
Archived topic from Anythingforums, old topic ID:4, old post ID:43126