<?php
$host = "localhost"; //99% chances that this is the name of your server if not, change it.
$user = "submittal"; //define it with your values
$password = "test" ;
$database_name = "submittals";

//lets create a persistent connection
$connection = mysql_pconnect($host, $user, $password) or die(mysql_error()) ;

//select the database

$db = mysql_select_db($database_name, $connection ) or die( mysql_error() );
include "calcpowerdrops6cond.php";
$fp = fopen('export.csv', 'w');
$circuitsql="SELECT circuitopt.id AS 'ciroptid',wiringopt.id AS 'wiringoptid',wiringopt.wiringchar, wiringopt.wiringtext, 6conddata(wiringopt.id,circuitopt.id) as 'wires'
FROM circuitopt,wiringopt";
//echo $circuitsql;
$circuitresult=mysql_query($circuitsql);
$result=array();
$result[]=array("Circuiting Char", 'Cir Description', 'wires','Six Cond','Four Cond','Three Cond');
while($row=mysql_fetch_assoc($circuitresult))
{
	$soltn=calcpowerdrops($row[wiringoptid],$row[ciroptid]);
	$cirstring=$row[ciroptid] . $row[wiringchar];
	$result[]=array($cirstring,$row[wiringtext], $row[wires],$soltn[sixcond],$soltn[fourcond],$soltn[threecond]);
}

foreach ($result as $fields) {
    fputcsv($fp, $fields);
}
fclose($fp);

?>