I believe your assumption is correct. VARCHAR is not the best datatype
suitable for indexing. I understand why you want to utilize this type,
so that you are not storing empty characters. I am assuming that the id
column is numerical in nature. In that case, make the data type INT.
This way it increments just a number and it only stores the amount of
i.e. : id INT NOT NULL auto_increment,
This should solve your problem, post again if not
gl -- Seth
> Here is the db table structure...
> CREATE TABLE demo_sessions (
> id varchar(255) NOT NULL auto_increment,
> ipaddy varchar(255) NOT NULL,
> date varchar(255) NOT NULL,
> PRIMARY KEY (id)
> Let me know if this is correct, I have a feeling that the varchar is my
> problem but I could be wrong.
> <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
>>column in your table denotes your primary key? After that, how is it
>>incremented? Is it auto or do you have some other form of it. I think
>>your code is correct so the error seems to be how the data ID is
>>gl -- Seth
>>>I am getting an error when inserting data into a mysql database table.
>>>is telling me that there is a duplicate entry in the database everytime
>>>gets 10 records inserted to the table, if I flush the table and try it
>>>it works fine. Is there some kind of limit on some tables? Here is the
>>>error php outputs once the table gets 10 records: Duplicate entry '10'
>>>Here is the code...
>>> $table = "demo_sessions";
>>> $sql_insert = "INSERT INTO $table (ipaddy,date) VALUES
>>>('$ipaddy','$date')" or die('Could not insert client info');
>>> $result = @mysql_query($sql_insert,$dbh) or die(MYSQL_ERROR());
>>>Any help on this would be great
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php