Printing data in one line

[chaturvedi]

Hello,

              I want to generate a csv file with some data from mysql. I have been successful in generating the file the code for which i am including below.

 

<?

 

session_start();

 

include("SessionCheck.php");

 

include("Connection.php");

 

 

    $stdt1=$_GET['sdate'];

 

  $enddt1=$_GET['edate'];

 

$empid=$_GET['eid'];

 

 

 

$s1="Select * from emp_master where emp_no='$empid'";

 

$r1=mysql_query($s1);

 

$row=mysql_fetch_row($r1);

 

$empnm=$row[1];

 

 

 

?>

 

 

<?

 

    $host = 'localhost'; 

    $csv_terminated = "\n";

    $csv_separator = ",";

    $csv_enclosed = '"';

    $csv_escaped = "\\";

 

$result = mysql_query("Select * from timeshiftentry_master where emp_no='$empid' and dt>='$stdt1' and dt<='$enddt1'");

$fields_cnt = mysql_num_fields($result);

 

    $schema_insert = '';

 

    for ($i = 0; $i < $fields_cnt; $i++)

    {

        $l = $csv_enclosed . str_replace($csv_enclosed, $csv_escaped . $csv_enclosed,

            stripslashes(mysql_field_name($result, $i))) . $csv_enclosed;

        $schema_insert .= $l;

        $schema_insert .= $csv_separator;         

 

    } // end for

 

 

    $out = trim(substr($schema_insert, 0, -1));

    $out .= $csv_terminated;

 

 

    // Format the data

    while ($row = mysql_fetch_array($result))

    {

        $schema_insert = '';

        for ($j = 0; $j < $fields_cnt; $j++)

        {

            if ($row[$j] == '0' || $row[$j] != '')

            {

               

                if ($csv_enclosed == '')

                {

                    $schema_insert .= $row[$j];

                } else

                {

                    $schema_insert .= $csv_enclosed .

str_replace($csv_enclosed, $csv_escaped . $csv_enclosed, $row[$j]) . $csv_enclosed;

 

                }

            } else

            {

                $schema_insert .= '';

            }

 

            if ($j < $fields_cnt - 1)

            {

                $schema_insert .= $csv_separator;

            }

        } // end for

 

        $out .= $schema_insert;

        $out .= $csv_terminated;

 

    } // end while

 

 

 

 

 

$filename = $file."_".date("Y-m-d_H-i",time());

header("Content-type: application/vnd.ms-excel");

header("Content-disposition: csv" . date("Y-m-d") . ".csv");

header( "Content-disposition: filename=".$filename.".csv");

print $out;

exit;

 

/*  $host = 'localhost'; 

    $csv_terminated = "\n";

    $csv_separator = ",";

    $csv_enclosed = '"';

    $csv_escaped = "\\";

 

$result = mysql_query("Select * from timeshiftentry_master where emp_no='$empid' and dt>='$stdt1' and dt<='$enddt1'");

$fields_cnt = mysql_num_fields($result);

 

    $schema_insert = '';

 

    for ($i = 0; $i < $fields_cnt; $i++)

    {

        $l = $csv_enclosed . str_replace($csv_enclosed, $csv_escaped . $csv_enclosed,

            stripslashes(mysql_field_name($result, $i))) . $csv_enclosed;

        $schema_insert .= $l;

        $schema_insert .= $csv_separator;         

 

    } // end for

 

 

    $out = trim(substr($schema_insert, 0, -1));

    $out .= $csv_terminated;

 

 

    // Format the data

    while ($row = mysql_fetch_array($result))

    {

        $schema_insert = '';

        for ($j = 0; $j < $fields_cnt; $j++)

        {

            if ($row[$j] == '0' || $row[$j] != '')

            {

               

                if ($csv_enclosed == '')

                {

                    $schema_insert .= $row[$j];

                } else

                {

                    $schema_insert .= $csv_enclosed .

str_replace($csv_enclosed, $csv_escaped . $csv_enclosed, $row[$j]) . $csv_enclosed;

 

                }

            } else

            {

                $schema_insert .= '';

            }

 

            if ($j < $fields_cnt - 1)

            {

                $schema_insert .= $csv_separator;

            }

        } // end for

 

        $out .= $schema_insert;

        $out .= $csv_terminated;

 

    } // end while

 

 

 

 

 

$filename = $file."_".date("Y-m-d_H-i",time());

header("Content-type: application/vnd.ms-excel");

header("Content-disposition: csv" . date("Y-m-d") . ".csv");

header( "Content-disposition: filename=".$filename.".csv");

print $out;

exit;*/

 

?>

 

and the table looks like following attachment[tres.jpg]

but i want that there should be one line for each project.

 

 

 

[attachment deleted by admin]

[chaturvedi]

what i actually want is that there is should be one line for a project with 30 cells for 30 days of months so that i can specify the workhours of the project...pls help its very urgent!!