Code: Select all
,Code: Select all
and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]
Hi I am trying to populate a table.... with the Jobcode on column one, column 1 thru 12 are months...
so it would display the forecast for each month for each jobcode.Code: Select all
/// Select job codes
$query_select_job_codes = oci_parse($c, "((SELECT JOB_CODE AS JOBCODE FROM GSI.PCTCOMP_ACC_VW WHERE ( PCT_DATE = TO_DATE('20070228000000','YYYYMMDDHH24MISS') ) AND ( PCT_COMP_CODE = '02' )) )");
$query_select_all = oci_parse($c, "SELECT * FROM FORECAST_INPUT");
echo
'<table>
<tr><td>Year: 20-- </td></tr>
<tr><TD></td><TD>Jan</td><td>Feb</td><TD>Mar</td><TD>Apr</td><TD>May</td><TD>June</td><TD>July</td><TD>Aug</td><TD>Sep</td><TD>Oct</td><TD>Nov</td><TD>Dec</td></tr>
<tr><TD>Job Code</td></tr>';
echo
/// Select forecast amounts
$query_select_forecast = oci_parse($c, "SELECT * FROM FORECAST_INPUT
WHERE JOBCODE = '%$jobcode%' ORDER BY JOBCODE ASC");
oci_execute($query_gsi);
while($res=oci_fetch_array($query_gsi))
{
$jobcode = $res['JOBCODE'];
echo '<tr><td>'.$jobcode.'</td><tr>';
oci_execute($query_select_forecast);
while($res=oci_fetch_array($query_select_forecast))
{
$forecast = $res['FORECAST'];
echo '<td>'.$forecast.'<td>';
}
echo 'jobcode';-Hyrum
Everah | Please use
Code: Select all
,Code: Select all
and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]