After insert update

CodeCharge Studio

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.
CodeCharge.com

YesSoftware Forums -> Archive -> GotoCode Archive

After insert update

Author

Message

Humberto Ahumada

Posted: 01/16/2003, 3:20 PM

Can some one tell me how to run a query on an after insert event?

This is what I am trying to run:

delete from tLastLead;

insert into tLastLead
(tLeadID,THistoryID)
select hLeadID,
max(hHistoryID) from historial
group by 1;

I am using PHP and MySQl with CC 2.05

Alex Alexapolsky

Posted: 01/17/2003, 2:17 AM

It's done this way
$db->query("some sql statement");

Humberto Ahumada

Posted: 01/18/2003, 1:02 PM

Thanks! That did it for me!

These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home | Search | Members | Register | Login