Zeile erweitern

[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 :/

[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