- priority: 5 --> 2
- summary: [Create PHP Code] doesn't include linefeeds fr. text fields --> [Create PHP Code] doesn't include newlines for text fields
[ Create PHP Code ] after editing a text field inserts superfluous spaces but no newlines, e.g.,
$sql = 'UPDATE `airtom1`.`browsertest` SET `changed` = \'2007-05-12 14:00:00\', `browser` = \'*ONLY* after deleting old cookies '
. ' now working with IE6 and Opera9 '
. ' but only for *one* login attempt '
. ' (using pma211).\' WHERE `browsertest`.`id` = 4 LIMIT 1;';
should be something like:
$sql = 'UPDATE `airtom1`.`browsertest` SET `changed` = \'2007-05-12 14:00:00\',
`browser` = \'*ONLY* after deleting old cookies\n'
. 'now working with IE6 and Opera9\n'
. 'but only for *one* login attempt\n'
. '(using pma211).\' WHERE `browsertest`.`id` = 4 LIMIT 1;';
_____
table structure:
CREATE TABLE `browsertest` (
`changed` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`id` mediumint(9) NOT NULL auto_increment,
`browser` mediumtext collate cp1250_czech_cs NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM
....