Error Message although script executes

[vtaylor263]

Dear PHP Developers:

I am having a challenging time finding out why this script executes and displays an "Internal Server Error" message.

Here's the code:

$EnrolledDate = date("Y-m-d");
$AllottedTime = 3.00;
$AccumulatedTime = 0.00;
$Email = "[e-mail]";
$ItemNo = 154327;
$C_Date = date("Y-m-d H:i:s");

mysql_connect('IP','username','password') or die('Error: Unable to connect to the database server.');
mysql_select_db('conte5') or die('Error: Unable to select proper database.');

srand((double)microtime() * 1000000);
$Password = substr(md5(uniqid(rand())),0,10);

$ExecuteQuery = mysql_query("INSERT INTO Validation VALUES (Null, '$ItemNo', '$Email', '$Password', '$AllottedTime', '$AccumulatedTime', '$EnrolledDate', '$C_Date')") or die('Error: Unable to execute insertion query.');

mysql_close();

I am clueless at this point about the "Internal Server Error" message. Why does the script insert the values in the database and then display this error?

Any suggestions or code modification.

VT

[BeastRider]

Dunno fer sure, put try using a handle that is returned on the connection

// connect to the database
if(!($dbh=mysql_connect ("localhost",
                         "$user",
                         "$pass")))
  die("Cannot connect to the database");

// open the connected database
if (!mysql_select_db("$dbname",$dbh))
  die("Cannot open the database");

// do the query

if (!($result = mysql_query ($query, $dbh)))
  die("Cannot execute query against the database");

[vtaylor263]

I got it.

I had something at the bottom of the script that was creating problems.

VT