php update command problem discussion

[sauhard123]

I want to update attendence column by inserting intime and outtime at the table below is the coding and I want to show the result on the browser and also should be updated in table

$result = mysql_query("SH OW COLUMNS FROM mark_attendence ");
while ($row = mysql_fetch_ass oc($result)) {
mysql_query("UP DATE mark_attendence SET ".$row['InTime']." = '' WHERE ".$row['field']." = 'currentvalue'" )

[Dormilich]

why do you have that SHOW COLUMNS query there? if you want to update a field—and you know its name—why not using that name directly?

besides that, there ain’t a key 'InTime' in the SHOW COLUMNS result. consult the MySQL manual to know what it really does.

[ngotung208]

Thank you share posts. posts very useful!