Advertisement
Guest User

Untitled

a guest
Jul 20th, 2017
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.18 KB | None | 0 0
  1.  
  2.  
  3. <?php
  4. /*
  5.  
  6. button "correct UPCs"
  7. new form, new node
  8. display current info for all order rows -> item #, item_desc, UPC, mfg color code
  9. submit button -> UPDATE query on outdoor_retail to plug in new UPC and color codes
  10. populate new upc error table with
  11. item #, current UPC, correct UPC, current MFG color code, correct mfg color code
  12.  
  13.  
  14. display upc error table
  15. checkboxes with delete button
  16. */
  17. include "outdoorkids_functions.php";
  18. include "sites/default/outdoorkids_sqllink.php";
  19.  
  20.  
  21.  
  22.  
  23.  
  24. $order_id = $_REQUEST["order_id"];
  25.  
  26. $query = SQL_QUERY_ODK20002("SELECT * FROM outdoor_orders WHERE order_id = '$order_id'");
  27.  
  28. $result = $query['result'];
  29.  
  30. //die(var_dump(mysql_num_rows($result)));
  31.  
  32. echo "step1";
  33.  
  34. while ($row = mysql_fetch_assoc($result)){
  35. echo "STEP2";
  36. }
  37.  
  38. echo "STEP3";
  39.  
  40.  
  41. FUNCTION SQL_QUERY_ODK20002($query){
  42. include "sites/default/outdoorkids_sqllink.php";
  43. $result = mysql_query($query,$connection) or die("Couldn't Execute query " . mysql_error() . " \$result: " . var_dump($result));
  44. $count = mysql_num_rows($result);
  45. $row = mysql_fetch_assoc($result);
  46. $return = array("result" => $result, "count" => $count, "row" => $row);
  47. return $return;
  48. }
  49.  
  50.  
  51.  
  52. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement