Hi,
Please help!! I am trying to join 3 tables and generate a repor that shows a list like this:
Part Number: XXXXX
Family Name: XXX
....
..
.
However, I can't even get past the select query coding. I don't know what is wrong with it. and i don't know how to generate a report like above..
<?PHP
$conn=pg_connect("dbname=wcheng port=5432");
if (!$conn) {echo "An error occured in connection. \n";exit;}
echo '<head><title>New Product Introduction Form';
echo '</title></head><body bgcolor=#ceefbd><center>';
echo '<br><h2>New Product Introduction Form</h2><br>';
echo '<br><h2>Part Number Information</h2><br>';
echo '</center>';
$result = pg_Exec($conn, "select part.family, family.pl, family.product_manager, family.npi_engineer, configuration.part_no, part.part_no_desc, part.bom, part.gross_weight, part.net_weight, configuration.depot_code, configuration.pilot_date, configuration.pilot_qty, configuration.production_date, configuration.cycle_time from
family inner join (configuration inner join part on configuration.part_no=part.part_no) on family.family_name=part.family where configuration.part_no="$part_no"");
list($family, $pl, $product_manager, $npi_engineer, $part_no, $part_no_desc, $bom, $gross_weight, $net_weight, $depot_code, $pilot_date, $pilot_qty, $production_date, $cycle_time)=pg_fetch_row($result);
<list> Part Number:<b><?print $part_no?></b>;
echo "Description: $part_no_desc";
echo "Depot Code: $depot_code";
echo "Family Name: $family_name";
echo "Product Lin: $pl";
echo "Product Manager: $product_manager";
echo "NPI Engineer: $npi_engineer";
echo "Bill of Material: $bom";
echo "Gross Weight: $gross_weight";
echo "Net Weight: $net_weight";
echo "Pilot Date: $pilot_date";
echo "Pilot Quantity: $pilot_qty";
echo "Production Date: $production_date";
echo "Cycle Time: $cycle_time";
echo '</body>';
?>
Please help!! I am trying to join 3 tables and generate a repor that shows a list like this:
Part Number: XXXXX
Family Name: XXX
....
..
.
However, I can't even get past the select query coding. I don't know what is wrong with it. and i don't know how to generate a report like above..
<?PHP
$conn=pg_connect("dbname=wcheng port=5432");
if (!$conn) {echo "An error occured in connection. \n";exit;}
echo '<head><title>New Product Introduction Form';
echo '</title></head><body bgcolor=#ceefbd><center>';
echo '<br><h2>New Product Introduction Form</h2><br>';
echo '<br><h2>Part Number Information</h2><br>';
echo '</center>';
$result = pg_Exec($conn, "select part.family, family.pl, family.product_manager, family.npi_engineer, configuration.part_no, part.part_no_desc, part.bom, part.gross_weight, part.net_weight, configuration.depot_code, configuration.pilot_date, configuration.pilot_qty, configuration.production_date, configuration.cycle_time from
family inner join (configuration inner join part on configuration.part_no=part.part_no) on family.family_name=part.family where configuration.part_no="$part_no"");
list($family, $pl, $product_manager, $npi_engineer, $part_no, $part_no_desc, $bom, $gross_weight, $net_weight, $depot_code, $pilot_date, $pilot_qty, $production_date, $cycle_time)=pg_fetch_row($result);
<list> Part Number:<b><?print $part_no?></b>;
echo "Description: $part_no_desc";
echo "Depot Code: $depot_code";
echo "Family Name: $family_name";
echo "Product Lin: $pl";
echo "Product Manager: $product_manager";
echo "NPI Engineer: $npi_engineer";
echo "Bill of Material: $bom";
echo "Gross Weight: $gross_weight";
echo "Net Weight: $net_weight";
echo "Pilot Date: $pilot_date";
echo "Pilot Quantity: $pilot_qty";
echo "Production Date: $production_date";
echo "Cycle Time: $cycle_time";
echo '</body>';
?>