php/mysql problem

Anon

I have problems with php/mysql. When I try to insert a new value into a table the old value is removed and then the new is inserted. I haven't foud any errors from my code.

Here is the table structure:
CREATE TABLE category (
id TINYINT DEFAULT '0' NOT NULL AUTO_INCREMENT,
name VARCHAR(20) NOT NULL,
PRIMARY KEY (id));

And here is the insert query;
INSERT INTO category (name) VALUES('$value');

Thanks for your help.

khaine

What does your code look like?? If you post the code that does the insert it will be easier to help.

Mark.

Anon

Here is the code which should add a new entry to the table:

$db = new db;
$db->connect($dbhost, $dbuser, $dbpass, $dbname);

$values = array(
"category" => "INSERT INTO category (name) VALUES('value1');",
"category" => "INSERT INTO category (name) VALUES('value2');");

while (list($k, $v) = each($values)) {
echo "Inserting data into $k...";
if ($db->query($v)) {
echo "OK";
}
else {
echo "Failed";
}
}

The problem isn't $db-object because it works fine else where.

khaine

The only thing that springs to mind is make sure that what you think you are quering as what is actually being queried. Display $v before the query just to make sure.

Mark.

Anon

hello markus,

mark is right -
i tried your table and some inserts
on my machine and it worked fine

chris

[deleted]

It's probably the tinyint he used for the auto_increment.
After 127 inserts the tinyint has used all it's 127 possible values and it will stay at 127, thus overwriting the old record.

This proves again that MySQL is a piece of sh*t because it should refuse to add the record and give an error saying that the auto_increment sequence is full.

alter your table and change the tinyint to an INT (not smallint, not mediumint, INT). (and curse the idiot who invented the tinyint, it's useless)

Anon

good idea!

chris