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 wa
TECTED]
Subject: [PHP-DB] Re: never seen this before..
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 f
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.
TI
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 in
