UPDATE command (mysql)

[Anon]

This hopefully wil be an easy answer. I am trying to delete all info where I have a id = bla.

I have 5 colombs ie
id | item1| item2| item3| item4 |

And I want to clear all the info where the id = bla. But I want to retain the id. The user will keeps its id but will have to input fresh info evey time he visits this particular page.

So basically when he/she vivits the page it will delete all info against his or her id then they will input fresh data against the id.

Thanks

[Anon]

This should work.

UPDATE table_name SET name1='', name2='', name3='', name4='' WHERE id='blah';

[Anon]

Can I put it into a loop. So it can calculate hom many fields there is after the id field and delete all data past that. ??

I could put the mysql_query into a function using

function updatecolomb($name)
{
UPDATE table_name SET $name='' WHERE id='$session[id]';
}

while(?whatever)
{
updatecolom[$name)
}
But how can I count hom many fields there is apart from the id field. See I will be changing the data quite often so I need to have the script count the colombs and do it automatically

Lee

[smulpur]

You can use the sql

show fields from $table_name

and after mysql_query, using

mysql_num_rows

will give the total number of columns in that table (includig you id field in this case.)