<div>
Hi Ray -<br />
<br />
You always come to my rescue :-)<br />
<br />
I will play with this a bit later and keep you posted -<br />
<br />
Hope you're having a wonderful day -<br />
<br />
Richard
</div>


Hi Ray -

You always come to my rescue :-)

I will play with this a bit later and keep you posted -

Hope you're having a wonderful day -

Richard

<div>
Hi Ray -<br />
<br />
Worked like a charm and I even learned enough to write another!<br />
As always the folks at experts exchange are super and you're a super hero to me :-)<br />
<br />
have a wonderful day<br />
R
</div>


Hi Ray -

Worked like a charm and I even learned enough to write another!
As always the folks at experts exchange are super and you're a super hero to me :-)

have a wonderful day
R

<div>
<div class="content wysiwyg-content">
Hi -<br />
I have a table with time card type data -<br />
I need help creating a trigger for two specific fields in the table (start_time, end_time) that will not allow the fields to be updated once they have values in them -<br />
The process is that a 'record' is inserted into the table for a specific task with empty start and stop datetime fields -<br />
The start and stop fields are updated using a form when the task is started and finished -<br />
I do not want the user to be able to use the form again to 'change' the start and finished times -<br />
<br />
This is my first attempt at creating a trigger and I have spent way too many hours trying to figure out how to make this work :-)<br />
<br />
Any and all help gratefully appreciated -<br />
Richard
</div>
</div>


Hi -
I have a table with time card type data -
I need help creating a trigger for two specific fields in the table (start_time, end_time) that will not allow the fields to be updated once they have values in them -
The process is that a 'record' is inserted into the table for a specific task with empty start and stop datetime fields -
The start and stop fields are updated using a form when the task is started and finished -
I do not want the user to be able to use the form again to 'change' the start and finished times -

This is my first attempt at creating a trigger and I have spent way too many hours trying to figure out how to make this work :-)

Any and all help gratefully appreciated -
Richard

php mysql need help with table  trigger

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

trigger

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.