Ajax and mysql

[eluser]theighost[/eluser]
Hi,

I need help, i will not go in the details of my problem, i will tell u just the script i want.

lets say i have a database and a table, in this table there is a column that takes only the values 1 and 0.

in the site if the value is 1 a green dot appears if its 0 then a red dot appears.

i need ajax or javascript to help me change the value of the column from 1 to 0 and from 0 to 1, just by clicking on the dot.

so the result is: when i click on the green dot the value of the database will be set to 0 and then the red dot appears and verso.

all that without refreshing the page.

btw i am using codeigniter so the method get will have to be changed with the uri segment or something like that!

really needed

regards!