Databridge V2 with MySQLi support IS Now Available!

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Notice: Undefined variable on form?

Notice: Undefined variable on form?

Thread began 3/23/2012 9:27 am by gary.brett434358 | Last modified 3/23/2012 1:29 pm by Jason Byrnes | 551 views | 2 replies |

3/23/2012 9:27 am | #1 gary.brett434358

Notice: Undefined variable on form?

Hi, I have a form used in several pages across my site. On one page however this form select field errors "Notice: Undefined variable: on line 391", the select list does appear and the form works but the error box always appears.

<?php
do {  
?>
                              <option value="<?php echo $row_WADADynListtblCaseType['CaseTypeID']?>"><?php echo $row_WADADynListtblCaseType['CaseTypeName']?></option>
                              <?php
} while ($row_WADADynListtblCaseType = mysql_fetch_assoc($WADADynListtblCaseType));
  $rows = mysql_num_rows($WADADynListtblCaseType);
  if($rows > 0) {
   mysql_data_seek($WADADynListtblCasetype, 0);
	 $row_WADADynListtblCaseType = mysql_fetch_assoc($WADADynListtblCaseType);
  }
?>

Line 391: mysql_data_seek($WADADynListtblCasetype, 0);

If I copy and paste the form to a different section on the page it works fine which has left me confused. Any ideas appreciated form is attached if it helps..

Attached Files

dh.zip

3/23/2012 12:09 pm | #2 gary.brett434358

Hi again, I have noticed that this is only an issue when the form is wrapped inside a table. If I move the select to inside the form but outside of the table it works fine, even using <td> is ok, its just table? Any ideas why this would be?

This works:

<tr><td>Product:</td><td>                            <select name="CaseType" style="width:200px" id="CaseType">
                            <option value="">Case Type</option>
                              <?php
do {  
?>
                              <option value="<?php echo $row_WADADynListtblCaseType['CaseTypeID']?>"><?php echo $row_WADADynListtblCaseType['CaseTypeName']?></option>
                              <?php
} while ($row_WADADynListtblCaseType = mysql_fetch_assoc($WADADynListtblCaseType));
  $rows = mysql_num_rows($WADADynListtblCaseType);
  if($rows > 0) {
      mysql_data_seek($WADADynListtblCasetype, 0);
	  $row_WADADynListtblCaseType = mysql_fetch_assoc($WADADynListtblCaseType);
  }
?>
                            </select></td></tr>

This doesnt:

<table><tr><td>Product:</td><td>                            <select name="CaseType" style="width:200px" id="CaseType">
                            <option value="">Case Type</option>
                              <?php
do {  
?>
                              <option value="<?php echo $row_WADADynListtblCaseType['CaseTypeID']?>"><?php echo $row_WADADynListtblCaseType['CaseTypeName']?></option>
                              <?php
} while ($row_WADADynListtblCaseType = mysql_fetch_assoc($WADADynListtblCaseType));
  $rows = mysql_num_rows($WADADynListtblCaseType);
  if($rows > 0) {
      mysql_data_seek($WADADynListtblCasetype, 0);
	  $row_WADADynListtblCaseType = mysql_fetch_assoc($WADADynListtblCaseType);
  }
?>
                            </select></td></tr></table>

Regards

Gary

3/23/2012 1:29 pm | #3 Jason ByrnesWebAssist

I dont see a problem in the code, i'll need to look at it a bit deeper to troubleshoot.

I have created a support ticket so we can look into this issue further.

To view and edit your support ticket, please log into your support history:
supporthistory.php

If anyone else is experiencing this same issue, please append to this thread.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.