Member Avatar for prabhatsingh

i have two fields in mysql database entry time ->type time stamp and exit time->type datetype.
entry time should be entered at fist submissin of form and exit time should be null..and when i update the table then the exit time fiels should be updated..but this is not happing..entry is ok but exit time is not being update ..any one can tell me the code to do it.

  • 2 Contributors
  • 4 Replies
  • 95 Views
  • 23 Minutes Discussion Span
  • Latest Post Latest Post by jj.dcruz
Member Avatar for jj.dcruz

can you show your codes?

but I think this will help
UPDATE tbl_name SET end_time='values' WHERE id='values'

Member Avatar for prabhatsingh

$exittime=getdate("y/m/d H:i:s");
$query2="UPDATE attendance SET exit_time=$exittime WHERE emp_id = '$empid'";

Member Avatar for prabhatsingh

i have taken datetime type for exit_time field..but in the database there is nothing updating.

Member Avatar for jj.dcruz

$exittime=getdate("y-m-d H:i:s");
$query2="UPDATE attendance SET exit_time='$exittime' WHERE emp_id = '$empid'";

use this command

Be a part of the DaniWeb community

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