logic problem causing a problem after reloading
Posted: Tue Nov 29, 2005 9:34 pm
i have a problem...
when the admin clicks on a certain row of data to edit, i will lock that row of data using the below queries:
$query = "UPDATE report SET Locked='1' WHERE ReportID='$_GET[ReportID]'";
$result5 = mysql_query($query) //process the sql statement into a result
//if there is a problem with the statement it will print the line couldnt execute query
or die ("couldn't execute query5.");
if some1 trys to click on the same row of data now, it will appear a MESSAGE page saying that the data is currently being edited.
when the admin trys to click on a drop down to change the value of the data. i have 2 drop downs and they are dynamically related using javascript
like when the admin clicks on an option in drop down A, the page RELOADS and the options available in drop down B will appear based on the option selected in drop down A.
the problem then arises, when the page RELOADS after the admin selects the drop down, the admin is directed to the MESSAGE page.
how can i make the admin stay in the editing page after the page reloads?
i have a locked column by default is set to 0.
when the admin clicks on a certain row of data to edit, i will lock that row of data using the below queries:
$query = "UPDATE report SET Locked='1' WHERE ReportID='$_GET[ReportID]'";
$result5 = mysql_query($query) //process the sql statement into a result
//if there is a problem with the statement it will print the line couldnt execute query
or die ("couldn't execute query5.");
if some1 trys to click on the same row of data now, it will appear a MESSAGE page saying that the data is currently being edited.
when the admin trys to click on a drop down to change the value of the data. i have 2 drop downs and they are dynamically related using javascript
like when the admin clicks on an option in drop down A, the page RELOADS and the options available in drop down B will appear based on the option selected in drop down A.
the problem then arises, when the page RELOADS after the admin selects the drop down, the admin is directed to the MESSAGE page.
how can i make the admin stay in the editing page after the page reloads?
i have a locked column by default is set to 0.