thanks a lot for your reply...sorry for not including the code.
What I'm trying to make is smt like:
$query= mysql_query("select * from test where flag=\"\" ") or die(mysql_error()) ;
$hold=1;
while(($row = mysql_fetch_array($query)) and ($hold==1 ))
{
echo "<form method=post action=$PHP_SELF >";
$keynr = $row["keynr"];
$adres = $row["adres"];
$postcode = $row["postcode"];
$woonplaats = $row["woonplaats"];
echo "keynr = $keynr ;<br>
adres = $adres ;<br>
postcode = $postcode ;<br>
woonplaats = $woonplaats ;<br>";
$hold=0;
echo "<input type=submit value=SELECT><br>";
$query_add_flag = "update test set flag='yes' where keynr=$keynr ";
mysql_query($query_add_flag)or
die (mysql_error());
echo "<input type=button value=EXIT onclick=self.close()>";
echo "</form>";
}
The problem is..as soon as the .php -file is called..it gives automatically the first line ($keynr) flag 'yes'. while what I need is..of course, to have it set to yes after the user click the button.
Can someone help how the logic goes here....
noy