$con = mysql_connect("localhost", "root", "P0stgr3sql");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
$db_selected = mysql_select_db("testt",$con);
echo'
';
$data_set_id = 105;
$col7 = ' ';
for($j=1;$j<=2;$j++)
{
if($j == 1)
{
$col7 = ',col7';
}
else
{
$col7 = ' ';
}
$results= mysql_query('SELECT `col1`,`col2`,`col3`,`col4`,`col5`,`col6`,`col7`,`level`,S.subtitle FROM overview_data_sets3 O, data_set_subtitles S where O.data_set_id=S.data_set_id AND
O.report_section=S.report_section AND O.report_section='.$j.' AND O.data_set_id='. $data_set_id. ' order by `group`,`level` ' );
$row1 = mysql_fetch_array($results);
echo'';
echo '| '.$row1["subtitle"].' | ';
echo '
';
mysql_data_seek($results,0);
$column = array();
for($i = 0; $i < mysql_num_fields($results)-2; $i++)
{
$field_info = mysql_fetch_field($results, $i);
$column_labels= mysql_query('SELECT `column_name`,`column_name_value` FROM `data_set_labels` where `data_set_id`='. $data_set_id);
while($column_key_value = mysql_fetch_array($column_labels))
{
$names= $column_key_value["column_name"];
$column[$names] = $column_key_value["column_name_value"];
}
$name = $field_info->name;
echo ''.$column[$name].' | ';
}
$rc = 0;
while (($row = mysql_fetch_array($results)))
{
if ($rc % 2 == 1)
{
$tr = '#ffffff';
}
else
{
$tr = '#ffccff';
}
echo'';
$level = $row["level"];
if($level == 2)
{
echo '| '.$row["col1"].' | ';
}
else{
echo ''.$row["col1"].' | ';
}
echo ''.$row["col2"].' | ';
echo ''.$row["col3"].' | ';
echo ''.$row["col4"].' | ';
echo ''.$row["col5"].' | ';
echo ''.$row["col6"].' | ';
echo ''.$row["col7"].' | ';
$rc++;
echo '
';
}
}
$title= mysql_query('SELECT main_title_name_display FROM data_set_titles where data_set_id ='. $data_set_id );
while($row_title = mysql_fetch_array($title))
{
echo ''. $row_title["main_title_name_display"].'
';
}
$note_result= mysql_query('SELECT note_name FROM note_entry where data_set_id ='. $data_set_id );
while($note = mysql_fetch_array($note_result))
{
echo'';
echo '| '. $note["note_name"].' | ';
echo '
';
}
