$s_sql = "select \t\r\n\t headingID, displayOrder, headingName\r\n\tfrom \r\n\t cms.cfg_howto_headings\r\n\tWHERE \r\n\t chapterID = {$i_chapterID} \r\n\torder by \r\n \tdisplayOrder, headingName"; $q_data = mysql_query($s_sql); if (!$q_data) { die_well(mysql_error()); } $s_headingText = ''; if (mysql_num_rows($q_data)) { $s_headingText = '<select id="headingID" name="headingID">' . "\n"; while ($rowData = mysql_fetch_row($q_data)) { $s_headingText .= '<option value="' . $rowData[0] . '">' . $rowData[1] . '. ' . $rowData[2] . '</option>' . "\n"; } $s_headingText .= '</select>' . "\n"; } else { $s_headingText .= '<input type="hidden" id="headingID" name="headingID" value="0">' . "\n"; } $s_html = $s_headingText; break; case "saveContent": $i_howtoID = intval(set_var("howtoID", 0)); $i_chapterID = intval(set_var("chapterID", 0)); $i_headingID = intval(set_var("headingID", 0)); $i_displayOrder = intval(set_var("displayOrder", 0)); $s_contentTitle = set_var("contentTitle", ""); $s_textContent = set_var("textContent", ""); $s_sql = "insert into cms.dyn_howto_content (howtoID, chapterID, headingID, displayOrder, howtoContent, contentTitle, addedDate)\r\n\tselect {$i_howtoID}, {$i_chapterID}, {$i_headingID}, {$i_displayOrder}, '{$s_textContent}', '{$s_contentTitle}', now();"; $s_html = $objhowTo->saveItem(2, $s_sql); break; case "getdetail": break; } echo $s_html;