Hello,
I am currently doing things that make a mysql value increase by one. I am wondering if there is a way to do it all in one statement instead of retieving it and then adding one like this:
$sql = SELECT number FROM table;
$chk= mysql_query($sql, $conn) or die(mysql_error());
$number = mysql_result($chk);
$number = $number + 1;
$sql = UPDATE table SET number = '$number';
blah blah
Is there some sort of way to do something like this?:
$sql = UPDATE table SET number++;