Firefox fails to display form content from mysql

Thanks Burak Ueda. I have no style definitions for the id "cel_blb". As you can see the cell in question has the style "top_cell" applied to it, as do the other form elements. On my .css page "top_cell" simply reads:

.top_cell {

    vertical-align: top;

}

Sorry about the delay, Sudarsham.

There is a difficulty with both of your suggestions. I am reluctant to give public access, even on this forum, to this area of my website because someone could maliciously interfere with the contents of the database. It is therefore a protected by password. Because of this restricted access I find the Adobe BrowserLab is unable to link to the page. All a bit frustrating.

Thanks for trying to help.

I am bewildered as to why this one textarea is behaing differently to the other on the same page.

Bingo! Yes, the textarea performs well in ff4, but not in ff11 safe-mode.

I'm not sure what you mean by "DB Schema" but I guess it might be the tabel below.  Let me know if not.

You'll see cel_blb third from bottom.

Many thanks for your help.

Message was edited by: smiffy47to improve the image quality.

Thanks for following this up, Sudarshan.

Your 2 suggestions in the previous post yielded no improvement.

I post below the portion of the webpage that precedes the form quoted above.  I wonder if the use of TinyMCE is causing the problem.

<?php require_once('../../Connections/tormented3.php'); ?>

<?php

function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")

{

  $theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;

  switch ($theType) {

    case "text":

      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";

      break;   

    case "long":

    case "int":

      $theValue = ($theValue != "") ? intval($theValue) : "NULL";

      break;

    case "double":

      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";

      break;

    case "date":

      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";

      break;

    case "defined":

      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;

      break;

  }

  return $theValue;

}

$editFormAction = $_SERVER['PHP_SELF'];

if (isset($_SERVER['QUERY_STRING'])) {

  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);

}

if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form1")) {

  $updateSQL = sprintf("UPDATE cel_contents SET cel_tel=%s, cel_fax=%s, cel_hlp=%s, cel_email=%s, cel_web=%s, cel_add=%s, cel_blb=%s, cel_hndts=%s WHERE cel_org=%s",

                       GetSQLValueString($_POST['cel_tel'], "text"),

                       GetSQLValueString($_POST['cel_fax'], "text"),

                       GetSQLValueString($_POST['cel_hlp'], "text"),

                       GetSQLValueString($_POST['cel_email'], "text"),

                       GetSQLValueString($_POST['cel_web'], "text"),

                       GetSQLValueString($_POST['cel_add'], "text"),

                       GetSQLValueString($_POST['cel_blb'], "text"),

                       GetSQLValueString($_POST['cel_hndts'], "text"),

                       GetSQLValueString($_POST['cel_org'], "text"));

  mysql_select_db($database_tormented3, $tormented3);

  $Result1 = mysql_query($updateSQL, $tormented3) or die(mysql_error());

}

if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form1")) {

  $updateSQL = sprintf("UPDATE chk_sixmonth SET ck_town=%s, ck_manager=%s, ck_contact=%s, ck_firstname=%s, ck_lastname=%s, ck_position=%s, ck_tel=%s, ck_email=%s, ck_notes=%s WHERE ck_organisation=%s",

                       GetSQLValueString($_POST['ck_town'], "text"),

                       GetSQLValueString($_POST['ck_manager'], "text"),

                       GetSQLValueString($_POST['ck_contact'], "text"),

                       GetSQLValueString($_POST['ck_firstname'], "text"),

                       GetSQLValueString($_POST['ck_lastname'], "text"),

                       GetSQLValueString($_POST['ck_position'], "text"),

                       GetSQLValueString($_POST['ck_tel'], "text"),

                       GetSQLValueString($_POST['ck_email'], "text"),

                       GetSQLValueString($_POST['ck_notes'], "text"),

                       GetSQLValueString($_POST['cel_org'], "text"));

  mysql_select_db($database_tormented3, $tormented3);

  $Result1 = mysql_query($updateSQL, $tormented3) or die(mysql_error());

}

if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form1")) {

  $updateSQL = sprintf("UPDATE passwords SET firstname=%s, email=%s WHERE organisation=%s",

                       GetSQLValueString($_POST['ck_firstname'], "text"),

                       GetSQLValueString($_POST['ck_email'], "text"),

                       GetSQLValueString($_POST['cel_org'], "text"));

  mysql_select_db($database_tormented3, $tormented3);

  $Result1 = mysql_query($updateSQL, $tormented3) or die(mysql_error());

}

$colname_rstUpEntry = "1";

if (isset($_GET['org'])) {

  $colname_rstUpEntry = (get_magic_quotes_gpc()) ? $_GET['org'] : addslashes($_GET['org']);

}

mysql_select_db($database_tormented3, $tormented3);

$query_rstUpEntry = sprintf("SELECT * FROM cel_contents WHERE cel_org = '%s'", $colname_rstUpEntry);

$rstUpEntry = mysql_query($query_rstUpEntry, $tormented3) or die(mysql_error());

$row_rstUpEntry = mysql_fetch_assoc($rstUpEntry);

$totalRows_rstUpEntry = mysql_num_rows($rstUpEntry);

$colname_rstSix = "1";

if (isset($_GET['org'])) {

  $colname_rstSix = (get_magic_quotes_gpc()) ? $_GET['org'] : addslashes($_GET['org']);

}

mysql_select_db($database_tormented3, $tormented3);

$query_rstSix = sprintf("SELECT * FROM chk_sixmonth WHERE ck_organisation = '%s'", $colname_rstSix);

$rstSix = mysql_query($query_rstSix, $tormented3) or die(mysql_error());

$row_rstSix = mysql_fetch_assoc($rstSix);

$totalRows_rstSix = mysql_num_rows($rstSix);

$colname_rstPass = "1";

if (isset($_GET['org'])) {

  $colname_rstPass = (get_magic_quotes_gpc()) ? $_GET['org'] : addslashes($_GET['org']);

}

mysql_select_db($database_tormented3, $tormented3);

$query_rstPass = sprintf("SELECT organisation, firstname FROM passwords WHERE organisation = '%s'", $colname_rstPass);

$rstPass = mysql_query($query_rstPass, $tormented3) or die(mysql_error());

$row_rstPass = mysql_fetch_assoc($rstPass);

$totalRows_rstPass = mysql_num_rows($rstPass);

?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<title>Admin  Data Update</title>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

<link href="../css/mentalhealth_admin.css" rel="stylesheet" type="text/css">

<title>TinyMCE Test</title>

<script language="javascript" type="text/javascript" src="../jscripts/tiny_mce/tiny_mce.js"></script>

<script language="javascript" type="text/javascript">

<!--

tinyMCE.init({

    // General options

    mode : "textareas",

    theme : "advanced",

    plugins : "safari,pagebreak,style,layer,table,save,advhr,advimage,advlink,emotions,iespell,inlinepo pups,insertdatetime,preview,media,searchreplace,print,contextmenu,paste,directionality,ful lscreen,noneditable,visualchars,nonbreaking,xhtmlxtras,template",

    // Theme options

    theme_advanced_buttons1 : "bold,italic,|,bullist,|",

    theme_advanced_buttons2 : "",

    theme_advanced_buttons3 : "",

    theme_advanced_buttons4 : "",

    theme_advanced_toolbar_location : "bottom",

    theme_advanced_toolbar_align : "left",

    theme_advanced_statusbar_location : "bottom",

    theme_advanced_resizing : true,

    // Replace values for the template plugin

    template_replace_values : {

        username : "Some User",

        staffid : "991234"

    }

});

function MM_findObj(n, d) { //v4.01

  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {

    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}

  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];

  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);

  if(!x && d.getElementById) x=d.getElementById(n); return x;

}

function MM_validateForm() { //v4.0

  var i,p,q,nm,test,num,min,max,errors='',args=MM_validateForm.arguments;

  for (i=0; i<(args.length-2); i+=3) { test=args[i+2]; val=MM_findObj(args[i]);

    if (val) { nm=val.name; if ((val=val.value)!="") {

      if (test.indexOf('isEmail')!=-1) { p=val.indexOf('@');

        if (p<1 || p==(val.length-1)) errors+='- '+nm+' must contain an e-mail address.\n';

      } else if (test!='R') { num = parseFloat(val);

        if (isNaN(val)) errors+='- '+nm+' must contain a number.\n';

        if (test.indexOf('inRange') != -1) { p=test.indexOf(':');

          min=test.substring(8,p); max=test.substring(p+1);

          if (num<min || max<num) errors+='- '+nm+' must contain a number between '+min+' and '+max+'.\n';

    } } } else if (test.charAt(0) == 'R') errors += '- '+nm+' is required.\n'; }

  } if (errors) alert('The following error(s) occurred:\n'+errors);

  document.MM_returnValue = (errors == '');

}

//-->

</script>

</head>

<body>

<table width="100%"  border="0" cellspacing="0" cellpadding="2">

  <tr>

    <td> </td>

    <td class="cellcolour"><h3>Admin Page - Content details</h3>

    </td>

    <td class="cellcolour"><h4><?php echo $row_rstUpEntry['cel_org']; ?> - Website Entry PK: <?php echo $row_rstUpEntry['cel_pk']; ?></h4></td>

    <td> </td>

  </tr>

  <tr>

    <td> </td>

    <td colspan="2" rowspan="10"><form name="form1" method="POST" action="<?php echo $editFormAction; ?>">

      <table width="100%"  border="0" cellspacing="0" cellpadding="2">

etc etc.

Thanks again for looking.

Yes, Disabling TinyMCE has allowed the textarea to function.  I apologise for not thinking of that earlier.

I will now (well perhaps tomorrow) attempt to update TinyMCE.  It's ages since I set it up originally, and will have to study how it functions again.

I will post my outcome when I have completed the job.

I've been experimenting with the new version of TimyMCE and  initially the new 3.5b3 version made no apparent difference (ie the offending textarea still failed to function whilst the second textarea behaved fine)

I then wondered if there was a problem with having two textareas using a text-editor in one form.  To try this out I deleted the second textarea, which has always functioned fine.  Hey presto, the first textarea sprang into life!  So it appears that whilst I have previously been able to run two (tinyMCE) editable textareas in one form on Firefox I can now only run one.  Does this seem likely to you?

I can see that this maybe turning into an issue for the TinyMCE Forum. .  .