Database broken?

[Anon]

hi all.

i am building an eshop right now. it worked perfectly since yesterday evening.
then i did some lil changes that do not
effect the database, but the script does only
add one entry to it. if i delete the one,
the script adds another.

$sql = "INSERT INTO shop (session,product,quantity) VALUES ('459285df47d146d123155037ed6740b3','2342_50_70','1')";

mysql_query( "$sql")

this is right, isn't it? the db connection
is already set.

thanks for any ideas about this problem!

fox

[nostradamus]

shouldn´t it be

mysql_query($sql)

and not

mysql_query("$sql")

?

[Anon]

thanks, but that's not the point.
i found something that could be the mistake.
the autoindex doesn't count and stands at
127. if i delete the last entry, it can
add one entry with id number 127. if i want
to add one more, it says: duplicate number
127 or something...

how can i tell the autoindex to go on?
it is an auto_increment field and worked
perfectly until number 127.

thanks for more ideas.

fox

[Anon]

i think i fixed it.
the auto_increment field was an tinyint(4).
i set it to int(4) now. seems to work.

fox