Seite 1 von 1

Zeile erweitern

Verfasst: 18.02.2007 10:17
von Elvis
Morgen,
ich bin gerade was am Probieren und komme nciht weiter :/

dieser Abschnitt

Code: Alles auswählen

$sql = "UPDATE " . FORUMS_TABLE . "
SET forum_name = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumname']) . "', cat_id = $cat_id, forum_desc = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumdesc']) . "', forum_status = " . intval($HTTP_POST_VARS['forumstatus']) . ", prune_enable = " . intval($HTTP_POST_VARS['prune_enable']) . $field_value_sql. "
				WHERE forum_id = " . intval($HTTP_POST_VARS[POST_FORUM_URL]);
genauer gesagt in dieser Zeile

Code: Alles auswählen

SET forum_name = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumname']) . "', cat_id = $cat_id, forum_desc = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumdesc']) . "', forum_status = " . intval($HTTP_POST_VARS['forumstatus']) . ", prune_enable = " . intval($HTTP_POST_VARS['prune_enable']) . $field_value_sql. "
muß ich vor

Code: Alles auswählen

. $field_value_sql. "
dieses einfügen

Code: Alles auswählen

, forum_image = '" . str_replace("\'", "''", $HTTP_POST_VARS['forum_image']) . "', forum_image_new = '" . str_replace("\'", "''", $HTTP_POST_VARS['forum_image_new']) . "'
könnte mir jemand zeigen wie ich das machen muß ?

ich sehe nur noch Punkte, Kommata usw :/

Verfasst: 18.02.2007 11:17
von Julian87
Hi,

müsste dann so aussehen:

Code: Alles auswählen

SET forum_name = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumname']) . "', cat_id = $cat_id, forum_desc = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumdesc']) . "', forum_status = " . intval($HTTP_POST_VARS['forumstatus']) . ", prune_enable = " . intval($HTTP_POST_VARS['prune_enable']) , forum_image = '" . str_replace("\'", "''", $HTTP_POST_VARS['forum_image']) . "', forum_image_new = '" . str_replace("\'", "''", $HTTP_POST_VARS['forum_image_new']) . "'. $field_value_sql. "
Nur es könnte auch so sein, ist aus deiner Anleitung nicht wirklich ersichtlich:

Code: Alles auswählen

SET forum_name = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumname']) . "', cat_id = $cat_id, forum_desc = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumdesc']) . "', forum_status = " . intval($HTTP_POST_VARS['forumstatus']) . ", prune_enable = " . intval($HTTP_POST_VARS['prune_enable']) , forum_image = '" . str_replace("\'", "''", $HTTP_POST_VARS['forum_image']) . "', forum_image_new = '" . str_replace("\'", "''", $HTTP_POST_VARS['forum_image_new']) . "' . $field_value_sql. "
Weil normalerweise davor nen Leerzeichen gehört. ;)

Julian