Hi,
I have a need to clear down a field in a table prior to re-filling it with new values. If in the PHP page I clear it down and then immediatley run the query to fill in the values I find that the first query hasn\'t finished in time and therefore wipes out new values.
The cose is:
$query = "update LOW_PRIORITY " . $selDim . " set limitint = null;";
$result = mysql_query($query) or die($selDim . " Update (set to NULL) failed");
$i=0;
while ($_GET["selChosen"][$i] != "")
{
$query= "update " . $selDim . " set limitint = " . $i .
" where dimvalue = \'" . $_GET["selChosen"][$i] . "\'";
$result = mysql_query($query) or die($selDim . " Update (set limitint) failed");
$i++;
}
$selDim is the table name.
The Values are based on a multiple selection box and I use the value that I place in the field for ordering purposes.
Can anyone tell me what I amdoing wrong - or is there a way of putting an appropriate if-then clause in the MySQL?
Thanks