Updating a database

Anon

I want to update records from a database, but there is a "little big" problem... I have not idea... please somebody could help me?... Thedata base is in acces... and I must use php ...

roel_v

Uhm yes if you 'have not idea', that's not so good... How far did you get? Do you have access odbc drivers and all working? Can you do select's on the database and are you just having problems with the update itself? Have you ever programmed in php/sql? If all of these are true, you can update records with the sql statement 'UPDATE'; so let's say
UPDATE name SET first_name='joske' WHERE last_name='vermeulen';
this would set the first name of all people who's last name is 'vermeulen' to 'joske'. Anyway, maybe this is not what you're looking for at all, be a bit more specific please...

BTW, can someone tell me which html tags are allowed in posts here?

Anon

Ok, I need to know the commands that can I use to retrieve records and show them in the web pag.
in order to update or to modify any record showed... Sorry But I can't speak english very well and I have problems
"saying" all I want to know... I write here because I supose the finality of this space is helping people to ask if somebody can help that it's ok if it doesn't happen...no problem...
btw... thank you very much Roel,to answered me.

roel_v

Sorry But I can't speak english very well and I have
problems "saying" all I want to know

That's ok, a lot of people here (including myself) aren't native English speakers.

Anyway, start by reading some intoduction texts on php and sql if you have never programmed php before. Basically, this is what you do:
-connect to database
-get results from database through sql
-loop through results, display them one by one

Your question is very general, you'll need to learn php and sql basics before you can start making something like this. There are good tutorials on php.net, and if you search through the articles and quickies/tips here on phpbuilder, you'll find instructions how to use access with php.