[MySQL]Nächster auto_increment Wert?

[sECuRE]

Hi,

den momentanen Status der auto_increment-variable bekommst du so:

Code:

                $result = mysql_query("SHOW TABLE STATUS LIKE '".$tableName."'");
                if (!$result)
                        die("Error querying: ".mysql_error());
                $row = mysql_fetch_assoc($result);
                if (!$row)
                        die("Error: ".mysql_error());

                mysql_free_result($result);

                echo "Dein Wert: ".$row['Auto_increment'];

cu