chrishutagalung Posted March 25, 2014 Share Posted March 25, 2014 Hi Folks, I am new here and I am building a dummy business application for my school project. So I am still learning from you guys and please guide me with what i have right now. So, I want to populate a dropdown list with rows that exists in my Oracle DB and that would be my COMPONENT_ID column. When i pull that component ID column and select one of them, I need to show the corresponding data that show progress from that particular item. So when i choose one of the ID, I need to show the rest of the column that is in the same row with that particular item. What i have right now is this. I am assuming this will only pull the component ID but it doesnt work either. So please help me... <?php $paint_parse = oci_parse($conn, 'SELECT HEAD_MARK FROM FABRICATION'); oci_execute($paint_parse, OCI_DEFAULT); // Count the number of occurence inside the table $result = array(); $numrows = oci_fetch_all($paint_parse, $result, null, null, OCI_FETCHSTATEMENT_BY_ROW); while ($row = oci_fetch_array($paint_parse, OCI_ASSOC)!= false){ $value = $row['HEAD_MARK']; echo "<option value = $value>$value</option>"; } ?> Link to comment https://forums.phpfreaks.com/topic/287260-progress-record-with-php-and-oracle/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.