Help Echoing Out The SQL

gaspower · December 10, 2011

Hello,

I have a PHP page (below) that is suppose to update a field in my database. For some reason it does not update. I am trying to echo that sql with this script. Any help would be greatly appreciated. Thanks JR

$p = (100-$_POST[$c])/100; 
        $sql = "delete from products_groups where customers_group_id = ".$sppc['customers_group_id']; 
        echo $sql;
	tep_db_query($sql); 
  
        $sql = "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"; 
        echo $sql;
	tep_db_query($sql);

Below is the complete code,

<?php
  require('includes/application_top.php');

?>
<!DOCTYPE html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS; ?>>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
<title><?php echo TITLE; ?></title>
<link rel="stylesheet" type="text/css" href="includes/stylesheet.css">
<script language="javascript" src="includes/general.js"></script>
</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF" onload="SetFocus();">
<div id="popupcalendar" class="text"></div>
<!-- header //-->
<?php require(DIR_WS_INCLUDES . 'template_top.php'); ?>
<!-- header_eof //-->


<?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 //-->
<!-- footer //-->
<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
<!-- footer_eof //-->
</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

Pikachu2000 · December 10, 2011

You haven't asked a question. What seems to be the problem?

gaspower · December 10, 2011

Hello,

Sorry, for some reason the file is not adding info to database table. So I am trying to echo out the sql statement to see any errors. The first script (above) I have here is what I tried in the bottom file to get it to echo out, but I get nothing. Did I forget something in the script. I can not figure out why the database table is not getting updated.

Thanks JR

gaspower · December 10, 2011

Hello,

I also did a log of mysql for that main file when I ran it. Not sure if it gives you any better details.

I did a mysql log, and below is the details. Not sure if that gives any information that will help solve this issue.

Thank you

111209 12:43:03 75 Connect user@localhost as anonymous on
75 Quit
111209 12:43:04 76 Connect database@localhost on
76 Init DB database
76 Query select configuration_key as cfgKey, configuration_value as cfgValue from configuration
76 Query select value from sessions where sesskey = '25101rbiah2jt45t85pjrfi852' and expiry > '13234 63384'
76 Query select configuration_group_id as cgID, configuration_group_title as cgTitle from configurat ion_group where visible = '1' order by sort_order
76 Query select * from customers_groups order by customers_group_id
76 Query select * from customers_groups order by customers_group_id
76 Query select * from customers_groups order by customers_group_id
76 Query select count(*) as total from sessions where sesskey = '25101rbiah2jt45t85pjrfi852'
76 Query update sessions set expiry = '1323464824', value = 'language|s:7:\"english\";languages_id|s :1:\"1\";admin|a:2:{s:2:\"id\";s:1:\"1\";s:8:\"username\";s:13:\"database\";}' where sesskey = '25101rbiah2jt45t85pjrf i852'
76 Quit
111209 12:43:05 77 Connect user@localhost as anonymous on

Pikachu2000 · December 10, 2011

Being that the queries are in conditionals, I'm thinking thats where the problem lies. Have you echoed the values to see if the conditionals are true?

gaspower · December 10, 2011

Hello,

I tried this in the above file, but it did not echo anything?

$p = (100-$_POST[$c])/100; 
        $sql = "delete from products_groups where customers_group_id = ".$sppc['customers_group_id']; 
        echo $sql;
	tep_db_query($sql); 
  
        $sql = "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"; 
        echo $sql;
	tep_db_query($sql);

Thanks JR

Pikachu2000 · December 10, 2011

I understand that, but did you echo the values in your if() conditionals to make sure they're what you'd expect them to be?

gaspower · December 10, 2011

Hello,

Sorry, new to this, and I quite do not understand. The only thing I tried to echo was what I listed. Sorry to ask, but are you asking to echo another portion?

Thank you for your time.

Sign In

Help Echoing Out The SQL

Recommended Posts

gaspower

Link to comment

Share on other sites

Pikachu2000

Link to comment

Share on other sites

gaspower

Link to comment

Share on other sites

gaspower

Link to comment

Share on other sites

Pikachu2000

Link to comment

Share on other sites

gaspower

Link to comment

Share on other sites

Pikachu2000

Link to comment

Share on other sites

gaspower

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information