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: 2011FleaFlicker Fantasy Football - Bronze: 2016ESPN NCAA March Madness - Bronze: 2010Yahoo! NCAA March Madness - Bronze: 2013

United States
Joined: 10/13/2006(UTC)
Location: Green Bay, WI
Applause Given: 2,505
Applause Received: 4,067
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: 2011FleaFlicker Fantasy Football - Bronze: 2016ESPN NCAA March Madness - Bronze: 2010Yahoo! NCAA March Madness - Bronze: 2013

United States
Joined: 10/13/2006(UTC)
Location: Green Bay, WI
Applause Given: 2,505
Applause Received: 4,067
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: Stratford, New Jersey
Applause Given: 409
Applause Received: 351
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: 2011FleaFlicker Fantasy Football - Bronze: 2016ESPN NCAA March Madness - Bronze: 2010Yahoo! NCAA March Madness - Bronze: 2013

United States
Joined: 10/13/2006(UTC)
Location: Green Bay, WI
Applause Given: 2,505
Applause Received: 4,067
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: 437
Applause Received: 1,238
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: 437
Applause Received: 1,238
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: 2011FleaFlicker Fantasy Football - Bronze: 2016ESPN NCAA March Madness - Bronze: 2010Yahoo! NCAA March Madness - Bronze: 2013

United States
Joined: 10/13/2006(UTC)
Location: Green Bay, WI
Applause Given: 2,505
Applause Received: 4,067
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
shield4life (8h) : Resign Nick Perry
uffda udfa (12h) : Need some strong sharp passionate voices on D. Daniels gives great quotes.
uffda udfa (12h) : Nick Perry seems to be the team leader as he was giving pregame speeches that seemed very uninspiring.
uffda udfa (12h) : Morgan and his 14 wonderlic. Ever hear him talk? Man, not a bright guy at all.
uffda udfa (12h) : Burnett needs to be replaced. That's our leader? Or one of them? No, thanks.
beast (14h) : For the secondary, I think Burnett/Haha are the leaders.
Smokey (14h) : GB needs a new motto : DEFENSE RULES ! , is intended to change the direction of the Packers focus moving forward .
Smokey (14h) : Thank You Zero.
Zero2Cool (14h) : Great reading a thread and seeing "defense rules" spammed in them all. Great reading material.
Smokey (15h) : DEFENSE RULES !
Zero2Cool (15h) : Think you need to defensive leaders. Front Seven and Secondary. We seem to lack both. Daniels is closest.
beast (15h) : Packers players had a right to complain when they were being bullied by Mike Daniels... just talking about Packers ;-) jk
Zero2Cool (15h) : It was the 26th largest margin since 1940. Feels much worse
Zero2Cool (15h) : thought it was biggest margin of victory in Conf Championship, I was mistaken.
Smokey (18h) : Wow ! The Packers got disrespected too !
Smokey (18h) : Hello ?
uffda udfa (19h) : Can't. MM burned them all.
Smokey (19h) : go pack go ?
wpr (19h) : Smokey AND Uffda, you both ca be placed in a timeout. Stop it.
Smokey (19h) : go pack go :)
Zero2Cool (19h) : STOP! Talk Packers or STFU. K thanks. :-)
uffda udfa (19h) : Ranting about everyone to stop talking Wolf while talking cooking appliances.
uffda udfa (19h) : I told you the truth. It upset you. U were hypocritical.
Smokey (20h) : yes I was, but he just ...
Zero2Cool (21h) : We all have the same ability to ignore someone. Exercise that. GO PACK GO!!!
Smokey (21h) : NOT YOUR FIGHT NONSTOP
Nonstopdrivel (21h) : ving again.
Nonstopdrivel (21h) : Calling him a bully? Telling him to leave? Seriously? This is the kind of shit that drove me away last time and is making me contemplate lea
Smokey (22h) : Be a good fellow and go pester another forum.
Smokey (22h) : It amazes me that you've remained in this forum for as long as you have.
Smokey (22h) : This is not your schoolyard to bully others, in fact I was that kid who stood up to the bully and kicked his ass.
Smokey (22h) : In the end the bully ended up in prison as everyone else grew up and moved on with their lives.
Smokey (22h) : I rate you with the hated schoolyard bully that tried to terrorize others to feel himself big.
Smokey (22h) : U2, it is obvious that you don't care if people like you or not. Well people don't.
uffda udfa (23-Jan) : It's the same day every day at 1265. They crave sameness.
Please sign in to use Fan Shout

2016 Packers Schedule
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 @ 3:25 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 @ 7:30 PM
at Lions

Think About It
Think About It

Recent Topics
5h / Football Familiarity / mojaveson

5h / Green Bay Packers Talk / uffda udfa

5h / Green Bay Packers Talk / uffda udfa

5h / Green Bay Packers Talk / mojaveson

5h / Green Bay Packers Talk / mojaveson

5h / Green Bay Packers Talk / mojaveson

5h / Green Bay Packers Talk / mojaveson

5h / Green Bay Packers Talk / mojaveson

10h / Green Bay Packers Talk / mojaveson

12h / Green Bay Packers Talk / DoddPower

12h / Green Bay Packers Talk / DoddPower

12h / Green Bay Packers Talk / DoddPower

12h / Green Bay Packers Talk / DoddPower

15h / Green Bay Packers Talk / Smokey

16h / Fantasy Sports Talk / rabidgopher04


Packers Headlines