include('dbcon.php'); $scno=$_GET['scno']; $seqno=$_GET['seq']; $Model=$_GET['Model']; $sqlstr=mysqli_query($conn,"SELECT * From PC_Item WHERE SC_No='$scno' AND PC_No='3' AND Seq_No='$seqno'"); $record=mysqli_fetch_array($sqlstr); $pricepc=$record['Price']; $sqlstr1=mysqli_query($conn,"Select * FROM SC_Item WHERE Sc_No='$scno' AND Seq_No='$seqno'"); $record1=mysqli_fetch_array($sqlstr1); $gspno=$record1['GSP_NO']; $sqlstr2=mysqli_query($conn,"Select * FROM Gsp_Bom_costing WHERE Internal='$gspno' "); $record2=mysqli_fetch_array($sqlstr2); $forkprice=$record2['loc_fork']; $hbprice=$record2['loc_hb']; $frameprice=$record2['loc_frame']; if($hbprice > 0) { $x=1; } else { $x=0; } if($forkprice > 0) { $y=1; } else { $y=0; } ?>
PC NO
-Seq
Model:
Percentage
Frame Components
F/Triangle
RR Triangle
LR Triangle
Top Tube
Down Tube
Seat Tube
Head Tube
BB
R/C Stay
L/C Stay
R/S Stay
L/S Stay
Frame Ends
Dual FT
Dual RT
Fork parts
if($forkprice == 0 OR $forkprice == "") { ?>
} else { ?>
} ?>
H/B Tubes
if($hbprice == 0 OR $hbprice == "") { ?>
} else { ?>
} ?>
Frame Bits Items
Bridge
Chain Guard Bracket
Brake Pivots
K/S Bracket
Cable Guide
Cable Stopper
Shock Mount
Seat Clamp
Tube Gusset
H-T-Bracket
T-T-Gusset
D-T-Gusset
C-B-Hub-Bracket
Br. Pivot Base
Br. Pivot Top