WHERE clause in POST (loop)

[karimali831]

...
while($dd=mysql_fetch_array($penaltypoints)) {
..
<input type="hidden" name="warnID" value="'.$dd['warnID'].'">
}
..

safe_query("UPDATE table SET column='".$_POST['name']."' WHERE warnID='".$_POST['warnID']."'");

 

Problem: warnID is incorrect, it selects this value from only one row and not using the loop.

For my query, I need to update it using the WHERE clause for warnID.

 

is there an alternative to my issue please?

[robert_gsfame]

...
while($dd=mysql_fetch_array($penaltypoints)) {
..
<input type="hidden" name="warnID" value="'.$dd['warnID'].'">
}
..

safe_query("UPDATE table SET column='".$_POST['name']."' WHERE warnID='".$_POST['warnID']."'");

 

Problem: warnID is incorrect, it selects this value from only one row and not using the loop.

For my query, I need to update it using the WHERE clause for warnID.

 

is there an alternative to my issue please?

 

U want to have it in loop??

while($dd=mysql_fetch_array($penaltypoints)) {

..

<input type="hidden" name="warnID" value="'.$dd['warnID'].'">

 

..

 

safe_query("UPDATE table SET column='".$_POST['name']."' WHERE warnID='".$_POST['warnID']."'");

 

} <--then the bracket should be placed here