i got a big problem in auto increment in mysql

[marloagapay]

hello am a newbie sad to say but i got a big problem regarding to the auto increment.
i use innoDB for storage but somethinggoes wrong!
i dont know why.
whenever i input new data (such as name add and tel, member ID should increment by one) there is no data stored in my database. pls help me.

[sv3tli0]

Copy paste your code which is INSERTing the new data.
And check your database is your ID set to autoincrease

[dahi_man]

Hi, tell me, are you using phpmyadmin ?

If so, go to the structure of the table, have you checked the checkbox for the AUTO INCREMENT ?

If you have not, auto increment will not happen.

Check it and let us know.

[diafol]

without showing your code we have no idea what's going on. It may be totally unrelated to autoincrement. E.g. you may have misspelt a table or field in your query. Equally dirty input may be responsible.

[marloagapay]

<?php
include("connect.php");


mysql_select_db("db_library"); 

$sql = "select count 'tb_stugreg'";
$result = mysql_query($sql);
$next_increment = 0;
$qShowStatus = "SHOW TABLE STATUS LIKE 'tb_studreg'";
$qShowStatusResult = mysql_query($qShowStatus) or die(mysql_error());
$row = mysql_fetch_assoc($qShowStatusResult);
$next_increment = $row['autoincrement'];

 $sql = "insert into tb_studreg(id,fname,lname) values($next_increment,'$_POST[fname]','$_POST[lname]')";
 if (!$sql)
 {
     echo "error in saving";
 }
 else
 {
     echo "added";
 }


?>
</body>

</html>

[karthik_ppts]

Now what error you have got?
Please post your codes with code tag.

[decade]

your problem is not on your php code, it's your table was the problem.
your code to your table sould be like this. i haven't seen you created your table but you should check on your table.

well here is the code to fix that.

CREATE TABLE tb_studreg(
id int NOT NULL AUTO_INCREMENT,
fname varchar(255) NOT NULL,
lname varchar(255),
PRIMARY KEY (id)
)

then to your php code
you dont need this code so remove this code,

$next_increment = $row['autoincrement'];

in your insert code

$sql = "insert into tb_studreg(id,fname,lname) values($next_increment,'$_POST[fname]','$_POST[lname]')";

change this into

$sql = "insert into tb_studreg(fname,lname) values('".$_GET['fname']."','".$_GET['lname']."')";

is this code help you? click solve.