That did it. Thanks. I was missing the owner field. [EMAIL PROTECTED] said: > Quoting Ant <[EMAIL PROTECTED]>: > >> I want to use a mysql database for my address book. I have created the >> necessary table, but im not usre what fields need to be in the table. I >> have tried creating the following fields: nickname, email, lastname, >> firstname, label. Are these correct? Am I missing a field? >> >> >> ------------------------------------------------------- >> This sf.net email is sponsored by:ThinkGeek >> Welcome to geek heaven. >> http://thinkgeek.com/sf >> -- >> squirrelmail-users mailing list >> List Address: [EMAIL PROTECTED] >> List Archives: http://sourceforge.net/mailarchive/forum.php?forum_id)95 >> List Info: >> https://lists.sourceforge.net/lists/listinfo/squirrelmail-users >> >> > > > DROP TABLE IF EXISTS address; > CREATE TABLE address ( > owner varchar(128) NOT NULL default '', > nickname varchar(128) NOT NULL default '', > firstname varchar(128) NOT NULL default '', > lastname varchar(128) NOT NULL default '', > email varchar(128) NOT NULL default '', > label varchar(255) default NULL, > PRIMARY KEY (owner,nickname), > KEY firstname (firstname,lastname) > ) TYPE=MyISAM; > > > INSERT INTO address VALUES ('rcooper', 'LipLock', 'Britney', 'Spears', > '[EMAIL PROTECTED]', 'Yeah Baby'); > > Note the varchar sizes are probably not what is in standard SM, I think > the > defaults were a little too small for my needs IIRC. > > Hope this helps > Ron > > > > > > > > ------------------------------------------------------- > This sf.net email is sponsored by:ThinkGeek > Welcome to geek heaven. > http://thinkgeek.com/sf > -- > squirrelmail-users mailing list > List Address: [EMAIL PROTECTED] > List Archives: http://sourceforge.net/mailarchive/forum.php?forum_id=2995 > List Info: https://lists.sourceforge.net/lists/listinfo/squirrelmail-users >
------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf -- squirrelmail-users mailing list List Address: [EMAIL PROTECTED] List Archives: http://sourceforge.net/mailarchive/forum.php?forum_id)95 List Info: https://lists.sourceforge.net/lists/listinfo/squirrelmail-users
