[Resolved] Premature end of script headers: c:/php/php.exe

[wxdqz]

When using a SQL query I get no errors if the fields selected are "text" fields. If I include a "number" field in the select script I get "Premature end of script headers: c:/php/php.exe" in my error log.

The script works great as long as no numeric fields are in the select line.

Has anyone else had this issue? What should I do to fix it?

$SQL="select Test_Date, SerialNumber, Part, Platform, Machine ";
///the above line works if no number fields are in it. If I put a number filed in it php bombs.

$SQL="$SQL from gagedata";
$SQL="$SQL where Test_Date = '$sent_datetime'";
$SQL="$SQL and";
$SQL="$SQL Machine like '$mach'";

$result=mssql_query($SQL);

/* How many rows were returned ? */
$returned=mssql_num_rows($result);
$returnedc=mssql_num_fields($result);

if ($table =="gagedata")
{
echo("<b>$returned rows found<br /> </b>\n");
echo("<b>$returnedc cols found<br /> From $plant, on $sent_datetime, Machine $mach </b>\n");
echo ("<table align=center border=\"2\" cellpadding=\"5\" cellspacing=\"2\" width='900'>");
$returnedc=$returnedc++;

// Go print out the field names
while($field=mssql_fetch_field($result))
{
echo ("<th> $field->name </th>");
}
echo ("</tr>\n");


// Now print out the rows
while($row=mssql_fetch_array($result))
{
echo("<tr>");
$i = 0;
while ($i < $returnedc)
{
echo("<td width 900 align=center>".$row[$i]."</td>");
$i++;
}
echo("</tr>");
}
echo("</table>");
}
else {
print "No Data available... Press browser back button.";
}
}//end if