Problem with dynamic field

I have a table where one field is dynamically linked to another table. In DataAssist, I created the pages, Insert, Update, Details and Results. The Results, details and update page are fine. The Insert Page is blank. Any clues?

a blank page means that a php error is occurring but error reporting is turned off.

to turn error reporting on, add the following code at line 1:

<?php

error_reporting(E_ALL);

ini_set('display_errors','on');

?>

once we know what the error is, we will be able to troubleshoot the cause.


NOTE: When attaching files, please compress the PHP file to a zip archive and attach the zip file.

Here is the error messages I'm receiving:

--------

Notice: Undefined variable: database_BLantern in /var/www/vhosts/brasslanternnantucket.com/httpdocs/newadmin/photos_insert.php on line 5 Notice: Undefined variable: BLantern in /var/www/vhosts/brasslanternnantucket.com/httpdocs/newadmin/photos_insert.php on line 5 Warning: mysql_select_db() expects parameter 2 to be resource, null given in /var/www/vhosts/brasslanternnantucket.com/httpdocs/newadmin/photos_insert.php on line 5 Notice: Undefined variable: BLantern in /var/www/vhosts/brasslanternnantucket.com/httpdocs/newadmin/photos_insert.php on line 7 Warning: mysql_query() expects parameter 2 to be resource, null given in /var/www/vhosts/brasslanternnantucket.com/httpdocs/newadmin/photos_insert.php on line 7

----------

I've attached the zip file.

Thanks.

move the code from line 11:

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

to line 1.

Presto! Thanks - all fixed.