By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,992 Members | 1,351 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,992 IT Pros & Developers. It's quick & easy.

beginner needs help

P: 1
Hi there

I have a MYSQL database which has the following table


CREATE TABLE `#__content` (
`id` int(11) unsigned NOT NULL auto_increment,
`title` varchar(100) NOT NULL default '',
`title_alias` varchar(100) NOT NULL default '',
`introtext` mediumtext NOT NULL,
`fulltext` mediumtext NOT NULL,
`state` tinyint(3) NOT NULL default '0',
`sectionid` int(11) unsigned NOT NULL default '0',
`mask` int(11) unsigned NOT NULL default '0',
`catid` int(11) unsigned NOT NULL default '0',
`created` datetime NOT NULL default '0000-00-00 00:00:00',
`created_by` int(11) unsigned NOT NULL default '0',
`created_by_alias` varchar(100) NOT NULL default '',
`modified` datetime NOT NULL default '0000-00-00 00:00:00',
`modified_by` int(11) unsigned NOT NULL default '0',
`checked_out` int(11) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`publish_up` datetime NOT NULL default '0000-00-00 00:00:00',
`publish_down` datetime NOT NULL default '0000-00-00 00:00:00',
`images` text NOT NULL,
`urls` text NOT NULL,
`attribs` text NOT NULL,
`version` int(11) unsigned NOT NULL default '1',
`parentid` int(11) unsigned NOT NULL default '0',
`ordering` int(11) NOT NULL default '0',
`metakey` text NOT NULL,
`metadesc` text NOT NULL,
`access` int(11) unsigned NOT NULL default '0',
`hits` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `idx_section` (`sectionid`),
KEY `idx_access` (`access`),
KEY `idx_checkout` (`checked_out`),
KEY `idx_state` (`state`),
KEY `idx_catid` (`catid`),
KEY `idx_mask` (`mask`)
) TYPE=MyISAM;



What i need to do is insert certain data from a text file in the format

#TITLE#Important Checklist For Starting A Business#/TITLE#
some text is here
#BREAK#
#TITLE#Building An Online Business Is Like Starting A Garden, You First Must Plant Your Seeds#/TITLE#
another lot of text here
#BREAK#


into the title, introtext (first 300 chracters of "some text is here etc") and fulltext (rest of "some text is here etc") fields, also the id field needs to increment


could someone write a script etc of what needs to happen, or is there some software that makes it easier, as i am just a beginner

many thanks
Dec 3 '06 #1
Share this Question
Share on Google+
2 Replies


ronverdonk
Expert 2.5K+
P: 4,258
You may be a beginner, but that does not relieve you from reading the Posting Guidelines at the top of this forum before you start a thread and comply with some simple rules laid down in there!!

Especially the part of enclosing shown code within php, code or html tags.

Ronald :cool:
Dec 3 '06 #2

ronverdonk
Expert 2.5K+
P: 4,258
This is not a coding factory where you can get code-made-to-measure. Try to start coding yourself. Then we can all have alook at it and help you further. But you have to start coding yourself.

Ronald :cool:
Dec 8 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.