Mysql delete duplicate rows with same idpekerjaan

I'm looking for a skilled PHP developer with experience in CodeIgniter for a new project in the e-commerce space. Ideal Skills and Experience: - Proficiency in PHP and CodeIgniter framework - Previous experience in e-commerce platform development - Strong understanding of front-end technologies, such as jQuery, JavaScript, HTML5, and CSS3 - Knowledge of MySQL and other relational databases - Familiarity with RESTful APIs and Web Services - Ability to work with version control systems like Git The primary goal of the project is to create a robust, scalable, and user-friendly e-commerce platform. The platform should be able to handle a large number of products, facilitate smooth transactions, provide a secure payment gateway, and have a user-friendly interf...

...looking for a PHP developer with substantial CodeIgniter framework expertise. The project at hand involves upgrading and optimizing an existing PHP application. Key Requirements: - Strong PHP skills and extensive experience with the CodeIgniter framework - Proficiency in MySQL database management for database optimization and management. - Familiarity with front-end development to be able to enhance the UI/UX as part of the upgrade. Your main responsibility will be to improve the existing codebase, making it more efficient and scalable. This will involve database optimizations, code refactoring, and possibly some UI/UX upgrades. An understanding of security best practices in web development will also be highly beneficial. If you have previous experience ...

I have an Illustrator file that needs some text changes. All the new text content is ready, so the task mainly involves swapping out the existing text with the updated content. Ideal skills and experience for this project: - Proficiency in Adobe Illustrator - Strong attention to detail - Ability to follow instructions accurately Attached is a sample. Required modifications. 1. Change bar code. 2. Tidy up the text. 3. Duplicate the file and update some text. 4. Resend me with the right dimensions.

I'm looking to implement a user registration system for a paid tutorial video platform. Here's what I need: Script for user registration for gaining access for paid tutorial video Workflow Register...registration for gaining access for paid tutorial video Workflow Register new account / login fields: full name | email | password Once user creates his account, only he will access his account if he is using the same device where he first registered. Users need to register to gain access to a tutorial video. Once the registration is approve by the administrator, user will be able to login to watch video. Administrator will need dashboard for accounts administration: Registered users: Fields: full name | email | password | [Botton to active or disactive accounts. User IP/Ge...

I'm facing an issue with my StrongSwan tunnel. I would appreciate a talented freelancer to assist in troubleshooting and resolving the problem. Key Details: - The error message I'm encountering is 'invalid HASH_V1 payload length, decryption failed?' - The error seems to be related to not being able to decrypt payloads - Additionally, I'm getting 'No matching CHILD_SA config found for IP/IP. received DELETE for IKE_SA' on the responder side Your Role: - The primary task is to address and rectify the issues causing the tunnel failure - As of now, the problem seems to be primarily on the responder side Ideal Skills for the Job: - Proficient in StrongSwan VPN - Strong troubleshooting skills - Experienced in resolving encryption-related issue...

Objective of the project The goal of the project is to develop an automated system that generates high-quality content related to beauty, cosmetics, ...from various sources (URL, RSS, XML) configurable by a Super User. Filter and process such content using artificial intelligence (AI) to improve it. Automatically publish enhanced content to a WordPress blog and various social networks. Provide an intuitive administration panel for managing system sources and configurations. Technologies and Tools Used Backend: Django Frontend: React Database: MySQL or PostgreSQL Monitoring: Prometheus and Grafana Containers and Orchestration: Docker and Kubernetes This project is already validated by AI tools to correct errors in the part described in the technical document, so the development is...

...Proficiency in designing user-friendly websites with strong visual appeal. - Automotive Industry Knowledge: Understanding of automotive services will be a plus. - UI/UX Expertise: Designing an easy-to-navigate website is crucial. We have a current landing page here: Used only for clutch replacements which forms a large part of our business, we would like to merge this onto our main website under a different design. Website services are: Clutch Replacement Mechanical work Auto Electrical work ECU programming / tuning Car Keys (This must be a big feature to the website) Mileage correction Looking to base the site under a opensource content management platform, like WordPress or others you are comfortable with. If you use any premium plugins that require

...The ideal candidate will have a strong background in PHP and Laravel, with experience in building and maintaining ecommerce platforms. This is a remote position, offering the flexibility to work from anywhere. Key Responsibilities: Develop, test, and maintain high-quality ecommerce solutions using PHP, Laravel, MySQL, HTML, CSS, JavaScript, and related technologies. Collaborate with the design and product teams to implement new features and improvements. Optimize and enhance the performance of the website and app to ensure a seamless user experience. Troubleshoot and resolve issues as they arise, ensuring the stability and reliability of the platform. Write clean, well-documented, and maintainable code. Stay updated with the latest industry trends and best ...

Hola. Estamos buscando un experto especializada en la programacion web con PHP, Ajax, Boostrap 3 etc... Tenemos un sitio web dedicado al contenido para adulto desarrollado en SmartyPHP y queremos implementar una nueva sesion en nuestra pagina llamada "shorts" donde queremos mostrar videos verticales los cuales ya tenemos almacenados en nuestra base de datos con ID unico para identificar los videos que unicamente son verticales. La idea es construir esta pagina "shorts" y mostrar los videos tipo "Reels" asi como tiene tiktok e instagram. Queremos que esto sea lo mas fluido posible para que cuando el usuario en movil deslize hacia arriba o hacia abajo pueda pasar de un video a otro sin tener una recarga de la pagina. En la version escritorio queremos ...

...already processed invoices) with the following features. 1- A list of all invoices (Master List) with the field names I will provide. 2- A list of all Contracts with the field names I will provide. 3- A list of all Purchase Orders. 4- A list of Approvers who is approving the invoices. 5- A list of Accounts. 5- All of these list should be linked with each other. The database should have a login page. After Login, there should be a a Main Page, with link to the above mentioned list pages plus, Add Invoice, Search Invoice, Search Approver, Search Contract, Search PO, Search Account and Reports pages. For Add New Invoice page, I should be able to add an invoice details in it, and if it's related to a contract or purchase order, I should be able to...

...expert who have done similar projects in the or beginners please dont bother i do not have time to explain over and over again. So this is the requirements for the project: Inviter script must have some user friendly interface (HTML or app interface like Java or similar) Inviter script will take inputs of multiple Telegram API’s (accounts) total from 5 or 10 accounts a) API ID b) API Hash All API’s (Accounts) would be added to target channel/group as admins Script will read files where all accounts to be invited will be listed in the following format: @jacksparow @did738 @simao79 @wiro … The user file will contain anywhere from 1000-2000 users thats why i need script to be multithreaded and add Users from 10 Telegram API’s simultaneou...

...to help with the creation of my website. While the project specifics may vary, my main requirements are as follows: - **Geo Blocking:** The website should have the ability to block users from specific regions. - **Captcha:** Incorporating a reliable Captcha system to prevent spam and bots. - **Disclaimer Agreement:** Implementing a mechanism where users have to agree to certain terms before accessing the site. - **linkage to twitter & telegram. While there will not be a contract address in two of the boxes, we would like there to be a "test" of some sort to copy the info. I currently have a figma design made. We are currently working out kinks for future projects and this is a test for future work.

I'm seeking a skilled professional to help me understand the basics of the Zig programming language, specifically in relation to MySQL/MariaDB. I would like assistance in the following areas: - Learning how to incorporate MySQL/MariaDB within Zig projects

I'm currently facing a Forbidden error in my Laravel project that's connected to a MySQL database. I'm looking for a skilled developer to troubleshoot and resolve this issue, and potentially optimize the database connections for a smoother performance. Key tasks: - Troubleshoot the Forbidden error in my Laravel project - Review and potentially modify the existing database connections - Ensure that the database connections are optimized for performance The ideal candidate will have: - Strong experience with Laravel framework - Proficient in MySQL database management - Proven track record in troubleshooting and resolving similar issues

I currently have a problem with my InDesign project. I initially detected an image error when I attempted exporting to EPUB. The error points to an image that I can't pinpoint in the project. I am looking for help to: - Identify the problem with the missing image - Delete the problematic image from the project The ideal freelancer for this job should have substantial expertise in running diagnostics on InDesign projects, a keen eye for detail, and proven experience in resolving similar InDesign problems. A quick turnaround would be highly preferable.

The site has been compromised by malware. Have scanfile with corrupt files but do not know how to delete them without wrecking the site. Please see attached screenshots when you go to website and directions from bluehost customer support.

We are a web development company looking to expand our team. We need someone highly skilled in PHP and MySQL. Our work primarily involves custom projects, and occasionally WordPress. Currently, we have a job ready to start using the BigCommerce platform. This project requires code customization, assistance with connecting to shipping, and more. Thank you.

I need help migrating my Joomla-based website, which currently features a Currency Converter, to a new hosting server. Key Requirements: - Migrate the entire website (including the Cu...currently features a Currency Converter, to a new hosting server. Key Requirements: - Migrate the entire website (including the Currency Converter feature) from the existing server to a new one. - Ensure that the Currency Converter functionality remains intact and fully operational post-migration. Ideal Skills and Experience: - Proficiency in Joomla, PHP, and MySQL. - Prior experience with migrating websites, particularly those with dynamic features like Currency Converters, would be beneficial. - Strong attention to detail to ensure all components of the website are correctly tran...

Develop schematics, PCB and firmware for a compact NFC reader. The suggested RFID controller is PN7160. Microcontroller - STM32 0) Two boards - antenna and the main board. The antenna diameter is 15mm with a hole in the center 4-5mm. The main board is 14mm in width and length is 35mm or less. 1) The reader must read and write password-protected memory blocks in Mifare Classic cards. 2) The reader keeps the password for the RFID cards as a hard-coded constant. 3) The reader has an 4-byte reader ID stored in its EEPROM memory. 4) The RGB LED on the edge of the main board, whose location matches the hole in the antenna. RGB LEDs are connected to the PWM pins of the controller. 5) A waterproof (if possible) speaker must be on the opposite edge of the main board, closer to one si...

I need a professional to convert the information in the attached document into an organized, well-formatted Excel sheet. The project will require you to: - Copy all the text content of the document into corresponding cells in the Excel sheet. - Transcribe all tables and charts in the document accurately into...information in the attached document into an organized, well-formatted Excel sheet. The project will require you to: - Copy all the text content of the document into corresponding cells in the Excel sheet. - Transcribe all tables and charts in the document accurately into the Excel. - Maintain the original formatting of the data in the document. The Excel document should: - Include all columns and rows from the original document. - Not require any additional formulas or ...

I have a series of medical bills that need to be entered into a spreadsheet. The data is primarily textual, numeric Ideal Candidate: - Must have a keen eye for detail to ensure accurate transcription of the printed text into a digital format. - Proficiency in spreadsheet software for the efficient and organized entry of the data. I have attached an example bill and the expecte...into a spreadsheet. The data is primarily textual, numeric Ideal Candidate: - Must have a keen eye for detail to ensure accurate transcription of the printed text into a digital format. - Proficiency in spreadsheet software for the efficient and organized entry of the data. I have attached an example bill and the expected excel format. I have 34 such pages of bill. Overall you will have ~200 rows to b...

...service in Kotlin or Java. Communication between Flutter and the native code should be done via Platform Channels (MethodChannel and EventChannel). User Interface ----------------------- The app should have three main screens: - Splash Screen: Displays the app logo. - Login Screen: User authentication with username and password. When the login button is pressed, a POST request should be made to an API (which I will provide) sending the username and password in JSON format. The API will respond with the login status (granted/denied) and a token for future requests. On successful login, the Foreground scan service should be started and navigate to the Status screen. The login state should be saved locally (in local storage). If the user is already authenticated, future a...

I'm in need of an Excel expert to enhance my files. The tasks include: - Removing duplicate rows - Fixing formatting issues - Merging two sheets into one Additionally, I would like to incorporate a corporate branding style in the file, utilizing appropriate colors and logos. Ideal Freelancer: - Proficient in Excel with experience in data cleaning - Skilled in formatting and merging multiple sheets - Familiar with incorporating corporate branding within Excel

...+15%; 13 for -70%; 91 for +30% randomly for each product dates and prices changing (both up and down ) for 20 times per year **T1 transactions Product id Date time Store id **T2 prices New price permanent Data Store is **T3 promotions Product id Store id Promotion price Date promotion start How many days promotion lasts **T4 store lookup table Store id Store state Store city **T5 competitors lookup table Competitor ID Competitor state Competitor city **T6 holidays lookup table USA holiday name USA state holyday Holiday date 1 Holiday date 2 Holiday date 3 ***** Main table to calculate ***** Product id Year Month Day How many sold Price usual Promotion y or n Price promotion Price promotion % to usual Promo...

...mesma pessoa como o site, portifilios, videos para campanhas no whatsapp, tutoriais e etc, então sera uma parceria de longa data, minhas redes são: preciso de alguém que : tenha conhecimento profundo do público-alvo Entenda quem são as pessoas que você quer alcançar: Idade, gênero, interesses, comportamentos online e offline. Faça pesquisas e análises de dados: Utilize ferramentas para traçar o perfil do público e entender suas necessidades. Monitore as tendências: Fique de olho nas conversas, memes e hashtags

...document and make yourself familiar with the details of the project before contacting me. You will be tested to see if you are serious. I'm looking for a skilled web developer to build , a multi-vendor platform connecting digital artists with the print-on-demand service Gelato. The platform aims to facilitate the sale of digital artworks as physical prints/wall art, with artists earning commissions on their sales. There will also be some unique features and an affiliate program. The major points and requirements for the project are listed in the attached project document. The design files are nearly finished, but some design work is likely needed: (ZAPTA)?type=design&node-id=5042-102&mode=design The website

I have a substantial Excel table and I am in need of a skilled data analyst to help with correlation analysis between Column 1 to 9 of my dataset, which contains more than 4200 rows and 9 columns. Need the source file of xls with formula too Key Responsibilities: - Perform accurate correlation analysis on specified columns - Generate line graphs to visualize the correlation Ideal Skills and Experience: - Proficiency in Excel and correlation analysis - Solid understanding and experience with line graph creation - Excellent problem-solving abilities - High attention to detail I'm looking for accurate and efficient work so I can understand the relationship between my data points and act accordingly. Your experience could be the key to enhancing my project. ...

I am looking for an experienced Flutter developer to build a comprehensive e-commerce application. Key Features: - The primary feature of the app will be a well-organized product ca...devices and tablets across both systems. Ideal Skills: - Proficiency in Flutter development is a must. I expect a polished, user-friendly interface that is consistent across both platforms. - Previous experience with e-commerce applications is a plus. Familiarity with shopping cart and payment integration functionalities would be highly beneficial. Please provide examples of your previous work, particularly within the e-commerce sector, when applying. Please check this figma design and if you can do it, let me know

Necesito que alguien me realice un isometrico de tuebrias y accesorios basado en un sketch simple y un P&ID

...When 14 for -20%; 25 for +34%; 52 for -40%; 28 for +10%; 55 for +15%; 13 for -70%; 91 for +30% **T1 transactions Product id Date time Store id **T2 prices New price permanent Data Store is **T3 promotions Product id Store id Promotion price Date promotion start How many days promotion lasts **T4 store lookup table Store id Store state Store city **T5 competitors lookup table ( 20% percent of stores have competitor In the same city ) Competitor ID Competitor state Competitor city **T6 holidays lookup table USA holiday name USA state holyday Holiday date 1 Holiday date 2 Holiday date 3 ***** start Main table to calculate ***** Product id Year Month Day How many sold Price usual Promotion y or n Price p...

...professional who can convert both scanned documents and photos into simple data in Excel format (language is not in English workable when one can use translate and understand the few terms that are there). The ideal candidate will have the following skills and experience: - Proficient with MS office - Expert in handling MS Excel - Ability to follow a specific Excel template provided - Attention to detail to ensure accurate data entry ***The task is very simple and just requires attention to detail. I need mainly 4 Data Rows: 1. Date 2. Payor/Payee 3. Amount 4. Short Description of Transaction (if given in the doc) Please message me to talk about the project and the realistic bid price per Job. Your responsibility would be to ensure that the scanned files and photo...

in general I don't get the Greek characters in the description and all the buttons "complete", "delete" etc. throw this error and the reports are not generated its probabely some issue with the path or smtp notifications. please have a look at the video. i will send you the site and db on chat budget: $15-$20 USD deadline: 20/5

...Recording: The attendance data is currently being recorded manually in paper registers. The goal of this application is to digitize this process, making it more efficient and accessible for all the students. Design is already in Figma File Ideal Experience: - Proficiency in Android app development - Prior experience in creating applications with user authentication and notification features - Familiarity with digital attendance systems - Understanding of user-friendly interfaces The success of this project will be measured by the ease and reliability of the application for students to use. I am looking for a developer who can deliver a functional, user-friendly app within a reasonable timeframe.

Hi, I hope all folks are doing well. I need someone to assist me in online task. A person needed from stripe supported country. Preferably from Canada, Australia. What you need to do? You need to help me get into Medium (Partner Program). In order to that, I need address information. And Id verification for Stripe. If you can assist me in this task. I can pay you by task or you can partner with me for my blog earning. Which means if I started earning from my blog, I will pay you $50 each month. makelivingonline1 at the rate of Thanks

solana nodejs code for multi-swap within same tx.

...like you're encountering a MySQL error related to an incorrect DATETIME value in your query. This error typically occurs when the format of the date and time being used in the query does not match the expected format in MySQL, or when an empty string is being used where a datetime value is resolve this issue, you should first check the format of the 'date_scheduled' values in your 'banners' table to ensure they are in the correct DATETIME format. You might also need to modify your query to handle cases where 'date_scheduled' might be empty or incorrectly you're not sure how to proceed or need further assistance with checking or adjusting your database, you can manage and review your MySQL databases and their tables fr...

Flutter version: 3.22 We want to add our own Sqlite database to assets: assets/ name of table: kids Database included id – name – surname I can send my database. We need a file () that shows database information after clicking a button.

I'm looking for a skilled professional who can meticulously guide me in video call through setting up a VPN using Google Cloud and OpenVPN. The primary aim is to ensure secure remote access to a MySQL database from my Windows laptop. Key requirements: - In-depth knowledge of Google Cloud and OpenVPN - Proven experience in configuring secure VPNs - Expertise in MySQL database security and remote access Your role will be to provide detailed, step-by-step instructions on how to properly configure the VPN to meet my security needs. Please bear in mind that I may require access to the MySQL database from multiple remote locations, but most likely will only need it running from 1 remote laptop - the VPN should be flexible enough to accommodate this added funct...

...responsive design is crucial to ensure seamless, optimal performance on both. Note:- Please check figma of layout required below. The key features I require include: - Fast loading - Google page speed check has to be 100% for both desktop and mobile - The page is image heavy, hence has to lazy load images correctly - Menu has drop down images heavy. Accordingly loading should be only on mouse over and not interfere with rest of page load. - First part of the page should load very fast. - Listing of rest of the page should re-fresh on scroll. - Listings are fetched from Mongo db on aws server. - User-friendly

We need someone to re build this PDF brochure in PPT. The original InDesign files are lost but we have all the individual files, fonts, images ready to share together with our brand ID style guidelines. Need a fairly quick turnaround. If well done we have ongoing brand and design work requirements weekly throughout most of the year.

I'm looking for a skilled developer to duplicate the design and functionality of a website from TypeScript, JavaScript, HTML, and CSS to a Python-based system. The website currently allows users to input a URL for evaluation on its ACT and WCAG compliance. Once evaluated, it highlights any errors and provides recommendations for improvement. The source code is provided. Key Requirements: - Recreate user input URL evaluation - ACT and WCAG compliance checking - Error highlighting - Recommendation provision Design Changes: - Redesign of the website's layout - Improvements to the user interface Design Preferences: - Clean and minimalist design - Modern and trendy elements The source code is available for reference. Ideal candidates should have a solid understanding of web...

I'm in need of a talented el...of a talented elementor website designer with the knowledge of Javascript and jquery, css3 and html who can transform a Figma prototype into a visually appealing and functional business website. Key Requirements: - Transform a Figma prototype into a Pixel perfect designed website - Ensure design is responsive and 100% similar to the figma Ideal Skills: - Experienced in designing business websites - Skilled in Elementor - Strong knowledge of JS, JQuery, CSS3, HTML, Elementor & PHP - Excellent communication and collaboration skills Check out the prototype from this link:

***this is a GUARANTEED PROJECT for a QUALIFIED person.*** Looking for the below design to be done on elementor. It has to be 100% similar to the prototype that has given in the link. This project is time sensitive. you will have only 1 day to design the page pixel perfect and responsive. PROJECT for a QUALIFIED person.*** Looking for the below design to be done on elementor. It has to be 100% similar to the prototype that has given in the link. This project is time sensitive. you will have only 1 day to design the page pixel perfect and responsive.

Build an ISO for a raspberry pi (with cellular notecard) to scan for unique cell phones in a specific range and log the unique phone ID and timestamps/ping (distance) from the raspberry pi and store in mysql database using cellular adapter.

I'm in need of...candidate should be proficient in MySQL, and have experience in user authentication, data retrieval, and data modification. Key Requirements: - Develop User Authentication: The API should include secure user authentication functionality. - Implement Data Retrieval: The API must be able to retrieve data from MySQL database as needed. - Data Modification Capability: The API should also support updating and deleting data in the database. Additional Needs: - Third-Party Integrations: The API will need to integrate with a payment processing system and also be able to send WhatsApp messages. If you have a strong background in Node.js, MySQL, and building REST APIs, I'd like to hear from you. Please include examples of similar projects yo...

...is to display an incoming call modal, similar to the functionality of a caller ID app like Truecaller. Here's what I'm looking for: - The incoming call modal should be a full-screen overlay, as well as a small modal and it should display the caller's name and number. - Additionally, the caller's profile picture should be shown on the modal. - The modal should have interactive options to answer or reject the incoming call. While the project doesn't include specific requirements for what happens when the call is answered, I'm open to creative suggestions on how to enhance the app further. Ideal skills for this project: - Proficient in React Native - Experience with UI/UX design for mobile apps - Familiarity with integrating APIs for ca...

...work. and I will also award you the job at that time. 3) The product must be customizable with text and adornments that the customer chooses. The most important part is that the customization choices will show on the picture in real time. In other words, the picture will change each time a customization is added. I need ONE PAGE created for web store (wordpress/woocommerce). Must have a visual product customizer. Meaning that a customer will have the option to customize the item and see the changes they make in real time. Not just colors and sizes though, but entering texts and choosing adornments, etc. Here is an example of what I am needing (not my website, just one I found online). If you can duplicate this page exactly I would be pleased.

...showing a piece of the original data. and what i neeed the macro to achieve. WHAT IM ASKING If two adjacent cells in column b are equal, then add cells adjacent column c cells, put the result in the first column c cell and remove the duplicate row. AEE ATTACHED png. I need a tailored solution for a data manipulation task within Excel. Specifically, I am looking for an Excel macro that can accurately merge cells based on their adjacency. Essential skills and experience should include: - Expert knowledge of Excel and its macro functionality - Prior experience with data manipulation tasks such as merging cells - Understanding the rules or criteria for merging specifically adjacent cells - Excellent problem-solving skills and attention to detail I will provide the wor...

...to assist with customizing and optimizing my business blog on Wix.com. Key Requirements: - Customize the layout design to match my business needs - Implement an appealing color scheme that aligns with my brand - Setup a user-friendly navigation menu for an enhanced user experience 1 - They are not in a hierarchy or in order, how can I put them in a hierarchy and in order? For example I want the site to show top category (continent Europe), when user clicks on that countries (Greece, Germany...) and when user clicks on country then it opens cities (For Germany Frankfurt, Munich, Berlin....) btw it should be duplicated , I need to duplicate and I need to do the same for hotel deals 2 - I want to show this hierarchy and order on top of Navbar as well. I hig...

I need a talented full-stack developer with experience in PHP and MySQL. You'll be designing and creating a platform that supports 360-degree videos, similar to YouTube. Deployment in the cloud will also be required. Key Responsibilities: - Develop the front-end and back-end of the platform. - Design the platform's layout (the design concept is yet to be decided). - Enable 360-degree video support. - Implement features for video uploading, sharing, and rating. - Enable user account and profile creation. - Include a commenting system. Ideal Skills and Experience: - Proficient in PHP and MySQL. - Experience with cloud-based deployment. - Good understanding of user-friendly design concepts. - Familiar with user account management systems. - Exper...