ich habe mit rex_form() ein Formular erstellt:
Code: Alles auswählen
<?php
$id = rex_request('id', 'int');
// Eintragsliste
if ($func == '') {
$list = new rex_list('SELECT id, titel, subtitel FROM '.$REX['TABLE_PREFIX'].'901_news', 200);
$imgHeader = '<a href="'. $list->getUrl(array('func' => 'add')) .'"><img src="media/metainfo_plus.gif" alt="add" title="add" /></a>';
$list->addColumn( $imgHeader, '<img src="media/metainfo.gif" alt="field" title="field" />', 0, array('<th class="rex-icon">###VALUE###</th>', '<td class="rex-icon">###VALUE###</td>') );
$list->setColumnParams( $imgHeader, array('func' => 'edit', 'id' => '###id###') );
$list->setColumnLabel('titel', 'Titel');
$list->setColumnLabel('subtitel', 'Subtitel');
$list->setColumnLayout (
'id',
array(
'<th class="rex-icon">###VALUE###</th>',
'<td class="rex-icon">###VALUE###</td>'
)
);
$list->setColumnParams('name', array('func' => 'edit', 'id' => '###id###'));
$list->show();
}
// Formular
elseif ($func == 'edit' || $func == 'add') {
$form = new rex_form($REX['TABLE_PREFIX'].'901_News',"Newssystem","id=".$id,"post",false);
$field = &$form->addTextField('titel');
$field->setLabel("Titel");
$field = &$form->addTextField('subtitel');
$field->setLabel("Subtitel");
$field = &$form->addTextAreaField('text');
$field->setLabel("Text");
$field = &$form->addTextField('teasertitel');
$field->setLabel("Teasertitel");
$field = &$form->addTextAreaField('teaser');
$field->setLabel("Teaser");
$field = &$form->addMediaField('img');
$field->setLabel("Bild");
$field = &$form->addMediaField('teaser_img');
$field->setLabel("Teaser Bild");
if($func == 'edit') {
$form->addParam('id', $id);
}
$form->show();
}
?>
Code: Alles auswählen
DROP TABLE IF EXISTS `%TABLE_PREFIX%901_news`;
CREATE TABLE IF NOT EXISTS `%TABLE_PREFIX%901_news` (
`id` int(11) NOT NULL auto_increment,
`titel` varchar(255) NOT NULL default '',
`subtitel` varchar(255) NOT NULL default '',
`text` text NOT NULL default '',
`teasertitel` varchar(255) NOT NULL default '',
`teaser` varchar(255) NOT NULL default '',
`teaser_img` varchar(20) NOT NULL default '',
`img` varchar(20) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM;
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in [...]/redaxo/include/classes/class.rex_sql.inc.php on line 370
Da scheint ja irgendein Fehler bei der MySQL-Abfrage zu sein...
EDIT: Fehler gefunden, die Groß und KLeinschreibung hat mich geärgert.
Gruß