Hi... i Have a database which stores websites... basically a search engine. I want to add bulk links by using INSERT but need some help with it. The only fields which need changing manually are:
link_name
link_url
link_desc
link_keywords

The two fields which need to autochange are
link_id (autoincrement)
link_email - i need this to auto increment by name.. for instist. email1@test.com
email2@test.com
email3@test.com......

The rest of the fields I want to remain static for all links I enter for a particular category.. and can change them when entering future links.


the here is my links table structure.

`link_id` int(6) unsigned NOT NULL auto_increment,
`cat_id` int(4) unsigned NOT NULL default '0',
`link_name` varchar(80) NOT NULL default '',
`link_url` varchar(100) NOT NULL default '',
`link_desc` text NOT NULL,
`link_keyword` varchar(150) NOT NULL default '',
`link_email` varchar(50) NOT NULL default '',
`link_val` char(3) NOT NULL default '',
`date` date NOT NULL default '0000-00-00',
`link_pop` char(3) NOT NULL default '',
`link_broken` char(3) NOT NULL default '',
`link_sendemail` char(3) NOT NULL default '',
`hits` int(5) NOT NULL default '5',
`rate` int(5) NOT NULL default '1',
`rating` int(8) NOT NULL default '9',
`exp_date` date NOT NULL default '0000-00-00',
`sponsorlogo` varchar(150) NOT NULL default ''

try searching the forums. Im sure there are tons of articles on this