Page 1 of 1

Increase the number...

Posted: Fri Aug 19, 2005 5:03 am
by ericburnard
sorry if this sounds like a simple question or i have asked it before but i have been away for 2 weeks and i think the sea washed away some of the php knowlage that i was storing in my ears :D

so ....

what i am wanting to do is -

1) get a record from a database table (can do)
2) increase that number by 1 (cant do)
3) display that new number in the text box.

i think i have to use the loop code thing but am not to sure.

Thanks again

Eric

Posted: Fri Aug 19, 2005 5:07 am
by timvw
Time to learn some SQL :p

Code: Select all

UPDATE mytable SET mycolumn=mycolumn+1, othercolumn='whazaaaaaaaaa' WHERE name='bernie'

Posted: Fri Aug 19, 2005 5:34 am
by ericburnard
Ohhhh is it that simple :D:D:D

thants great. i think i will have to set some time aside to learn all the functions :D

Thanks
eric

Posted: Fri Aug 19, 2005 7:48 am
by timvw
Be prepared to learn MUCH. Not alone do you need to learn php syntax, general algorithms and data structures but also html and sql. And yes, it takes a while to know them all ;)

Posted: Fri Aug 19, 2005 8:40 am
by raghavan20
hi timv, could you elobarate wot are the general algorithms and data structures you want a web developer to learn? cos, I am a masters student...i jus wanna c how much I hv learned all these years :wink: cheers