Green Bay Packers Forum

Welcome to your Green Bay Packers Online Community!

Since 2006, PackersHome has been providing a unique experience for fans.
Your participation is greatly anticipated!
Login or Register.
3 Pages123>
Options
Go to last post Go to first unread
Offline Zero2Cool  
#1 Posted : Friday, October 22, 2010 2:59:22 PM(UTC)
Rank: Premier Member

Yahoo! NCAA March Madness - Gold: 2015Yahoo! Fantasy Football - Gold: 2009FleaFlicker Fantasy Football - Silver: 2010Yahoo! NCAA March Madness - Silver: 2011ESPN NCAA March Madness - Bronze: 2010Yahoo! NCAA March Madness - Bronze: 2013

United States
Joined: 10/13/2006(UTC)
Location: Green Bay, WI
Applause Given: 2,346
Applause Received: 3,634
I'm trying to clean up the database.

My goal is to remove the posts from members that have been deleted.

I want a select statement that shows me how many of them there are before deleting.


I think I'll be using three tables with this.

table (field)
[ul]users (user_id)
posts (poster_id)
posts_text (post_id)[/ul]

Every post is given and id number. Then that id number is assigned to the post text.

The relationship between users and posts is the user_id and poster_id.
The relationship between posts and posts_text is the post_id.

I tried this, but it didn't work so well.

[php]SELECT *
FROM posts LEFT JOIN users
ON posts.poster_id != users.user_id[/php]


I think I caused some site load errors with this query too, lol.
Offline dhpackr  
#2 Posted : Friday, October 22, 2010 3:09:19 PM(UTC)
Rank: Registered

Joined: 12/12/2007(UTC)
Applause Given: 36
Applause Received: 36
bummer you can't delete posts
Offline dhpackr  
#3 Posted : Friday, October 22, 2010 3:17:12 PM(UTC)
Rank: Registered

Joined: 12/12/2007(UTC)
Applause Given: 36
Applause Received: 36
don't you want to use count

SELECT posts, COUNT(*) FROM posts WHERE Posterid=poster_id GROUP BY poster_id;

you have to play around with the table names, and you add quite a bit to a query with 'where' & 'group by' as well as 'orderby'

just running a select or count query should not break the site
Offline Zero2Cool  
#4 Posted : Friday, October 22, 2010 3:22:57 PM(UTC)
Rank: Premier Member

Yahoo! NCAA March Madness - Gold: 2015Yahoo! Fantasy Football - Gold: 2009FleaFlicker Fantasy Football - Silver: 2010Yahoo! NCAA March Madness - Silver: 2011ESPN NCAA March Madness - Bronze: 2010Yahoo! NCAA March Madness - Bronze: 2013

United States
Joined: 10/13/2006(UTC)
Location: Green Bay, WI
Applause Given: 2,346
Applause Received: 3,634
I dunno, do I?
Offline dhpackr  
#5 Posted : Friday, October 22, 2010 3:25:30 PM(UTC)
Rank: Registered

Joined: 12/12/2007(UTC)
Applause Given: 36
Applause Received: 36
you know the answer, just play around till you get the query.

wanna let me in?

i'll try
otherwise this will help
Offline Nonstopdrivel  
#6 Posted : Friday, October 22, 2010 3:31:11 PM(UTC)
Rank: Select Member

United States
Joined: 9/14/2008(UTC)
Location: Germany
Applause Given: 389
Applause Received: 263
I'm confused. Are you wanting to clean up deleted posts or posts by deleted members? The owner of the other board I used to administrate did the latter routinely; unfortunately, some of the most prolific members (e.g., instructors) were getting deleted. This resulted in some of our best threads being rendered nearly indecipherable, with members responding to phantom statements and questions. Threads came to resemble Swiss cheese, with much of the best content missing, rendering them all but useless. If this is what you want to do, I'd urge caution in implementing it.
Offline Zero2Cool  
#7 Posted : Friday, October 22, 2010 3:36:19 PM(UTC)
Rank: Premier Member

Yahoo! NCAA March Madness - Gold: 2015Yahoo! Fantasy Football - Gold: 2009FleaFlicker Fantasy Football - Silver: 2010Yahoo! NCAA March Madness - Silver: 2011ESPN NCAA March Madness - Bronze: 2010Yahoo! NCAA March Madness - Bronze: 2013

United States
Joined: 10/13/2006(UTC)
Location: Green Bay, WI
Applause Given: 2,346
Applause Received: 3,634
627 posts returned.


Every post should have a valid relationship to a member.
Every topic should have a valid relationship to a post.
Every post should have a valid relationship to a topic.

I don't want rogue data out there.
Offline Pack93z  
#8 Posted : Friday, October 22, 2010 3:44:48 PM(UTC)
Rank: Select Member

PackersHome NFL Pick'em - Bronze: 2012

United States
Joined: 3/16/2007(UTC)
Location: North Central Wisconsin
Applause Given: 435
Applause Received: 1,203
Yes use the count, cleaner approach for your request in the first post.. as a review.
Offline Pack93z  
#9 Posted : Friday, October 22, 2010 3:45:50 PM(UTC)
Rank: Select Member

PackersHome NFL Pick'em - Bronze: 2012

United States
Joined: 3/16/2007(UTC)
Location: North Central Wisconsin
Applause Given: 435
Applause Received: 1,203
Okay.. with the timeout error, more than likely due to query gen, my comment now seems out of place. lol.
Offline Zero2Cool  
#10 Posted : Friday, October 22, 2010 3:52:22 PM(UTC)
Rank: Premier Member

Yahoo! NCAA March Madness - Gold: 2015Yahoo! Fantasy Football - Gold: 2009FleaFlicker Fantasy Football - Silver: 2010Yahoo! NCAA March Madness - Silver: 2011ESPN NCAA March Madness - Bronze: 2010Yahoo! NCAA March Madness - Bronze: 2013

United States
Joined: 10/13/2006(UTC)
Location: Green Bay, WI
Applause Given: 2,346
Applause Received: 3,634
627 is what I got back, which is just a list of members who have 1 or more posts.

The member list shows 618 with a post.

That to me means we have posts for 9 members that have been deleted.
Rss Feed 
Users browsing this topic
Guest
3 Pages123>
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Notification

Icon
Error


Fan Shout
Smokey (9h): NFL Football tonight on NBC !
uffda udfa (12h): Cancer sucks. Claims children and others way too young. Sorry, 4 your loss.
yinzer (18h): wpr, I'm sorry to hear of your loss
Cheesey (23-Aug): Wow, Wayne. Sorry to hear about that. It's never easy to lose a loved one, no matter what age.
Zero2Cool (22-Aug): Sorry, Wayne. :-(
wpr (22-Aug): Lost a friend to Pancreatic cancer. Bummed. He was only 55. Hard working dairy farmer. I am not sure if his kids will be up to the task.
Zero2Cool (21-Aug): Yes
LSUzilla (21-Aug): is there a prize for the pickem game this year?
Smokey (19-Aug): Mexican Mucky , your a genius ! Chimichangas !
Smokey (19-Aug): Sorry Zero, wilted lettuce does not qualify . LOL
Mucky Tundra (19-Aug): beef
Zero2Cool (19-Aug): ... me
Smokey (19-Aug): Meat of the day ? Chicken, Fish, or Pork ?
Smokey (15-Aug): Still Recruiting, The Tailgaters Fantasy Football League
Zero2Cool (15-Aug): Lions sign TE Andrew Quarless
Zero2Cool (15-Aug): I got sound working last night! Woohoo!
Smokey (13-Aug): Then , Maybe Not
buckeyepackfan (12-Aug): GAMEDAY NIGHT!!!!(sort of) GO! PACK! GO!
Zero2Cool (11-Aug): load it up billy!!
Smokey (10-Aug): Rugby reminds me of my childhood when the neighborhood lads all played "fumble ball" .
Smokey (10-Aug): I tune in for Olympic Archery and get half naked women playing in the sand ! Life is good !
Smokey (10-Aug): Still, The Shadow Knows .
Zero2Cool (10-Aug): You'll have to tune in Friday evening to find out. Dun dun dunnnnn!!!! ??
Smokey (10-Aug): Will the Browns game be in the Chat ?
gbguy20 (7-Aug): game cancelled.
Smokey (7-Aug): What's going on with the Chat , dhazer ?
gbguy20 (7-Aug): come onnnnnnnn
gbguy20 (7-Aug): why arent we streaming the speeches
Mucky Tundra (6-Aug): From Green Bay to New Orleans...two couldn't be further apart
Zero2Cool (6-Aug): Saints signing fullback John Kuhn
wpr (5-Aug): It rained in Illinois overnight
Smokey (5-Aug): Y U in Bangkok , fatguy ?
fatguy (5-Aug): Go Pack, Go
fatguy (5-Aug): Hello from Bangkok. It's raining.
Zero2Cool (2-Aug): Chargers will sign former Packers WR James Jones
Please sign in to use Fan Shout

Road To Super Bowl LI
Sunday, Sep 11 @ 12:00 PM
at Jaguars
Sunday, Sep 18 @ 7:30 PM
at Vikings
Sunday, Sep 25 @ 12:00 PM
LIONS
Sunday, Oct 2 @ 12:00 AM
BYE
Sunday, Oct 9 @ 7:30 PM
GIANTS
Sunday, Oct 16 @ 3:25 PM
COWBOYS
Thursday, Oct 20 @ 7:25 PM
BEARS
Sunday, Oct 30 @ 12:00 PM
at Falcons
Sunday, Nov 6 @ 3:25 PM
COLTS
Sunday, Nov 13 @ 12:00 PM
at Titans
Sunday, Nov 20 @ 7:30 PM
at Redskins
Monday, Nov 28 @ 7:30 PM
at Eagles
Sunday, Dec 4 @ 12:00 PM
TEXANS
Sunday, Dec 11 @ 3:25 PM
SEAHAWKS
Sunday, Dec 18 @ 12:00 PM
at Bears
Saturday, Dec 24 @ 12:00 PM
VIKINGS
Sunday, Jan 1 @ 12:00 PM
at Lions

Think About It
Think About It

Recent Topics
2h / Green Bay Packers Talk / Barfarn

3h / Green Bay Packers Talk / Cheesey

3h / Green Bay Packers Talk / Cheesey

6h / Football Familiarity / Smokey

10h / Green Bay Packers Talk / uffda udfa

11h / Around The NFL / Smokey

15h / Green Bay Packers Talk / gotarace

16h / Green Bay Packers Talk / Smokey

17h / Green Bay Packers Talk / PackerTraxx

24-Aug / Green Bay Packers Talk / Barfarn

24-Aug / Green Bay Packers Talk / uffda udfa

24-Aug / Green Bay Packers Talk / sschind

24-Aug / Packers Draft Threads / DarkaneRules

23-Aug / Green Bay Packers Talk / wpr

23-Aug / Green Bay Packers Talk / PackFanWithTwins


Packers Headlines