List:General Discussion« Previous MessageNext Message »
From:sam rumaizan Date:May 22 2007 3:56pm
Subject:Mysql and Textarea
View as plain text  
   I'm just a php beginner.
  So please be patient with my stupid questions.
   
  What am I missing in this code that causing the function can’t update the textarea?
   
  Update button erase the old information from mysql database and replace it with nothing.
Basically it can’t read what is inside the Textarea box. Why??
   
  Read the highlighted code.
   
  <?php  
include ('./includes/header.html');
include( '../mysql_connect.php' );
  ?>
    </HEAD>
    <BODY>
    <TABLE ALIGN="center" BORDER="0" CELLSPACING="0" CELLPADDING="0">
      <TR ALIGN="center" VALIGN="middle">
        <TH ALIGN="center"><FONT SIZE="6" COLOR ="#310032">View
Existing Data</FONT></TH>
      </TR>
    </TABLE>
      <FORM METHOD="post" ACTION="ved.php">
<?php
$query = "SELECT DISTINCT Assign_Engineer FROM lo_data";
$result = mysql_query($query);
?>
    <BR /><BR />
    <CENTER>
      <SELECT NAME="R"><OPTION VALUE="NULL">Choose a Category:</OPTION>
<?php
while ($line = mysql_fetch_array($result))
{
    foreach ($line as $value)
    {
        echo"<OPTION VALUE='$value'";
    }
    echo ">$value</OPTION>";
}
?>
      </SELECT>
      <INPUT  TYPE="submit" NAME="Submit" VALUE="Submit Data"><BR /><BR
/>
<?php
if (isset($_REQUEST['save_assign_engineer'])) {
    $id = (int) $_REQUEST['save_assign_engineer'];
    $job_title =
mysql_real_escape_string($_REQUEST['Assign_Engineer'][' .$id . ']['Job_Title']);
    $sql = "
        UPDATE `lo_data`
        SET `Job_Title` = '" . $job_title . "'
        WHERE `ID` = " . $id;
    mysql_query($sql);
}
if (isset($_POST["R"])) {
    $result = mysql_query("SELECT * FROM  lo_data WHERE Assign_Engineer
='".$_POST["R"]."'");
}
?>
      <DIV STYLE="overflow:auto;">
        <TABLE  WIDTH="80" BORDER="1" CELLSPACING="1" CELLPADDING="3"
BORDERCOLOR="CDCB98">
          <THEAD>
            <TR STYLE="position: relative; top:
expression(this.offsetParent.scrollTop); background-color: #CDCB98;">
               <TH>ID</TH>
              <TH>Reference No</TH>
              <TH>Job Descriptions</TH>
              <TH>Category</TH>
              <TH>Assign Engineer</TH>
              <TH>Date Received</TH>
              <TH>Date Required</TH>
              <TH>Date Assigned</TH>
              <TH>Projected Completion Date</TH>
              <TH>Date Completed</TH>
              <TH>Manhour Spent</TH>
              <TH>Status</TH>
            </TR>
          </THEAD>
<?php
$num=mysql_num_rows($result);
echo $num;
while($row = mysql_fetch_array($result))
{
    echo "<TBODY>";
    echo "<TR VALIGN=\"TOP\" ALIGN=\"CENTER\">";
    echo "<TD>{$row['ID']}</TD>";
    echo "<TD>{$row['Ref_No']}</TD>";
    echo '<TD> <P><TEXTAREA NAME="Assign_Engineer[' . $row['ID'] .
'][Job_Title]" ROWS="10"
    COLS="40">'.$row['Job_Title'] .'</TEXTAREA>';
    echo " <BR />";
echo '<button type="submit" name="save_assign_engineer" value="' .
$row['ID'] . '" />Updaet data</button>
';
    echo "<TD>{$row['Category']}</TD>";
    echo "<TD>{$row['Assign_Engineer']}</TD>";
    echo "<TD>{$row['Date_Received']}</TD>";
    echo "<TD>{$row['Date_Required']}</TD>";
    echo "<TD>{$row['Date_Assigned']}</TD>";
    echo "<TD>{$row['ProjectedCompletionDate']}</TD>";
    echo "<TD>{$row['Date_Completed']}</TD>";
    echo "<TD>{$row['ManhourSpent']}</TD>";
    echo "<TD>{$row['Status']}</TD>";
    echo "</TR>";
    echo"</TBODY>";
}
  ?>




       
---------------------------------
Luggage? GPS? Comic books? 
Check out fitting  gifts for grads at Yahoo! Search.
Thread
Mysql and Textareasam rumaizan22 May
  • Re: Mysql and TextareaBaron Schwartz22 May
  • Re: Mysql and TextareaGerald L. Clark22 May
  • Re: Mysql and TextareaHank22 May