shri
Fri 6th Apr '01, 2:11am
Hi,
I can get a users new threads by doing the following query (posting the logic and not query!!).
newpost = select count(*) from thread where postuserid='2';
I can get the total number of posts by a user by doing the following
replies = (select posts from user where userid='2';) - newposts
Now can I write one or two queries which will do the following
-- Take the new posts count and update the "posts" column in the user table
-- Take the replies and post them into a new column in user called replies
Can this be done without writing PHP code? i.e. from the mysql console?
Shri
I can get a users new threads by doing the following query (posting the logic and not query!!).
newpost = select count(*) from thread where postuserid='2';
I can get the total number of posts by a user by doing the following
replies = (select posts from user where userid='2';) - newposts
Now can I write one or two queries which will do the following
-- Take the new posts count and update the "posts" column in the user table
-- Take the replies and post them into a new column in user called replies
Can this be done without writing PHP code? i.e. from the mysql console?
Shri