Hi!

I dont know if this possible

I have a payments table in a database

what I want to accomplish is,

once a certain customer id has paid say $100 USD

my discounts table will generate a code for me automatically

say I'll insert a new record

is there such thing as automated insertion without me clicking anything?

thanks!

Recommended Answers

Perhaps a database trigger. You can write an update trigger, that gets activated when a record changes. Then you decide to insert a record if the amount is high enough. If this is what you want, I suggest you have this question moved to the MySQL forum.

Jump to Post

All 2 Replies

Re: Automated PHP Script? 80 80

Perhaps a database trigger. You can write an update trigger, that gets activated when a record changes. Then you decide to insert a record if the amount is high enough. If this is what you want, I suggest you have this question moved to the MySQL forum.

Re: Automated PHP Script? 80 80

this is what im looking for. thanks!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.19 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.