Update * 2

Update tblItems set fldItem = fldItem +1 WHERE fldItem = 'Æbler'

actually that isnt quite correct
Update tblItems set qty= qty+1 WHERE fldItem = 'Æbler'

tblItems  = table which contains your items such as apples and oranges
fldItem  is the field which contains the name of the item
qty      is the number of taht item you have

I not sure that you have understand me correct.
Not good to english but i try.

If you say that you have a system where you ´can buy a apple for money. Så in you database will you have to update two times . How do i update to times in one update string?
So if you buy a apple you lose 10$ but i will get 1 apple in your database

I understand danish so you dont need to write in English, but thanks :o)

It all depends on the tables you have.

You can not update 2 tables at the same time, if that is what you are trying to do

Try explaining what tables you have and what they are used for.

Ok.. Godt du kan dansk:) Hvorfor skriver du så på engsk?

Nå. Men hvis vi siger vi har en database kaldet bruger. I den er der et felt der hedder id, brugernavn, æble og penge.
Bruger{
id = 1
brugernavn = Leo
æble = 0
penge = 100
}

Så når man trykker på en knap så skulle databasen bruger se sådan her ud.
æblet koster 10Penge
Bruger{
id = 1
brugernavn = Leo
æble = 1
penge = 90
}

UPDATE bruger SET penge = penge - 10, æble = æble +1

But I would never have a table like that.

Waht if you wanted to buy an orange?

You would have this maybe

Bruger{
id = 1
brugernavn = Leo
penge = 100
}




tblItems{
id = 1
item = apple
pris 10
}



tblBrugerItems{
Brugerid = 1
ItemId = 1
Antal  = 1
Pris = 10 'This is because the price might change in th emain table but thsi is what the user paid
}

Så laver jeg bare et nyt felt i databasen der hedder:
orange og retter update koden til orange i stedet for æble.

Bare det virker så tænkt ikke mere over det. :)

Det virker. Tak for hjælpen..:D

Lige et extra spørgesmål.
Hvorfor skriver du engsk når du kan dansk:S

and a cola .....

Thats not the correct way to make a database :o)

Jeg er ikke ret god til at skrive på dansk, og det går ret langsomt :o)

anyway thanks for the points, have a good day

Så øv dig?

Bare det virker så tænkt ikke mere over det. :)

:o)

But I should, your right

:P