Mysql sample codespekerjaan

...conditional aspects of the process, for example if there are any stages of the process where resources only become available once the previous sample has been processed. c. Second, write out the relevant equations associated with each step of the process, and construct a formula for the overall time in system. d. Use relevant notation and write out equations using Equation Editor in Word. e. Note – the rule of thumb is that any reader can pick up your report and replicate your results by following the methods. 2. Use mean values of each parameter to construct an “average” solution. a. Unit of interest – a DNA sample collected by a CSI. That is, each sample must be modelled individually. b. Assume both CSI and forensics lab operations work 24...

I am seeking a proficient Flutter developer to create an application for both iOS and Android platforms, with integral backend development using PHP/MySQL. Key Responsibilities: * Develop a Flutter app for both Android and iOS platforms. * Backend development of the app using PHP/MySQL. * Creation of Data fetching APIs for seamless user-experience. Ideal Skills: * Proficient in Flutter * Extensive experience with PHP/MySQL backend development * Skilled and knowledgeable in creating Data fetching APIs If you have proven experience in similar projects, I am willing to discuss the details further. Your understanding and expertise in Flutter development and API creation is paramount for this project.

...details before you bid Kindly bid if you are experienced in image editing...set in pixel -900 X 700+save to .png format and webp format The sample of the requirement is attached for your reference.... your quote will be considered for 1000 products images. All the images is for grocery shop 1) All products should be cropped individually from the brochure or image or website link, The same shall be shared to you as per the required data. Any visible imperfections need to be painstakingly cleared off. Each picture will have to be improved in terms of lighting and contrast to make it more visually appealing. 2) the Size of the image should be 900 X 700 (Sample attached for your reference) 3) No Duplicates images should be created even if the brochure /excel or images (prov...

...SEND YOUR SAMPLE VIDEO FIRST TO BE SELECTED I need someone to create videos on English Grammar on the topics given here in the attachment. It can be discussed in Chat. You should have a good, professional grade Mic. An electronic Pen is desirable. Topics for which you need to create the videos are Narration , voice change, parts of speech, sequence of tense, gerund, creating wh questions etc. Each topic should be minimum of 60 minutes length. You first need to explain the main concept, use examples and use some questions and then its answers with explanation.. also create 10 MCQ questions on each topic. Instructions to be in ENGLISH only. Use Screen recording Software and/or Whiteboard. VOICE MUST BE LOUD & CLEAR. NO BACKGROUND NOISE/SHAKY VIDEOS NOT ALLOWED. See my attached ...

Hello, i have python codes that fetchs some data.i need someone have experience in qt designer to create the win form To show the data as required some in lables and some tables and need the design visually so we can easly edit in future Will explain the required design privately sharescreen in anydesk..

There is a sample site, it will be cloned and the web design will be designed. the site will be cloned

We are looking for Indian Male Voice Over Artist. apply with your ads voice sample. bid without sample will not be considered. and please let me know your charges for 15-30 Sec

...the app. Onboarding Screen: A user-friendly onboarding process that allows users to register/login using their mobile number and OTP authentication. Registration/Login: Smooth and secure registration/login process, integrating mobile number verification for authentication. Refer Code Screen: After successful login or registration, users will be directed to a screen where they can input refer codes for promotional offers or referrals. Requirements: Proficiency in Figma or similar design tools. Ability to create visually appealing and user-friendly designs. Understanding of mobile app design principles and best practices. Experience with designing authentication flows and referral systems is a plus. Strong communication skills to collaborate effectively with the development te...

I'm in need of an experienced backend developer to create a mail parser with the following specifications: - **Email Protoco...experienced backend developer to create a mail parser with the following specifications: - **Email Protocol:** The mail parser should support SMTP, so proficiency in this area is a must. - **Primary Goal:** The primary function of this mail parser should be storing emails in a MySQL database. If you have experience with database integration, this would be a big plus. This project requires expertise in backend development, specifically with an understanding of how SMTP works. You should also be familiar with MySQL and have experience in integrating databases into applications. Please provide examples of similar projects you've worked on i...

...requirements: - Design a functional layout: The space should include a kitchen, bathroom, and bedroom, whilst ensuring a comfortable living environment for 1-2 occupants. - Utilize the limited space effectively: The container size is 40 feet, so the design should maximize utility without compromising on comfort. - Ensure safety and compliance: The final plans should meet all relevant building and safety codes. Ideal skills and experience: - Experience in architectural or interior design with a focus on small spaces. - Knowledge of container conversions and the unique challenges they present. - Ability to balance aesthetic appeal with practicality. - Familiarity with relevant building and safety regulations. If you have relevant experience and skills in this area, please bid a...

... Alternate Logos: Show any alternative logo versions and specify appropriate use scenarios. Size Specifications: Define minimum and maximum size constraints. Exclusion Zone: Outline required clear space around the logo. Incorrect Usage: Provide examples of improper logo treatments. 2. Color Palette Primary Colors: Black, white, and green (include Pantone, CMYK, RGB, and Hex codes for each). Secondary Colors: Guidelines for any additional colors used. Usage Guidelines: Detailed instructions on how to use the color palette on various media. 3. Typography Primary Typeface: Details for a modern, sophisticated primary typeface for use in headings and titles. Secondary Typeface: Specifications for body text and secondary headings. Web-Safe Font...

...and you both speak according to topics. Requirments- Native Canadian Quebecois French Working tool- Our APP + Phone call (skype) Conversation time- total 2 hrs with 3-4 topics(about 20 mins for each topic)/2 persons as a group. Payout: $70 (2 person as a group) total 2 hrs with 3-4 topics. Its a one time project only. NOTE-: For this project we need a 1 minuet group conversation as a sample. ( in sample you speak anything with your partner in same room . we just need to check your native accent and enviroment) Work requirments: The recorders (Both recorders) record face to face in the same room by using our application and making the phone calls simultaneously. The recorders shall arrange two phones in total One phone is downloading Our Application The other phone ...

...only Topics and you both speak according to topics. Requirments- Native Australian Working tool- Our APP + Phone call (skype) Conversation time- total 1.5 hrs with 3-4 topics(about 20 mins for each topic)/2 persons as a group. Payout: $80 (2 person as a group) total 1.5 hrs with 3-4 topics. Its a one time project only. NOTE-: For this project we need a 1 minuet group conversation as a sample. ( in sample you speak anything with your partner in same room . we just need to check your native accent and enviroment) Work requirments: The recorders (Both recorders) record face to face in the same room by using our application and making the phone calls simultaneously. The recorders shall arrange two phones in total One phone is downloading Our Application The other phone...

( Only In...expertise as a Senior Software Engineer or higher ● Extensive experience in software development, scripting and agile methodologies ● Experience using system monitoring tools and automated testing frameworks ● Highly skilled knowledge of selected programming languages (e.g. Ruby, Python, React) ● In-depth knowledge of relational databases (e.g. PostgreSQL, MySQL) and NoSQL databases (e.g. MongoDB) ● Familiarity with AWS and cloud native offerings ● Analytical mind with problem-solving aptitude ● Ability to work independently ● Ability to work cross-functionally with leaders in Architecture, QA, SRE, Product, Creative, etc… ● Excellent organizational and leadership

I'm looking for an experienced WordPress developer who can help me add a special functionality to my existing websites by creating a custom plugin. This role is ideal for someone who has: - A high level of competency in PHP, JavaScript, and MySQL and is experienced in WordPress. - Strong understanding of the WordPress plugins ecosystem and knowledge on how to extend its functionalities. - In-depth knowledge of SEO and how to enhance it on a WordPress website. Key Tasks: - Develop a WordPress plugin that targets SEO enhancements. - Test the plugin for compatibility issues and fix any bugs, ensuring it works harmoniously with our existing setup. - Understand our needs and respond to them by customizing the plugin where necessary. Please note that the function to be added to th...

I'm seeking a skilled PHP/MySQL developer to create a custom PHP POS application. This job will require you to have good experience in PHP/MySQL. You will be paid on a task-based. We will test you with some sample tasks. To be eligible for further discussion I want you to have a look into the portal by visiting the below link and create a free account and try the portal give me one issue you have faced and can be improved in the portal. If you are unable to do above then your application will be rejected immediately.

I'm seeking an expert researcher to build a comprehensive list of 3300 Chair of Governors from public secondary schools for me. Each secondary school has one, if a chair can not be found clerk of Governors acceptable. Site to help The budget is $100 no more - please send a sample of 10 to 20 Governors Key requirements include: - The list should be organized alphabetically by county/area - I need contact details to include email addresses and phone numbers. Your experience with web research, data mining and data entry will be crucial to successfully carry out this task. Knowledge of educational institutions and contact compilation is key. Please ensure that the details gathered adhere strictly to public

I am seeking a competent developer experienced in PHP, MySQL, HTML, and CSS. The project involves designing a web application that encompasses: - User registration and login - An information management system The ideal candidate should have strong experience in these areas. No external integrations are required for now, but a candidate that could add this feature in later stages will be preferred. Please ensure you are proficient and demonstrate a deep understanding of the key skills before you take on this project.

Hi, we need a c# .net/ maui package similar to with same functionality but with support for iOS in addition to existing platforms. Please don't ask for f...open source ones; - in case third parties components are involved, the develope must ensure us the licenses for third parties components allow distribution/use for commercial purposes; - the developer must sign the feelancer's intellectual property agreement. The payments will be: - 1/3 milestone after the developer provide sample projects for each platform with the compiled package, after we checked it's fully compliant - 2/3 milestone after the developer provide sample projects for each platform with the package's full source code, after we checked it's fully compliant Thank you

I need some help with a data model I created in Power Pivot. I have 2 data sets: one is Sales and the other is Stock. I have added both data sets to my data model and am now trying to create a pivot which pulls data from both tables. My Sales table pulls the data perfectly but the Stock table does not. Some context... When I pulled the data into the data model I added a column which...added a column which I called DataModelLink. This created a 1 (Sales) to many (Stock) relationship between the two tables. As an example, I tried to pull the data of one particular style which had one line in the Sales table but 2 lines in the Stock table. For this reason, my Pivot is only reading one of two of the lines on the Stock data table. I am happy to share the data model as it is only sample...

I currently have a PHP script that echo's the value of a MySQL db and results appear 3 to a page using Pagination. I'd like the script modified to filter results. There should be a drop down box on the page with the selections of the drop down corresponding to the table column and when selected only the rows with the value of the column appear while still only displaying 3 to a page with page back and forward controls. In the below example of a db table the drop down box would contain the selections 1, 2 and 3. When the used selects 1 then the page output would only display Bob, Jane and Sarah. This is an already existing page with css in the output. Name Address. number ------------------------------------------------------ bob brisbane. ...

I'm in need of a skilled developer to create an interactive adult learning module [Sample section only] using Chameleon Creator. The module is about a small business related topic and will be deployed on a website. Key Requirements: - Target Audience: The module is designed for adults working in local government, so the content should be relevant and engaging for this group. - Interactivity: I'm looking for a moderate level of interactivity, specifically the embedding of case studies broken into segments, content sections, and quizzes. - Platform: The learning module should be developed for deployment on a website using Chameleon Creator as the authoring tool. Ideal Experience: - Proficiency in e-learning module development using Chameleon Creator - Experience in creatin...

...Store Policies Shopify CMS: Use Shopify’s built-in CMS to create, manage, and display store policy pages like privacy policies, terms of service, and more. Static Sections: Implement static sections in the storefront for easy access to policy information. 8. Discounts Discounts API: Create and manage discounts directly through the app. This can include automatic discounts, coupon codes, and limited-time offers. Price Rules API: Automate pricing adjustments based on certain conditions or triggers set within the app. 9. Upselling/Cross-Selling Product Recommendations API: Leverage Shopify’s API to recommend products based on the customer’s current cart content or browsing history. Shopify Scripts: Write custom scripts to offer relevant...

I need to move my current website, designed on Figma, to Elementor Pro. Sample of job : !!!?type=design&node-id=0%3A1&mode=design&t=acBmxWS1WvkNxU3B-1 Key requirements: - Migrate existing Figma design to Elementor Pro without any loss of functionality or layout. - Ensure the design is responsive across all devices. - Implement any necessary modifications to the existing design to make it compatible with Elementor Pro. Ideal skills and experience: - Proficiency in both Figma and Elementor Pro. - Experience in website migrations, especially from Figma to Elementor. - Strong understanding of web design principles and responsive design. - Ability to effectively communicate and provide transparent progress updates.

I am on the hunt for a skilled logo designer to create a distinct and memorable logo for my b...hunt for a skilled logo designer to create a distinct and memorable logo for my business. The design should incorporate the colors purple and light orange to align with our brand identity. KEY REQUIREMENTS: - Proficiency in graphic design and applications like Adobe Illustrator or Photoshop - Eye for aesthetics and detail - Able to incorporate our color choices into the logo design - Produce a sample or a draft design for discussion It's preferable if you could provide links or files of your past work, especially in logo design. Expertise and experience in the field would be highly favored. We hope to wrap up this project within a month, so time-management and ability to meet de...

Se requiere un script de RIFAS o SORTEOS con las siguientes opciones: - Escrito en PHP y soporte MYSQL. - Emitir boletos en orden consecutivo (ejemplo 10000 - 999999), el rango de números debe ser personalizable (Ejemplo: 000001 - 999999, 5450 - 54500, etc.) - Poder ingresar el precio de los boletos de la rifa - Capacidad de albergar la rifa de otros usuarios (multi-usuario, multi nivel). - Pagar boletos a través de la opción de tarjeta de crédito de PayPal (con o sin cuenta de PayPal) o por transferencia, modo manual, mostrando información bancaria del propietario ded la rifa. - Ingresar dirección de correo electrónico, Nombres, Apellido, Ciudad, Estado, Número de teléfono de contacto. - Después de recibir el ...

I have an unfinished Flutter app that requires a skilled individual to handle its database connection. The app is designed and now, I need help connecting it to a MySQL database using an API. Key Responsibilities: - Complete the database connection for my Flutter app - Utilize MySQL to store the following data types: user profiles and authentication, transactional records, content and multimedia files Ideal candidate: - Proficient in Flutter and experienced in developing Flutter apps - Skilled in MySQL and API integration - Familiar with handling user data and transaction records securely - Strong background in data storage and retrieval for content and multimedia files This project is not for a business, but rather a personal venture. Your expertise will help me b...

...details before you bid Kindly bid if you are experienced in image editing...set in pixel -900 X 700+save to .png format and webp format The sample of the requirement is attached for your reference.... your quote will be considered for 1000 products images. All the images is for grocery shop 1) All products should be cropped individually from the brochure or image or website link, The same shall be shared to you as per the required data. Any visible imperfections need to be painstakingly cleared off. Each picture will have to be improved in terms of lighting and contrast to make it more visually appealing. 2) the Size of the image should be 900 X 700 (Sample attached for your reference) 3) No Duplicates images should be created even if the brochure /excel or images (prov...

I'm seeking a skilled editor for a long-term position for multiple projects with my content agency, primarily serving health and fitness coaches ...folder. I expect a simple thumbnail that fits the ratio 1:1 on Instagram feed. All videos should be edited in 9/16 format for fullscreen experiences on Instagram Reels + TikTok. Please reach out to me here on Freelancer and tell me a bit about yourself, your current situation and show me previous work. ***Important*** I expect a sample to quality check your work. If I find qualified for the position, I will provide you with the raw 60-seconds footage for the sample. *Fluent English is a must & you must be able to jump on a Zoom call to go through the onboarding process (webcam is a must).* Daily reports are expecte...

Good evening, I need help with a Python assignment and I also need programming tutorials in java, Python, mvc, php, Javascript, mysql, jQuery, html, css, asp.net, c#. The tutorials would be in Spanish. I need them as soon as possible.

I am seeking a professional ...with expertise in designing and conducting structural calculations for a standard size, contemporary styled steel spiral staircase meant for a residential setting in California. Key tasks will involve: - Drafting a detailed design of the staircase - Running computations to assess and certify structural stability - Ensuring all designs and calculations are compliant with California’s building codes to secure permits Ideal profiles should have extensive experience in residential staircase design and a deep understanding of regional building regulations. Proficiency in utilizing design software is expected. The successful candidate will ideally have completed similar projects within the state, thereby showing a proven track record of securing bui...

As a business with diverse inventory, I am in need of an application to generate unique SKUs, track their usage, and store pertinent SKU information. A distinctive facet of the project will be the creation of a custom format SKU algorithm incorporating department codes, which will ensure efficient identification and organization on our part. As such, a freelancer with a background in inventory management systems or similar projects would be advantageous. This job will require: We have a convention to follow for creation of the SKU IDS. Furthermore I want the ability to add product images at the time of generating the SKU. - Strong knowledge in application development. - Experience with custom format algorithms. - Understanding of department code incorporation. - Skills in SKU usag...

Sila Dafter atau Log masuk untuk melihat butiran.

Seeking an experienced firmware engineer to create the firmware on an STM STA8089FG GNSS chip to customize the data sent out via its UART interfaces. The task: - Obtain firmware source code and SDK from ST - Modify firmware to allow custom UART data output: UART0 - GNSS, UART2 - debug strings - Provide source codes so we can update debug messages if needed

I'm seeking an expert researcher to build a comprehensive list of 3300 Chair of Governors from public secondary schools for me. Each secondary school has one, if a chair can not be found clerk of Governors acceptable. The budget is $100 no more - please send a sample of 10 to 20 Governors Key requirements include: - The list should be organized alphabetically by county/area - I need contact details to include email addresses and phone numbers. Your experience with web research, data mining and data entry will be crucial to successfully carry out this task. Knowledge of educational institutions and contact compilation is key. Please ensure that the details gathered adhere strictly to public schools only. I expect high levels of accuracy, so skills in precision and attentio...

I am searching for an experienced workbook designer to collaborate with me to develop an engaging and effective workbook for emerging documentarians. The workbook content will include: - Instructional text - Quotes - Writing prompts - Visual aids (charts, graphs, images) I already have a cover design, mood board, color palette, initial sample layouts, and draft text. I would like a designer to work with me to create templates that I can fill in (either using InDesign or another platform) that will guide my writing and work prompts process. Once I have completed a first draft of the workbook, the designer will collaborate with me to finalize page layouts and manage the printing/production process. Ideal Skills and Experience: - Experience in designing workbooks and workbook...

Hello, I need a developer with a lot of experience in JavaSCRIPT EXPERT, Python and Socketweb - with the ability to create and solve problems with easy understanding of codes The rest of the details will be given to the correct developer

...working at the premise, loading/unloading of goods, etc. REQUIREMENTS: • Must be living in (or nearby) San Fabian, Pangasinan, Philippines • Has a camera or phone/tablet of quality with a camera, internet access Please see the attached file for the site visit guideline. You are only required to deliver the pictures, video & observations and are not expected to put together a report like the Sample Report. Note: Milestone will be released the following week after the site visit to give us time to organize the report and contact you if we need additional clarification....

Hello, I need a developer with a lot of experience in Java, Python and Socketweb - with the ability to create and solve problems with easy understanding of codes The rest of the details will be given to the correct developer

I urgently require an expert graphic designer to create an engaging pattern design for a glass printing project. While I have no specific theme in mind, I am looking to work closely with you to create a design that is visually appealing and fits well with my overall vision. Key Responsibilities: * Cr...Demonstrable graphic design skills, particularly in pattern creation. * Experience designing for print mediums, specifically glass. * Strong communication and understanding of tight deadlines. * Ability to provide creative inputs and recommend design solutions. Looking forward to hearing from prospective candidates on how we can make this project a success. Please include relevant portfolio pieces or sample work in your bid. Let's create something eye-catching together, as so...

i have a form created with HTML and PHP. user has to fill in information and when press submit, it should insert infos in database. But sometimes it doesn't it just clear or keep loading. maybe connection is not good everytime. So i need someone to adjust it to upload d...doesn't it just clear or keep loading. maybe connection is not good everytime. So i need someone to adjust it to upload data in realtime. as soon as user finished typing in 1 field, it should store data. when uploading, it should show loading icon near input field. if succeed, green vink icon. if not, red cross icon. when user finish, user can click submit button which will echo all data stored in mysql database on same page in lightbox. image attached. Budget is $35. if you want more, please do NO...

I'm seeking a creative graphic designer with expertise in HTML to craft a monthly newsletter The first page should be like a magazine-like aesthetic, utilizing: - A captivating, magazine-style layout - Eye-catching headlines The subsequent 8 to 10 pages will be dedicated to industry news, with a mix of articles and pictures. The final deliverable should be a fully f...alongside a clean, professional layout for the remaining content is crucial. Your eye for detail and understanding of effective user experience will be key to the success of this project. Here are some musts when bidding 1. You must bid and put this is NOT an Automated bid or I will delete it. 2. Place a bid on the cost of your work. Do not bid and then ask what my budget is. 3. If you have sample work that...

Hi there, We are looking someone who could help us in C T F. We will provide our source codes to analyze them and find vulnurabilities in them. More details will be given upon discussions. Please send your proposals as per description otherwise, you will be ignored. Thank you!

I am in need of an experienced Vue.js developer who can quickly fix my Vue 2.6 application. When I click on a button to go to another page it works fine in development but when I deploy it gives a 404 error. I need this fixed as fast as possible. When you respond to this posting please put "I CAN DO IT" at the beginning of your bid. I don't want to waste time with automatic bids that nobody answers. And please bid honestly and not low ball then ask what's your budget. I will upload the project when I find a person

I'm seeking an expert in bot development, with a specific focus on financial trading. Your task will entail adding functionality to an existing trading bot, designed to interact with the Robinhood app. Key Requirements: - The bot should operate based on user conditions primarily, with a minor reliance on its built-in algorithm. - After identifying a high point, the bot ...integration - Strong analytical skills to map out and incorporate user-set conditions correctly. The end product should be a well-calibrated, intelligent trading bot that enhances user profitability by buying low and selling high based on defined parameters. Time and effort investment will be rewarding considering the project's potential. Looking forward to your proposals. Existing files and codes av...

...beauty and youth. The logo should not only resonate with our direct customers but also be appealing enough to work in collaborative contexts, such as co-branded products or social media graphics. Deliverables: Logo in multiple formats (JPEG, PNG, SVG, and a vector file) Logo on a transparent background Black and white version Brand color palette with exact color codes Usage guidelines document detailing the typography, color codes, and proper use of the logo. Ensure all deliverables are suitable for both web and print use. Usage Rights: The final logo design will be fully owned by Brillisima. We require complete transfer of all intellectual property rights associated with the logo design and its elements, including any custom typography. The rights granted will allow for...

I'm looking for a skilled web developer to assist in creating an integrated PHP/HTML code for integrating Star Micronics Cloud print. Your responsibilities will include: - Understanding the requirements of the Star Micronics Cloud print - ...Star Micronics Cloud print. Your responsibilities will include: - Understanding the requirements of the Star Micronics Cloud print - Creating a detailed, clean, and functional code in PHP/HTML - Testing the code to ensure there is a smooth integration Ideal Skills: - Expertise in PHP and HTML - Experience with Star Micronics Cloud print integration - Skill in creating and integrating efficient codes. Please, only apply if you have a strong understanding of Star Micronics Cloud print and the ability to deliver a well-written, effective...

I'm searching for a seasoned full stack mobile application developer to create a highly functional mobile app. This application will be developed for both Android and iOS platforms. Key Features: - User Application: This will allow users to register and scan QR codes to obtain queue numbers. - Admin Application: This console will be used to call customers and manage respective details. Additional Attributes: - The user app will need integration for Push notifications, Location tracking, and Social media platforms. Ideal Skills: - Full Stack Mobile App Development - QR Code Integration - Real-Time Notifications Integration - Strong knowledge in Geo-Location features - Social Media APIs Experience with these features, particularly within queue-management systems, w...

I am seeking a competent scriptwriter and researcher who is knowledgeab...topics such as space, disasters, current events, world affairs, and environment. Ideal skills include: - Strong command of Hindi language - Proven expertise in scriptwriting - Skilled in researching and Sourcing. - Background in YouTube content creation is a plus. Freelancers who apply should provide the following: - Evidence of past work (preferably related to Indian content) - A written sample using a topic that I will provide. The right candidate should be able to create engaging scripts that are well-researched and accurate, yet easily comprehensible to the average viewer. Do you have the passion and the skills to help bring unexplored topics to life on our YouTube channel? I look forward to your...

I am a new pool builder in Atlanta looking align with a Professional (Structural) Engineer who is REGISTED IN ...feet), in-ground swimming pool, constructed from concrete. - Design Expertise: Freelancers should have experience in designing medium-sized, in-ground concrete pools. Expertise in understanding the durability, strength, and aesthetics of concrete pools is essential. - Engineering Skills: The freelancer needs to be proficient in producing comprehensive structural plans adhering to local building codes and safety standards. - Collaboration: I appreciate open communication. Regular updates and design revisions based on feedback are expected. Please showcase your previous work in similar in-ground concrete pool projects when placing your bid. Thank you in advance for ...