increment by one help

[redarrow]

Advance thank you.

In my database i have added a field called clicks, each time a user submits new data i want that table clicks increment by one but haveing trouble please help.

[code]

if($_POST(["submit"]) {

$db=mysql_connect("localhost");
mysql_select_db("promotor", $db);
$query="INSERT INTO users VALUES('$id','$password','$score','$clicks');
$result=mysql_query($query);

while($clicks=mysql_fetch_assoc($result)) {
$clicks++;
}

[/code]

[redarrow]

Does this make sence cheers.

I wonder if theres a way to get the query to increment by one.
[code]

if($_POST(["submit"])) {

$db=mysql_connect("localhost");
mysql_select_db("promotor", $db);

$query="INSERT INTO users VALUES('$id','$password','$score','$clicks' where clicks='$clicks'+1);

$result=mysql_query($query);


}

[/code]

[litebearer]

I believe you want to use the UPDATE feature

ie
[code]
$result = mysql_query("UPDATE USERS SET click=click+'1' WHERE user = $some_user_id")
or die(mysql_error()); [/code]

might not be EXACTLY correct but it gives you the general idea - simply look in th ephp/mysql manual for UPDATE

LITE...

[redarrow]

sorry silly me the update was it, I need to no if the clicks=$clicks+'1' does the increment and keeps adding a 1 one to the total cheers.

[litebearer]

yep...

[!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--]
If you access a column from tbl_name in an expression, UPDATE uses the current value of the column. For example, the following statement sets the age column to one more than its current value:

UPDATE persondata SET age=age+1;
[/quote]

[a href=\"http://dev.mysql.com/doc/refman/5.0/en/update.html\" target=\"_blank\"]http://dev.mysql.com/doc/refman/5.0/en/update.html[/a]

Lite...

[redarrow]

[!--quoteo(post=375129:date=May 19 2006, 03:59 AM:name=litebearer)--][div class=\'quotetop\']QUOTE(litebearer @ May 19 2006, 03:59 AM) [snapback]375129[/snapback][/div][div class=\'quotemain\'][!--quotec--]
yep...
[a href=\"http://dev.mysql.com/doc/refman/5.0/en/update.html\" target=\"_blank\"]http://dev.mysql.com/doc/refman/5.0/en/update.html[/a]

Lite...
[/quote]
Thank you so much.

I read that topic a while back and got the book but forgot cheers.


[!--sizeo:5--][span style=\"font-size:18pt;line-height:100%\"][!--/sizeo--]soved[!--sizec--][/span][!--/sizec--]


ps. Thank you for your time.