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 characters needed.
Advertising
i.e. : id INT NOT NULL auto_increment, This should solve your problem, post again if not gl -- Seth Jas wrote: > 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. > TIA > Jas > > <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > >>TIA -- >> >> >>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 >> > generated. > >>gl -- Seth >> >>Jas wrote: >> >> >>>I am getting an error when inserting data into a mysql database table. >>> > It > >>>is telling me that there is a duplicate entry in the database everytime >>> > it > >>>gets 10 records inserted to the table, if I flush the table and try it >>> > again > >>>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' >>> > for > >>>key 1 >>>Here is the code... >>>require '/home/web/b/bignickel.net/scripts/admin/db.php'; >>> $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 >>>TIA >>>Jas >>> >>> >>> >>> > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
