title: having trouble with mysql UPDATE
body: <p>I have a submit button on the page submitting and it comes back blank and does not update , the echo is also blank.</p>
  
  <pre><code>&lt;?
      if (isset($_POST['submit'])) {
          $newtext = mysql_real_escape_string($_POST['text']);
          $doTextEdit = "UPDATE `$database_main`.`texts` SET `texts`.`text` = '$newtext' WHERE `texts`.`id` = '$sid' LIMIT 1" or die(mysql_error());
  
          $retval = mysql_query( $doArtistEdit, $main );
          if(! $retval )
          {
              die('Could not update data: ' . mysql_error());
          }
          header("Location: ".$_SERVER['HTTP_REFERER']);
          }
      ?&gt;
  </code></pre>
  
  <p>This is in the form code</p>
  
  <pre><code>    &lt;form action="&lt;?php echo $_SERVER['PHP_SELF']; ?&gt;" name="$ID" method="post"&gt;
          Song Name : &lt;input type="text" name="title" value="&lt;?php echo $row_song['title']; ?&gt;"&gt; by Artist Name :&lt;input type="text" name="artist" value="&lt;?php echo $row_artist['artist']; ?&gt;"&gt;&lt;br&gt;&lt;?php echo $sid; ?&gt;&lt;?php echo $database_main; ?&gt;&lt;?php echo $doTextEdit; ?&gt;
          Lyrics :&lt;br&gt;&lt;textarea name="text" cols="72" rows="20"&gt;&lt;?php echo str_replace("\n","\n",$row_Recordset1['text']); ?&gt;&lt;/textarea&gt;&lt;br&gt;
          &lt;input type="submit" name="editlyrics" value="Edit"&gt;&lt;/form&gt;
  </code></pre>