i am not sure if this can be done through a single mysql query, but it was attempted as follows:
// update test transactions table
$sql10 = "INSERT INTO
#insert integers counting from 0 here, per lead id.
$result10 = mysql_query_errors($sql10, $conn , __FILE__ , __LINE__ , true );
if this can be done only via php/mysql combined - how would this be achieved?