Skip to main content
Known Participant
April 9, 2012
Question

Firefox fails to display form content from mysql

  • April 9, 2012
  • 2 replies
  • 2599 views

Firefox 11 is failing to display text from a mysql dbase.  Within the form there are various text boxes and text areas that function correctly, but one text area that remains inert. No content from the dbase and will not display flashing curser. It functions OK in IE8.  I can see no reason for this.  Can you?

The code of the whole code is quoted below. I have enboldened the relevant miscreant line.

:

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

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

        <tr>

          <td width="20%" class="right_cell">**Name of Organisation or Service:</td>

          <td colspan="4"><input name="cel_org" type="text" id="cel_org" onBlur="MM_validateForm('textfield','','R','textarea','','R');return document.MM_returnValue" value="<?php echo $row_rstUpEntry['cel_org']; ?>" size="60" maxlength="60">

      Town

        <input name="ck_town" type="text" id="ck_town" value="<?php echo $row_rstSix['ck_town']; ?>" size="20" maxlength="20"></td>

        </tr>

        <tr>

          <td class="right_cell">Telephone Number: </td>

          <td colspan="4"><input name="cel_tel" type="text" id="cel_tel" value="<?php echo $row_rstUpEntry['cel_tel']; ?>" size="30"></td>

        </tr>

        <tr>

          <td class="right_cell">Fax Number : </td>

          <td colspan="4"><input name="cel_fax" type="text" id="cel_fax" value="<?php echo $row_rstUpEntry['cel_fax']; ?>"></td>

        </tr>

        <tr>

          <td class="right_cell">Helpline Number :</td>

          <td colspan="4"><input name="cel_hlp" type="text" id="cel_hlp" value="<?php echo $row_rstUpEntry['cel_hlp']; ?>"></td>

        </tr>

        <tr>

          <td class="right_cell">Email address: </td>

          <td colspan="4"><input name="cel_email" type="text" id="cel_email" value="<?php echo $row_rstUpEntry['cel_email']; ?>" size="40"></td>

        </tr>

        <tr>

          <td class="right_cell">Website address:<br>

      Please use format www.etc.....</td>

          <td colspan="4"><input name="cel_web" type="text" id="cel_web" value="<?php echo $row_rstUpEntry['cel_web']; ?>" size="75" maxlength="100"></td>

        </tr>

        <tr>

          <td class="right_cell"><p>Address of Organisation:<br>

        (on single line) </p></td>

          <td colspan="4"><input name="cel_add" type="text" id="cel_add" value="<?php echo $row_rstUpEntry['cel_add']; ?>" size="75" maxlength="100"></td>

        </tr>

        <tr>

          <td class="right_cell"><p>**Description of your service:<br>

          </p></td>

          <td colspan="4" class="top_cell"><textarea name="cel_blb" cols="75" rows="8" id="cel_blb"><?php echo $row_rstUpEntry['cel_blb']; ?></textarea></td>

        </tr>

        <tr>

          <td class="right_cell">Message for email if there are handouts: </td>

          <td colspan="4" class="top_cell"><input name="cel_hndts" type="text" id="cel_hndts" value="<?php echo $row_rstUpEntry['cel_hndts']; ?>" size="100" maxlength="200"></td>

        </tr>

        <tr>

          <td class="right_cell"><h3>Contact Details</h3></td>

          <td colspan="4" class="top_cell"> </td>

        </tr>

        <tr>

          <td class="right_cell">Manager:</td>

          <td colspan="4" class="top_cell"><input name="ck_manager" type="text" id="ck_manager" value="<?php echo $row_rstSix['ck_manager']; ?>" size="35"></td>

        </tr>

        <tr>

          <td class="right_cell">Contact's Full name:</td>

          <td colspan="4" class="top_cell"><input name="ck_contact" type="text" id="ck_contact" value="<?php echo $row_rstSix['ck_contact']; ?>" size="35"></td>

        </tr>

        <tr>

          <td class="right_cell">First name:</td>

          <td colspan="4" class="top_cell"><input name="ck_firstname" type="text" id="ck_firstname" value="<?php echo $row_rstSix['ck_firstname']; ?>" size="35"></td>

        </tr>

        <tr>

          <td class="right_cell">Last name: </td>

          <td colspan="4" class="top_cell">

            <input name="ck_lastname" type="text" id="ck_lastname" value="<?php echo $row_rstSix['ck_lastname']; ?>" size="35">

          </td>

        </tr>

        <tr>

          <td class="right_cell">Contact's position:</td>

          <td colspan="4" class="top_cell"><input name="ck_position" type="text" id="ck_position" value="<?php echo $row_rstSix['ck_position']; ?>" size="35"></td>

        </tr>

        <tr>

          <td height="24" class="right_cell">Contact's tel:</td>

          <td colspan="4" class="top_cell"><input name="ck_tel" type="text" id="ck_tel" value="<?php echo $row_rstSix['ck_tel']; ?>" size="35"></td>

        </tr>

        <tr>

          <td class="right_cell">Contact's email: </td>

          <td colspan="4" class="top_cell"><input name="ck_email" type="text" id="ck_email" value="<?php echo $row_rstSix['ck_email']; ?>" size="45"></td>

        </tr>

        <tr>

          <td class="right_cell"> </td>

          <td colspan="4" class="top_cell"> </td>

        </tr>

        <tr>

          <td class="right_cell"> </td>

          <td colspan="4" class="top_cell"> </td>

        </tr>

        <tr>

          <td class="right_cell">My own notes: </td>

          <td colspan="4" class="top_cell"><textarea name="ck_notes" cols="75" rows="4" id="ck_notes"><?php echo $row_rstSix['ck_notes']; ?></textarea></td>

        </tr>

        <tr>

          <td class="right_cell">Confirm and Submit: </td>

          <td width="10%"><input type="submit" name="Submit" value="Submit">

          </td>

          <td width="22%"><a href="../index.htm">Return To Website</a></td>

          <td width="9%"><a href="chk_access.php?org=<?php echo $row_rstSix['ck_organisation']; ?>">Access</a></td>

          <td width="39%"><a href="chk_insert.php">List</a></td>

        </tr>

        <tr>

          <td class="right_cell">**These fields are required.</td>

          <td colspan="4"> </td>

        </tr>

        <tr>

          <td class="right_cell"> </td>

          <td colspan="4"> </td>

        </tr>

      </table>

      <input type="hidden" name="MM_update" value="form1">

    </form></td>

Any help most gratefully received.

This topic has been closed for replies.

2 replies

sudarshan.t
Inspiring
April 13, 2012

Try loading your site on http://browserlab.adobe.com and compare multi-browsers there. Let us know what the results are.

April 13, 2012

Do you have any style definitions for the id "cel_blb" ?

smiffy47Author
Known Participant
April 13, 2012

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;

}

sudarshan.t
Inspiring
April 14, 2012

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.


I guess there seems to be an issue with one or more of add-ons you've installed in Firefox. Did you also check in FF4 (without Safe Mode)?

Try doing the following:

First backup your Database, then try one of these 2 options:

1. Change your DB collation type to utf8_general

Check in FF11.

2. Change the type of cel_blb to text instead of mediumtext

Check in FF11.

See of either of these options work.

If not, let us know what character set you're using in your HTML header (post your HTML header if possible). Also, post a list of all your add-ons that you've installed on Firefox. In firefox, type about:addons in your addressbar to bring up the list of all add-ons.