问题描述
大家好,
我的要求是,如果一个用户增加了5名成员,他将为他的学分增加1学分表。为此我在这个表中使用memberconnection表列是
ID,RequieredMemberID,RecipientMemberID,Datecreated,StatusID。我想找出使用Datecreated栏的成员(RecipiencememberID')计数。
假设从今天到明天晚上的例子,我将得到5名成员,我希望将1个学分添加到另一个表。从明天晚上起,假设在
5days后我会得到5个成员数我想再添加1个积分就像循环一样。如何计算no.of成员(ReceipientMemberID)。
如何使用memberconnection中的datecreated列执行此要求。请告诉我任何一个。
谢谢
Hello all,
My requirement is, if one user is added 5 members , he will add 1 credit to his credit table. For this i am using memberconnection table in this table columns are
ID, RequieredMemberID, RecipientMemberID, Datecreated, StatusID. I want to find out members(RecipiencememberID''s) count using Datecreated column.
Suppose example from todaydate to tommorrow evening i will get 5 members count i want to add 1 credit to another table. from tomorrow evening onwards suppose after
5days i will get 5 members count i want to add another 1 credit just like loop . How count no.of members(ReceipientMemberID).
How i will do this requirement using datecreated column in memberconnection . Please tell me any one.
Thanks
推荐答案
这篇关于如何使用Datecreated列查找no.of列的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!