Code on OSC port not working...Help please

[strelitzia]

I'm in the process of porting a module from OSC. I've managed to get to grips with the differences between zen structure and osc structure, and to date, a large amount of the port is complete. I have hit a brick wall with one particular section of code that is supposed to call 3 bits of info from the database, namely the products threshold, products name and products id, then display them, and give an option of editing or deleting the products. I have run the sql as a query in phpmyadmin and it returns the correct data, but it fails to display the output on screen in zen admin.

Code in question is:

  <?php    
            $gift = $db->Execute("select fg.*, p.products_id, pd.products_name from " . TABLE_CARROT . " fg, products p LEFT JOIN products_description pd ON (pd.products_id=fg.products_id)
            WHERE pd.language_id = '" . (int)$_SESSION['languages_id'] . "'    AND p.products_id = fg.products_id ORDER BY fg.threshold ASC");
            while (!$gift->EOF) {
                   
            echo '<form action="gift_add.php" method="GET"><tr>
            <td class="smallText">$<input type="text" size="4" name="threshold" value="'.$gift['threshold'].'"></td>
            <td class="smallText">'.$gift['products_id'].'</td>
            <td class="smallText">'.$freeGifts['products_name'].'</td> 
            <td><a href="gift_add.php?ID=' . $gift['products_id'] . '&action=delete">' . zen_image_button('button_delete.gif', 'Delete') . '</a>&nbsp;<a href="categories.php?pID=' . $gift['products_id'] . '&action=new_product">' . zen_image_button('button_edit.gif', 'Edit') . '</a></td>
            </tr></form>';
            $gift->MoveNext();    
            }
            ?>

I have been looking for a solution to this all day and can't find a fix....perhaps i'm missing something obvious.

Can anyone point me in the right direction to fix this??

Thanks in advance
Steve

[DrByte]

Try using the ->fields identifier:

$gift->fields['products_id']

[strelitzia]

Thanks a million Dr Byte. Worked a treat.
Now i can move on to fixing the next section of the port....making it display in admin/categories that it has been flagged as a gift.