World's Longest Thread

Red Squirrel · Post by **Red Squirrel** » Sat Sep 24, 2005 11:11 pm

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

Mr Smith · Post by **Mr Smith** » Sun Sep 25, 2005 8:19 am

?

Archived topic from Anythingforums, old topic ID:4, old post ID:43090

Red Squirrel · Post by **Red Squirrel** » Sun Sep 25, 2005 3:39 pm

$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

Reaper · Post by **Reaper** » Sun Sep 25, 2005 4:56 pm

Yaaaay!

Archived topic from Anythingforums, old topic ID:4, old post ID:43093

Red Squirrel · Post by **Red Squirrel** » Sun Sep 25, 2005 6:01 pm

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

Mr Smith · Post by **Mr Smith** » Mon Sep 26, 2005 6:12 am

&nsbp;

Archived topic from Anythingforums, old topic ID:4, old post ID:43096

Mr Smith · Post by **Mr Smith** » Mon Sep 26, 2005 6:13 am

I think is the code for no post on v bulitten.

Archived topic from Anythingforums, old topic ID:4, old post ID:43097

Clueless · Post by **Clueless** » Mon Sep 26, 2005 4:09 pm

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

Reaper · Post by **Reaper** » Mon Sep 26, 2005 5:02 pm

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

Mr Smith · Post by **Mr Smith** » Mon Sep 26, 2005 5:07 pm

Monday, yuck.

Archived topic from Anythingforums, old topic ID:4, old post ID:43100

Red Squirrel · Post by **Red Squirrel** » Mon Sep 26, 2005 5:41 pm

It's probably that you wanted.

Archived topic from Anythingforums, old topic ID:4, old post ID:43101

Clueless · Post by **Clueless** » Mon Sep 26, 2005 10:49 pm

i feel somewhat ignored...

Archived topic from Anythingforums, old topic ID:4, old post ID:43102

ycontrol · Post by **ycontrol** » Tue Sep 27, 2005 1:43 am

So what's happening over here?

Archived topic from Anythingforums, old topic ID:4, old post ID:43103

Nirgal · Post by **Nirgal** » Tue Sep 27, 2005 11:54 am

I'm back!

Archived topic from Anythingforums, old topic ID:4, old post ID:43106

Mr Smith · Post by **Mr Smith** » Tue Sep 27, 2005 4:12 pm

Welcome back!

Archived topic from Anythingforums, old topic ID:4, old post ID:43107

Clueless · Post by **Clueless** » Tue Sep 27, 2005 5:56 pm

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

Red Squirrel · Post by **Red Squirrel** » Tue Sep 27, 2005 6:10 pm

Hahaha.
sounds like fun.

Archived topic from Anythingforums, old topic ID:4, old post ID:43112

Clueless · Post by **Clueless** » Tue Sep 27, 2005 6:15 pm

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

Reaper · Post by **Reaper** » Tue Sep 27, 2005 6:28 pm

Clueless wrote: i feel somewhat ignored...

I am sorry I ignored you. But the 'fro thing was just kind of weird and. . . . . .just weird.
:williamwallace:

Archived topic from Anythingforums, old topic ID:4, old post ID:43115

Mr Smith · Post by **Mr Smith** » Tue Sep 27, 2005 6:30 pm

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

Red Squirrel · Post by **Red Squirrel** » Tue Sep 27, 2005 6:30 pm

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

Clueless · Post by **Clueless** » Tue Sep 27, 2005 6:30 pm

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

Reaper · Post by **Reaper** » Tue Sep 27, 2005 6:58 pm

I love Gir.

Archived topic from Anythingforums, old topic ID:4, old post ID:43124

Clueless · Post by **Clueless** » Tue Sep 27, 2005 7:02 pm

haha girs awesome

Archived topic from Anythingforums, old topic ID:4, old post ID:43125

Reaper · Post by **Reaper** » Tue Sep 27, 2005 7:04 pm

My all time favorite cartoon character.

Archived topic from Anythingforums, old topic ID:4, old post ID:43126