Adding loop in mysql query

[sungpeng]

mysql_query("update pupils set record='running' where pid !='$testing[0]' 

AND pid !='$testing[1]' 

AND pid !='$testing[2]' 

AND pid !='$testing[3]'

AND pid !='$testing[4]'

etc

")

 

 

 

Anyway to add in a loop ?

[Barand]

No, but you can

$idlist = join(',', $testlist)
mysql_query("update pupils set record='running' where pid NOT IN ($idlist)");

so the query looks like this, for example

update pupils set record='running' where pid NOT IN (1,5,9,18)

[sungpeng]

Thank You