re selecting multiple date column

sweetstuff2003

Hello,

I have various fields received, filed, entered, void which have date+time value feeding into the column.
Basically, these values will have click buttons next to them and worker will click one of those buttons to inform of the current status they are in.
What i want the worker to do is when they click any progress button it will stamp the date on the display.php next to the button (display.php is the page the worker sees) and then update the database table work_progress i.e if they clicked the entered button the date will stamp on the display.php page and at the same time send the updated date to the right column (filed, entered, void etc). the $timestamp being the date field on display.php.

I was wondering what the best approach for such a code would be.
Heres my sql script that i am thinking off to update and insert... i would love any better approach..

UPDATE work_progress
SET $timestamp = received OR
entered OR
filed OR
VOID
WHERE timestamp = INSERT statement to columns

actually, comparison would be difficult. as progression is from received to filed. so would that be better to compare with the previous date and time stamp? hmmm.. any help? cheers

😕

barand

You could maybe try something along these lines

<?
$cnx = mysql_connect('localhost');
mysql_select_db('test', $cnx);
if ($_POST['action'] != '') {
    $time = date('Y-m-d H:i:s');
    $fieldname = $_POST['action'];
    $id = $_POST['id'];
    mysql_query("UPDATE work_progress SET $fieldname = '$time' WHERE id = $id");
}
?>


<html>
<!-- Creation date: 06/09/03 -->
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Progress update</title>
</head>
<body>
<FORM  action="<?=$_SERVER[PHP_SELF]?>" method="POST">
<INPUT TYPE="HIDDEN" name="id" VALUE="<?=$id?>">
<INPUT TYPE="SUBMIT"  name="action" value="Received">
<INPUT TYPE="SUBMIT"  name="action" value="Filed">
<INPUT TYPE="SUBMIT"  name="action" value="Entered"></FORM>
</body>
</html>

sweetstuff2003

hiya,
thanks for advice, ive worked around the date issue by creating a tick boxes as options for selection of status. so when user submits the page the chosen tick box updates with timestamp and timestamped variables are sent to the column belonging to the status (for instance entered field) with the timestamp at the same time updating the current status column (prob name it cur_stat and will be updated with the date and time thats most recent. then i will prob have to do a UPDATE command to update that but at least the logic is there..

cheers.

sweetstuff2003

hi.
just thought of a problem with this method of check box.

i have a unique key entry on the display.php (same page as the check boxes for entered, filed etc. the worker logs a new task number e.g 8776 and that number fires off to the database and saves it. But , problem occurs with the check boxes each time they want to update the status of the task then there will be an error because it will already have that same task number saved in the database so its gonna create a duplicate entry for the task no.

so that leaves me with two problems..
1) how do i let them update status with timestamp (i.e from received to filed check boxes each time they enter that page and enter the task number) without creating an entry error for same task number?

i am thinking of giving them an option also of adding a new task number.
2) task number creation comparison... will have to compare with existing task number entry, if its not there then add new one..

does anyone have any idea on this?