cann't see any thing without your form! I think it is misstyping error, check your form variables name, specially upper case or lower case! but try $rank = $HTTP_POST_VARS[rank]; $title_new = $HTTP_POST_VARS[titles];
-- Sincerely your; pei_world ( .::IT::. ) "Peter Gumbrell" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Thanks to those who have helped me with my two other questions this > afternoon. > In the function below, the update query at the end is inserting empty values > into the database. For some reason the lines: > > > re not picking up the form values. > > Here is the complete function. I do not have a form action set so that I can > read the SQL message. The update query is working. > > > function retrieve_select_listing($link, $workshop, $session, $username) > { > $query_retrieve = "SELECT choice_ID, rank, workshop_id FROM choices_peter > WHERE workshop_ID = '$workshop' AND username ='$username'"; > $result1 = mysql_query($query_retrieve, $link) or die("display_db_query:" . > mysql_error()); > $row1 = mysql_fetch_array($result1); > $choice_id = $row1[0]; > $query_title = "SELECT title, CONCAT(sessionlet, sesnumber) AS SessionID > FROM ECOO2003 WHERE sessionlet = '$session'"; > $result2 = mysql_query($query_title, $link) or die("display_db_query:" . > mysql_error()); > while ($columns = mysql_fetch_array($result2)) > { > $column = $columns['title']; > $sessionid = $columns['SessionID']; > $selected = ""; > if ($sessionid == $row1['workshop_id']) > { > $selected = "SELECTED"; > } > $title_block .= "<OPTION name='title' value=\"$sessionid\" > $selected>$column</OPTION>\n"; > } > > > print "<tr><td colspan=\"4\">"; > $selected_session = $HTTP_POST_VARS['titles']; > print "<form method=\"POST\" name=\"update_workshop\" action=\"\">\n"; > > print "Change the rank of this workshop, or select another workshop from > this session and click the update button.<br><br></td></tr>"; > > print "<tr><td colspan=\"4\"><table border=\"1\" width=\"80%\">"; > print "<tr><th>workshop</th><th>Rank</th><th>Workshop Title</th></tr>"; > print "<tr><td>$row1[2]</td><td><input type = \"text\" name =\"rank\" > value=$row1[1]></td><td><SELECT > NAME=\"titles\">$title_block</SELECT></td></tr>\n"; > print "<tr><td colspan =\"3\">"; > print "<input type=\"hidden\" name=\"update_select\" value=\"v\">"; > print "<br>After you have made your changes, click the Update button to > confirm these.<br></td></tr><tr><td>"; > print "<INPUT TYPE=\"Submit\" NAME=\"Submit\" Value=\"Update\"></td>"; > print "<td></td><td></td></tr>"; > > print "</table>"; > print "</form>"; > > > if ($_POST['Submit']=='Update') > { > print "updated!!"; > $rank = $HTTP_POST_VARS['rank']; > $title_new = $HTTP_POST_VARS['titles']; > print "rank =$rank<br>"; > print "title# = $title_new<br>"; > $query_update = "UPDATE choices_peter SET rank = '$rank', workshop_id = > '$title_new' WHERE choice_ID = '$choice_id'"; > $update = mysql_query($query_update, $link) or die("display_db_query:" . > mysql_error()); > > > } > } > > Many thanks > > Peter > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
