[darkcarnival]

hi,

im getting ready to add tables to my database for my script and i need to know how to set these:

SSEARCH_Keyword:ID,Name,URL,Description,Keyword
SSEARCH_Log:ID,Date,Keyword,Results
SSEARCH_Settings:Name,User,Pass,Email,Results

i got an idea on some of them but i just want to double check.thx.

[daynah]

something like this?

Code:

CREATE TABLE SSEARCH_Keyword(id int(5) primary key auto_increment, Name varchar(50) default 'No Name', URL varchar(200), Description text, Keyword varchar(20));

CREATE TABLE SSEARCH_Log(id int(5) primary key auto_increment, mydate datetime default 0, Keyword varchar(20), Results text);

CREATE TABLE SSEARCH_Settings(Name varchar(50) primary key, User varchar(50), Pass varchar(20), Email varchar(20), Results text);

This would be my guess... but since I don't know how you're using the data, or what you want to store for those fields, I'm not too sure you would want to use what I wrote. Feel free to modify it though.

[darkcarnival]

well its for a search engine script.i have a book that shows me how but it doesnt have what i needed to know.