MS SQL

MS SQL RSS

Notify a new row entry

Please support our MS SQL advertiser: Intel Parallel Studio Home

•

Join Date: Oct 2008

Posts: 9

Reputation: bvssam is an unknown quantity at this point

Solved Threads: 0

bvssam

Offline

Newbie Poster

Notify a new row entry

Dec 30th, 2008

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

•

Join Date: Jan 2007

Posts: 276

Reputation: kanaku is on a distinguished road

Solved Threads: 15

kanaku

Offline

Posting Whiz in Training

Re: Notify a new row entry

Dec 30th, 2008

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

 Help with Code Tags 
 MS SQL Syntax (Toggle Plain Text) 
... php code FOR query...
 
IF @@rowcount > 0
... php code FOR mailing the admin
... php code for query...

if @@rowcount > 0
... php code for mailing the admin

Oh look, there's a daniweb thread on sendmail!

•

Join Date: Oct 2008

Posts: 9

Reputation: bvssam is an unknown quantity at this point

Solved Threads: 0

bvssam

Offline

Newbie Poster

Re: Notify a new row entry

Dec 30th, 2008

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.