About 23,759 results: "mysql_query"
Page 4 of 50
Filter Results
Sources
Languages
Filter Results
Try Search On







  1. 
                        
  2.             $result = mysql_query($sql);
  3.                 //delete cart
  4.                 mysql_query("DELETE FROM ticket_cart_details WHERE cart_id='".$row['id']."'") or die(mysql_error());
  5.                 mysql_query("DELETE FROM ticket_seat_booked WHERE cart_id='".$row['id']."'") or die(mysql_error());
  6.                 mysql_query("DELETE FROM ticket_carts WHERE id='".$row['id']."'") or die(mysql_error());
  7.             }
  8.             $userCountry = "select  user_details.c_id  , countries.country_name ,state.Name, user_details.state, user_details.city , CONCAT_WS(',',city_master.city_name,state.Name,countries.country_name) as CurrentLocation  from user_details LEFT JOIN  countries On  countries.id = user_details.c_id  LEFT JOIN state ON state.id = user_details.state LEFT JOIN city_master ON  user_details.city = city_master.city_id where user_details.user_id= ".$_SESSION['UserId']." ";
  9.             $userCountry_res = mysql_query($userCountry);
  10.                 $userCountry = "select  countries.id  , countries.country_name from countries Where countries.id = '6'";
  11.                 $userCountry_res = mysql_query($userCountry);
  12.         $userCountry = "select  IFNULL(countries.id,0) as countryId  ,  IFNULL(countries.country_name,'') as countryName  ,IFNULL(state.Name,'')as StateName, IFNULL(state.id,0) as StateId, IFNULL(city_master.city_id,0) as CityId , IFNULL(city_master.city_name,'')as CityName from countries LEFT JOIN state ON  state.c_id = countries.id  and state.id = ".$_REQUEST['province']." LEFT JOIN city_master ON  state_id = state.id and city_id = ".$_REQUEST['city']." where countries.id = ".$_REQUEST['country']."";
  13.         $userCountry_res = mysql_query($userCountry)or die(mysql_error());
  14.         $evtcat['0']="Select Category";
  15.         $select_ticket_cat = mysql_query("Select * from ticket_event_category");



  1. $peerlist_update = mysql_result(mysql_query("SELECT * FROM `options` WHERE `field_name` = 'refresh_realtime_peerlist' LIMIT 1"),0,"field_data");
  2. $queue_update = mysql_result(mysql_query("SELECT * FROM `options` WHERE `field_name` = 'refresh_realtime_queue' LIMIT 1"),0,"field_data");
  3. $server_hash_code = mysql_result(mysql_query("SELECT * FROM `options` WHERE `field_name` = 'server_hash_code' LIMIT 1"),0,"field_data");
  4. 
                        
  5. {
  6. $max = mysql_result(mysql_query("SELECT * FROM `options` WHERE `field_name` = 'max_active_peers' LIMIT 1"),0,"field_data");
  7. $new = mysql_result(mysql_query("SELECT * FROM `options` WHERE `field_name` = 'max_new_peers' LIMIT 1"),0,"field_data");
  8. $domain = mysql_result(mysql_query("SELECT * FROM `options` WHERE `field_name` = 'server_domain' LIMIT 1"),0,"field_data");
  9. $subfolder = mysql_result(mysql_query("SELECT * FROM `options` WHERE `field_name` = 'server_subfolder' LIMIT 1"),0,"field_data");
  10. $port = mysql_result(mysql_query("SELECT * FROM `options` WHERE `field_name` = 'server_port_number' LIMIT 1"),0,"field_data");
  11. $trans_queue_hash = mysql_result(mysql_query("SELECT * FROM `options` WHERE `field_name` = 'transaction_queue_hash' LIMIT 1"),0,"field_data");
  12. $block_check_start = mysql_result(mysql_query("SELECT * FROM `options` WHERE `field_name` = 'block_check_start' LIMIT 1"),0,"field_data");
  13. $uptime = mysql_result(mysql_query("SELECT * FROM `options` WHERE `field_name` = 'timekoin_start_time' LIMIT 1"),0,"field_data");
  14. $request_max = mysql_result(mysql_query("SELECT * FROM `options` WHERE `field_name` = 'server_request_max' LIMIT 1"),0,"field_data");
  15. $allow_lan_peers = intval(mysql_result(mysql_query("SELECT * FROM `options` WHERE `field_name` = 'allow_LAN_peers' LIMIT 1"),0,"field_data"));






  1. 	$sSQL = "SELECT sectionID, sectionTag FROM sf_sections ORDER BY sectionOrder";
  2. 	$result = mysql_query($sSQL) or print(mysql_error());
  3. 		$sSQL="UPDATE sf_sections SET sectionOrder=" . $theorder . ",sectionTag='".$theTag."' WHERE sectionID=" . $rs["sectionID"];
  4. 		mysql_query($sSQL) or print(mysql_error());
  5. 		$sSQL = "DELETE FROM cpnassign WHERE cpaType=1 AND cpaAssignment='" . @$_POST["id"] . "'";
  6. 		mysql_query($sSQL) or print(mysql_error());
  7. 		$sSQL = "DELETE FROM sf_sections WHERE sectionID=" . @$_POST["id"];
  8. 		$sSQL = "SELECT sectionID, sectionWorkingName FROM sf_sections WHERE rootSection=0 ORDER BY sectionWorkingName";
  9. 		$result = mysql_query($sSQL) or print(mysql_error());
  10. 			$sSQL = "SELECT sectionID,sectionName,sectionName2,sectionDisplay,sectionName3,sectionDescription,sectionDescription2,sectionDescription3,sectionImage,sectionSideImage,sectionBannerImage,sectionWorkingName,topSection,sectionDisabled,rootSection,sectionurl,flash_movie,prod_body_format,prod_body_desc,sectionDetailURL, sectionImagesOther FROM sf_sections WHERE sectionID=" . @$_POST["id"];//custom code
  11. 			$result = mysql_query($sSQL) or print(mysql_error());
  12. 		$sSQL = "SELECT cpaID,cpaCpnID,cpnWorkingName,cpnSitewide,cpnEndDate,cpnType,cpnBeginDate FROM cpnassign LEFT JOIN coupons ON cpnassign.cpaCpnID=coupons.cpnID WHERE cpaType=1 AND cpaAssignment='" . @$_POST["id"] . "'";
  13. 		$result = mysql_query($sSQL) or print(mysql_error());
  14. 		$sSQL = "SELECT cpnID,cpnWorkingName,cpnSitewide FROM coupons WHERE (cpnSitewide=0 OR cpnSitewide=3) AND cpnEndDate >='" . date("Y-m-d H:i:s",time()) ."'";
  15. 		$result = mysql_query($sSQL) or print(mysql_error());

  1. 		$sSQL="UPDATE sections SET sectionOrder=" . $theorder . ",sectionTag='".$theTag."' WHERE sectionID=" . $rs["sectionID"];
  2. 		mysql_query($sSQL) or print(mysql_error());
  3. 		$sSQL = "DELETE FROM sections WHERE sectionID=" . @$_POST["id"];
  4. 		mysql_query($sSQL) or print(mysql_error());
  5. 		$sSQL = "DELETE FROM multisections WHERE pSection=" . @$_POST["id"];
  6. 		$sSQL = "SELECT sectionID, sectionWorkingName FROM sections WHERE rootSection=0 ORDER BY sectionWorkingName";
  7. 		$result = mysql_query($sSQL) or print(mysql_error());
  8. 			$sSQL = "SELECT sectionID,sectionName,sectionName2,sectionDisplay,sectionName3,sectionDescription,sectionDescription2,sectionDescription3,sectionImage,sectionSideImage,sectionBannerImage,sectionWorkingName,topSection,sectionDisabled,rootSection,sectionurl,flash_movie,prod_body_format,prod_body_desc,sectionDetailURL, sectionImagesOther, sectionTitleTag, sectionMetaDescription FROM sections WHERE sectionID=" . @$_POST["id"];//custom code
  9. 			$result = mysql_query($sSQL) or print(mysql_error());
  10. 		$sSQL = "SELECT sectionName FROM sections WHERE sectionID=" . @$_POST["id"];
  11. 		$result = mysql_query($sSQL) or print(mysql_error());
  12. 		$sSQL = "SELECT cpaID,cpaCpnID,cpnWorkingName,cpnSitewide,cpnEndDate,cpnType,cpnBeginDate FROM cpnassign LEFT JOIN coupons ON cpnassign.cpaCpnID=coupons.cpnID WHERE cpaType=1 AND cpaAssignment='" . @$_POST["id"] . "'";
  13. 		$result = mysql_query($sSQL) or print(mysql_error());
  14. 		$sSQL = "SELECT cpnID,cpnWorkingName,cpnSitewide FROM coupons WHERE (cpnSitewide=0 OR cpnSitewide=3) AND cpnEndDate >='" . date("Y-m-d H:i:s",time()) ."'";
  15. 		$result = mysql_query($sSQL) or print(mysql_error());



Back to Top