UPDATING MULTIPLE ROWS IN ONE COLUMN

[shuja]

HI

m working on project attendance system and attendance is recorded on daily bases.. i have to insert record in currunt date column in attendence tabl against specific roll nos. my script is not working as status does'nt change against specific roll no
foreach ($POST['id'] as $status)//array of P or A
{
foreach ($POST['st'] as $entry)//array of roll nos
{
$query = "UPDATE attendence SET $date = '$status' WHERE std_rno= '$entry'" ;
if (!mysql_query($query,$con))
die('Error: '. mysql_error());
}
}
i wish to have rec like this
.........................................................
std_rno 14/08/10
bcom-603 P
bcom-604 A
........................................................

............................

[Crowly]

This doesnt make any sence

SET $date = '$status'

they are both php variables, one of them has to be a database field. Might be that $date should be date, then it would make sence 😉

[shuja]

it makes sence when
$date=date("d/m/y");
and it is column name of db. like 14/08/2010 it works.....;-)

problm is not that problm is to apply loop so that each element of $entry update w.r.t $status
like 1st element of $entry updated where 1st element of $status and so on.