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 Code:
<?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> <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
Bookmarks