Update Number in Mysql

[Paris_Holley]

the default value would be O.

How would i make it so that everytime a certain sql was ran on the database it would raise one....

[Pig]

That's a pretty vague question. If you just want to update a value, I would do something like this:

$result = mysql_query("SELECT col_name FROM table_name");
$row = mysql_fetch_row($result);
mysql_query("UPDATE table_name SET col_name='" . $row[0]++ . "');

[Weedpacket]

You could just UPDATE the table by SETting "myfield = myfield+1" WHERE whatever conditions apply.