'; foreach($_POST['tables'] AS $row) { echo(''); } ?>

Export Table Data
Field Delimiter:
Field Quoted With:
Export Type:	SQL Based CSV Based

'; echo(''); echo '

$tablecount = count($_POST['tables']);
	for($counter = 0; $counter < $tablecount; $counter++)
	{
		$table_query = @mssql_query('SELECT * FROM ' . $_POST['tables'][$counter] . ';') or die(throwSQLError('unable to retrieve table data'));
		while($row = mssql_fetch_array($table_query))
		{
			if(!isset($schema))
			{
				$schema = array();

foreach($row AS $key => $value)
					if(!is_int($key))
						$schema[] = $key;
			}

$values = array();
			foreach($schema AS $col)
                    if($quote == '\'')
                         $values[] = '\'' . str_replace('\'','\'\'',$row[$col]) . '\'';
                    else
                         $values[] = '"' . $row[$col] . '"';

if($_POST['exporttype'] == 'sql')
                    echo('INSERT INTO ' . $_POST['tables'][$counter] . ' (' . implode(',',$schema) . ') VALUES (' . implode(',',$values) . ");\n");
               else
                    echo(implode(',',$values) . "\n");

unset($values);
		}

unset($table_query,$row,$schema);
	}

echo '

'; echo '

'; echo ''; } include('inc/footer.php'); ?>