Help Understanding Code Not Working
Posted: Sun Dec 18, 2011 12:34 pm
Hello,
Below is code that is not allowing some data to show on screen, and also not inserting data to database. But first I would like to correct the data not showing to screen and possibly that will solve my other issue. What thing I do not understand, is the below code works fine on a server running on (Linux 2.6.18-374.3.1.el5.lve0.8.44), (MySQL 5.0.92-community), and (PHP Version: 5.2.17 (Zend: 2.2.0)).
Code does not work correctly on (Linux 2.6.18-274.3.1.el5.centos.plus), (MySQL 5.0.77), (PHP Version: 5.1.6 (Zend: 2.1.0)), Just curious why it does not work here? Would like to know for my knowledge.


Thank you JR
Below is code that is not allowing some data to show on screen, and also not inserting data to database. But first I would like to correct the data not showing to screen and possibly that will solve my other issue. What thing I do not understand, is the below code works fine on a server running on (Linux 2.6.18-374.3.1.el5.lve0.8.44), (MySQL 5.0.92-community), and (PHP Version: 5.2.17 (Zend: 2.2.0)).
Code does not work correctly on (Linux 2.6.18-274.3.1.el5.centos.plus), (MySQL 5.0.77), (PHP Version: 5.1.6 (Zend: 2.1.0)), Just curious why it does not work here? Would like to know for my knowledge.
Code: Select all
<?php
if (isset($_POST['Update']))
{
$sppc_query_raw = "select * from " . TABLE_CUSTOMERS_GROUPS . " order by customers_group_id";
$sppc_query = tep_db_query($sppc_query_raw);
while( $sppc = tep_db_fetch_array( $sppc_query ) ) {
if ($sppc["customers_group_name"] != "Retail"){
//$sppc['customers_group_id']
$c = "CG_".$sppc['customers_group_id'];
$tmp = $_POST[$c];
if ($tmp != 0)
{
$p = (100-$_POST[$c])/100;
tep_db_query("delete from products_groups where customers_group_id = ".$sppc['customers_group_id']);
tep_db_query ("insert into products_groups select '". $sppc['customers_group_id'] ."' as customers_group_id, ( " . $p . " * p.products_price) as customers_group_price, p.products_id from products p");
} //if not 0
} //if not Retail
}
}
?>
<!-- body //-->
<table border="0" width="100%" cellspacing="2" cellpadding="2">
<tr>
<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft">
</table></td>
<!-- body_text //-->
<td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
<tr>
<td width="100%"><table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td class="pageHeading"><?php echo "Special Pricing Discount Setup"; ?></td>
<td class="specialPrice" align="right"> </td>
</tr>
</table></td>
</tr>
<tr>
<td><table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td valign="top"><table border="0" width="100%" cellspacing="2" cellpadding="2">
<tr class="dataTableHeadingRow">
<td class="dataTableHeadingContent" align="left">
<?php
if (isset($_POST['Update']))
{
echo "<center>Updated!</center>";
}
?>
</td>
</tr>
<?php
$sppc_query_raw = "select * from " . TABLE_CUSTOMERS_GROUPS . " order by customers_group_id";
$sppc_query = tep_db_query($sppc_query_raw);
while( $sppc = tep_db_fetch_array( $sppc_query ) ) {
?>
<tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)">
<td class="dataTableContent" align="left">
<?php
if ($sppc["customers_group_name"] != "Retail"){
echo $sppc["customers_group_name"];
}
if (isset($_POST['Update']))
{
if ($sppc["customers_group_name"] != "Retail"){
$c = "CG_".$sppc['customers_group_id'];
$tmp = $_POST[$c];
echo " Current Discount is $tmp%" ;
}
}
?>
</td>
</tr>
<?php
}
?>
</table></td>
</tr>
<tr>
<td valign="top">
<form action="" method="post">
<table border="0" width="40%" cellspacing="0" cellpadding="2">
<tr>
<td class="smallText" align="left"> </td>
<td> </td>
</tr>
<?php
$sppc_query_raw = "select * from " . TABLE_CUSTOMERS_GROUPS . " order by customers_group_id";
$sppc_query = tep_db_query($sppc_query_raw);
while( $sppc = tep_db_fetch_array( $sppc_query ) ) {
if ($sppc["customers_group_name"] != "Retail"){
?>
<tr>
<td class="smallText" align="left">Set New Percentage (%) Discount for <?=$sppc["customers_group_name"]?> :</td>
<td><input name="CG_<?=$sppc['customers_group_id']?>" type="text" size="5" value="0"></td>
</tr>
<?php
}
}
?>
<tr>
<td colspan="2" align="center"><input type="submit" name="Update" value="Update"></td>
</tr>
</table>
</form>
</td>
</tr>
</table></td>
<!-- body_text_eof //-->
</tr>
</table>
<!-- body_eof //-->

Thank you JR