gaspower Posted December 10, 2011 Share Posted 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'); ?> Quote Link to comment https://forums.phpfreaks.com/topic/252879-help-echoing-out-the-sql/ Share on other sites More sharing options...
Pikachu2000 Posted December 10, 2011 Share Posted December 10, 2011 You haven't asked a question. What seems to be the problem? Quote Link to comment https://forums.phpfreaks.com/topic/252879-help-echoing-out-the-sql/#findComment-1296517 Share on other sites More sharing options...
gaspower Posted December 10, 2011 Author Share Posted 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 Quote Link to comment https://forums.phpfreaks.com/topic/252879-help-echoing-out-the-sql/#findComment-1296522 Share on other sites More sharing options...
gaspower Posted December 10, 2011 Author Share Posted 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 Quote Link to comment https://forums.phpfreaks.com/topic/252879-help-echoing-out-the-sql/#findComment-1296523 Share on other sites More sharing options...
Pikachu2000 Posted December 10, 2011 Share Posted 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? Quote Link to comment https://forums.phpfreaks.com/topic/252879-help-echoing-out-the-sql/#findComment-1296533 Share on other sites More sharing options...
gaspower Posted December 10, 2011 Author Share Posted 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 Quote Link to comment https://forums.phpfreaks.com/topic/252879-help-echoing-out-the-sql/#findComment-1296536 Share on other sites More sharing options...
Pikachu2000 Posted December 10, 2011 Share Posted 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? Quote Link to comment https://forums.phpfreaks.com/topic/252879-help-echoing-out-the-sql/#findComment-1296576 Share on other sites More sharing options...
gaspower Posted December 10, 2011 Author Share Posted 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. Quote Link to comment https://forums.phpfreaks.com/topic/252879-help-echoing-out-the-sql/#findComment-1296579 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.