943,540 Members | Top Members by Rank

Ad:
  • MS SQL Discussion Thread
  • Unsolved
  • Views: 981
  • MS SQL RSS
Dec 30th, 2008
0

Notify a new row entry

Expand Post »
Hi Group ,

A small Query ,I need to know how can I notify a new row entry in a table.

to be more specific I have a table Users If at all a new users registers from web his details are stored in database.
i would like to know is there any way to knwo the new row entry.

If so please let me know.

Sam
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
bvssam is offline Offline
9 posts
since Oct 2008
Dec 30th, 2008
0

Re: Notify a new row entry

Perhaps send an email to yourself when 1 row is updated after the adduser query?

MS SQL Syntax (Toggle Plain Text)
  1. ... php code FOR query...
  2.  
  3. IF @@rowcount > 0
  4. ... php code FOR mailing the admin

Oh look, there's a daniweb thread on sendmail!
Reputation Points: 70
Solved Threads: 15
Posting Whiz
kanaku is offline Offline
378 posts
since Jan 2007
Dec 30th, 2008
0

Re: Notify a new row entry

Well,

Thanks for the early reply

But my issue is slightly different say a user has registred ie.. a new row is updated in User table ,in the user table there is a feild Message I simply want the feild value ie.. message sent by user,should move to another table, when ever a new row is updated.
Reputation Points: 10
Solved Threads: 0
Newbie Poster
bvssam is offline Offline
9 posts
since Oct 2008
Dec 30th, 2008
0

Re: Notify a new row entry

Use triggers
Featured Poster
Reputation Points: 480
Solved Threads: 276
Postaholic
Ramy Mahrous is offline Offline
2,189 posts
since Aug 2006
Dec 30th, 2008
0

Re: Notify a new row entry

Reputation Points: 70
Solved Threads: 15
Posting Whiz
kanaku is offline Offline
378 posts
since Jan 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in MS SQL Forum Timeline: SQL 2008 Install Problem
Next Thread in MS SQL Forum Timeline: Complex Query





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC