About 24,582 results: "mysql_query"
Page 3 of 50
Filter Results
Sources
Languages
Filter Results
Try Search On








  1. 	$sSQL = "SELECT * FROM cart WHERE cartCompleted=0 AND cartSessionID='" .  session_id() . "'";
  2. 	$result = mysql_query($sSQL) or print(mysql_error());
  3. 			$sSQL .= " OR (cartCompleted=0 AND cartDateAdded<'" . date("Y-m-d H:i:s", time()-($delAfter*60*60*24)) . "')";
  4. 		$result = mysql_query($sSQL) or print(mysql_error());
  5. 			}
  6. 			if($delAfter != 0) mysql_query("DELETE FROM orders WHERE ordID IN (" . $delcart . ")") or print(mysql_error());
  7. 			mysql_query("DELETE FROM cart WHERE cartID IN (" . $delstr . ")") or print(mysql_error());
  8. 			mysql_query("DELETE FROM cartoptions WHERE coCartID IN (" . $delstr . ")") or print(mysql_error());
  9. 		}
  10. 		$sSQL = "SELECT cartProdID,SUM(cartProdPrice*cartQuantity) AS thePrice,SUM(cartQuantity) AS sumQuant,pSection,COUNT(cartProdID),pExemptions,pTax FROM products INNER JOIN cart ON cart.cartProdID=products.pID WHERE cartCompleted=0 AND cartSessionID='" . $thesessionid . "' GROUP BY cartProdID,pSection,pExemptions,pTax";
  11. 		$cdresult = mysql_query($sSQL) or print(mysql_error());
  12. 			$sSQL = "SELECT SUM(coPriceDiff*cartQuantity) AS totOpts FROM cart LEFT OUTER JOIN cartoptions ON cart.cartID=cartoptions.coCartID WHERE cartCompleted=0 AND cartSessionID='" . $thesessionid . "' AND cartProdID='" . $cdrs["cartProdID"] . "'";
  13. 			$cdresult2 = mysql_query($sSQL) or print(mysql_error());
  14. 					$sSQL = "SELECT topSection FROM sections WHERE sectionID=" . $thetopts;
  15. 					$result2 = mysql_query($sSQL) or print(mysql_error());


  1. 	$sql = "SELECT pass FROM users WHERE pass = '" . $pass . "' AND user = '" . $user ."' AND user_level = 9 ";
  2. 	$res = mysql_query($sql);
  3. 	$sql = "SELECT pass FROM users WHERE pass = '" . $pass . "' AND user = '" . $user ."' AND user_level = 2 ";
  4. 	$res = mysql_query($sql);
  5. 	$sql = "UPDATE users SET pass = '" . $new_password . "' WHERE user = '" . $user . "'";
  6.  	$res = mysql_query($sql);
  7. 	$sql = "SELECT user FROM users WHERE user = '" . $user ."' ";
  8. 	$res = mysql_query($sql);
  9. 	$sql = "UPDATE users SET last_active = '" . $last_active . "' WHERE user = '" . $user . "' ";
  10. 	$res = mysql_query($sql);
  11. 	$sql = "UPDATE env_settings SET site_url = '" . $url . "', admin_name = '" . $admin_name . "', admin_email = '" . $admin_email . "', site_mode = '" . $site_mode . "', listings_per_page = " . $listings_per_page . ", users_per_page = " . $users_per_page . ", listings_stored_path = '" . $listings_stored_path . "', users_stored_path = '" . $users_stored_path . "', site_name = '" . $site_name . "', description = '" . $description . "', keywords = '" . $keywords . "', site_lang = '" . $site_lang . "', site_template = '" . $site_template . "' ";		
  12. 	$res = mysql_query($sql);
  13. 	$sql = "DELETE FROM users WHERE id = " . $id . ""; 
  14. 	$res = mysql_query($sql);
  15. 	$sql = "UPDATE users SET user = '" . $user . "', email = '" . $email . "', first_name = '" . $first_name . "', last_name = '" . $last_name . "', phone = '" . $phone . "', alt_phone = '" . $alt_phone . "', fax = '" . $fax . "', address = '" . $address . "', city = '" . $city . "', state = '" . $state . "', zip = '" . $zip . "', user_level = '" . $user_level . "', admin_notes = '" . $admin_notes . "'  WHERE id = " . $id . "";		
  16. 	$res = mysql_query($sql);





  1. 
                        
  2. 		mysql_query("INSERT INTO `hs_hr_emp_reportto` VALUES ('012', '011', 1);");
  3. 
                        
  4. 		mysql_query("INSERT INTO `hs_hr_leavetype` VALUES ('LTY010', 'Medical', 1)");
  5. 
                        
  6. 		mysql_query("TRUNCATE TABLE `hs_hr_weekends`;");
  7. 		$this->assertTrue(mysql_query("INSERT INTO `hs_hr_weekends` (day, length) VALUES (1, 0);"), mysql_error());
  8. 		$this->assertTrue(mysql_query("INSERT INTO `hs_hr_weekends` (day, length) VALUES (2, 0);"), mysql_error());
  9. 		$this->assertTrue(mysql_query("INSERT INTO `hs_hr_weekends` (day, length) VALUES (3, 0);"), mysql_error());
  10. 		$this->assertTrue(mysql_query("INSERT INTO `hs_hr_weekends` (day, length) VALUES (4, 0);"), mysql_error());
  11. 		$this->assertTrue(mysql_query("INSERT INTO `hs_hr_weekends` (day, length) VALUES (5, 0);"), mysql_error());
  12. 		$this->assertTrue(mysql_query("INSERT INTO `hs_hr_weekends` (day, length) VALUES (6, 0);"), mysql_error());
  13. 		$this->assertTrue(mysql_query("INSERT INTO `hs_hr_weekends` (day, length) VALUES (7, 0);"), mysql_error());
  14. 
                        
  15. 		//Leave 1
  16. 		mysql_query("INSERT INTO `hs_hr_leave_requests` (`leave_request_id`, `leave_type_id`, `leave_type_name`, `date_applied`, `employee_id`) VALUES (10, 'LTY010', 'Medical', '".date('Y-m-d', time()+3600*24)."', '011')");
  17. 		mysql_query("INSERT INTO `hs_hr_leave` (`leave_request_id`, `leave_id`, `employee_id`, `leave_type_id`, `leave_date`, `leave_length_days`, `leave_length_hours`, `leave_status`, `leave_comments`) VALUES (10, 10, '011', 'LTY010', '".date('Y-m-d', time()+3600*24)."', 0.12, 1, 1, 'Leave 1')");





Back to Top