Get a Freelance Job

Hello Coders,

The task is to build a website.
The website already has a template and graphics so this task is mainly hardcore programming.

The site deals with coupons and deals and combines some MYSQL work and queries.
The bidder taking this project should be well knowledgeable in MYSQL , PHP , PERL and understand how to optimize DB queries.

The site will have about 10 pages.

The code will run queries against local MYSQL DB as well as external APIS (e.g. pricegrabber.com , Amazon.c…

We need a decent looking Avi to display whilst Mysql queries are running. Avi needs to be called via Microsoft VB6, Avi must continue to run/be animated whilst queries are running.

I recieved the below msg from my website provider stating that my database ‘ufhl’ is consuming excessive resources.

My database hasnt changed since i started my service with them 2+ yrs ago except that more info is added to the database as we play new games,seasons, etc..

I am looking at getting this fixed so my acct doesnt get suspended

thanks

Mike

Here is the msg
Dear Mike,

We regret to say that database ‘ufhl’ is currently consuming excessive resources on our servers which causes our server to degrade its performance affecting all other customers database driven sites that are hosted on this server. The database/tables/queries statistical information’s are provided below:

Database Name: ufhl

AVG Queries / logged / killed
42429/ 0/ 0

These larger queries are caused probably by the plugins installed thereby causing load to the server. We suggest you to disable some of the unwanted plugins/themes. The other way is to identify the top hitters and either optimize or replace them.

If the plugins/themes are not causing any issue, you can just look for any spam contents existed in the database and clear them up.

Apart from this, you can go for identifying the top hitters accessing the web pages. Stats tool is a best option to find the top hitters as well as the IP of the particular location. Depending upon the Bandwidth accessed, top hits and IP you need to take specific actions on them to optimize the database queries.

Sincerely,

The iPage Team

I’m writing some mysql queries for a reporting application and need some help in creating five different main queries.

It may be a combination of mysql with php to get the exact results.

I have a table with one transaction per row … it includes user_id, transaction id, date, product (and other fields which are unrelated)

The queries I need to create are:
(1) how many results for a particular month for new users (i.e. this is the first occurrence of that user_id)
(2) how many results for a particular month where there was no transaction for a user_id that, no transactions in the next two months, but there was in a previous month
(3) how many transactions for a particular month where the user has a transaction this month and the product ID for the current month is a “higher level” we have a separate table to determine levels) than in previous months
(4) how many transactions for a particular month where the user has a transaction this month and the product ID for the current month is a “lower level” than previous months
(5) how many transactions for a particular month where the user has a transaction this month, did not have one the previous two months, but has one at the same level prior to that 3 months ago.

Part one:

I would like to update prices in a database (part of Joomla/Virtuemart). I uploaded the new prices to a table “jos_entra_prijs” (see update.png). The prices that need to be updated are in “jos_vm_product_price” (see price.png) The two tables can be linked via “jos_vm_product” (see product.png).

jos_vm_product and jos_vm_product_price share product_id
jos_vm_product and jos_entra_prijs share product_sku (same as artikelnr)

For this operation I like to have the SQL queries.

Part two:

I like to extend the field product_s_desc (in jos_vm_product) with the text ” ean: ” and the content of field “ean-code” from jos_ean_prijs.

I would like the SQL queries to accomplish this.

I have 3 SQL queries (MySQL) which are taking a while to run when the tables they are based on have many records. I need these queries to be optimized as much as possible to return results very quickly. The queries are about 20 lines of code in total.

I will not be able to provide you with a copy of the database. But I will be able to provide you with create table scripts for the required tables.

Please ONLY respond if you are a very experienced DBA or query optimizer. Thanks.

Provide the SQL and a screen shot of each of the items below and submit them in a single .doc for grading.

(1) Create an SQL server database for the Kudler Fine Foods Virtual Organization. The name of the database should be KFF_UG.

(2) Create the following tables using fields listed below. In the Employee table, use the Employee ID as the primary key. In the Job_Title table, use the Job_Title_ID as the primary key. The primary key from the Job Title table appears as the foreign key in the Employee table. IMPORTANT NOTE: the Salary, Hire Date and Age may not be known when the data is first entered.
o Job_Title

I have a database application constructed using MS Access 10.

The Tables are already designed as well as the necessary queries to assemble the final reporting data. The raw data is input into an excel template and is then imported into Access. Once all the data is input we run a series of queries to assemble the final information for reporting.

What I need is a series of VB Codes that will allow the user to select a Menu Option that will:

1. Import the Excel worksheets to Access. (Will ask the operator for the path and name of the worksheet, via the browse function)
2. Check the imported data – only if the “Workshop Code” is not registered in the “Workshop” Table add a new record.
3. Check the imported data – only if each “Student” is not registered in the “Student” Table add a new record.
4. Append the Workshop data to a third table containing all workshop statistics.
5. For students that are attending their second or third workshops etc, check that the stored demographics are the same as the new record just imported and if they contain additional information, update the main student record.

Once the above is completed there should be a Menu System that will allow us to call the various queries that allow us to run pre-set queries that allow for detailed analysis. These queries are already designed and functioning.

If possible I would like to be able to give them menu picks that will allow them to provide variables to a group or set queries that will let them select or filter data to their specs. e.g. Select all workshops that where run at a specific campus or all workshops of a certain type or by semester, quarter etc. All of these categories are resident fields in the tables.

Thanks.

I need some guidance with a school project I’m working on. I have created an Oracle database and I’m creating a web page that queries data from it. I have connected to the dBase with a JAVA servlet and the web page should allow users to input data into the tables employing drop down boxes for the foreign keys fields. It will also run predefined queries. I will do the work but I need some assistance with how to set up the page to do this. I need sample code to have the page do this and retrieve the data from the database.

Create SQL Database and Queries based on provided data structure and tables. Instructions attached.

I need some guidance with a class project I’m working on. I have created an Oracle database and I’m creating a web page that queries data from it. I have connected to the dBase with a JAVA servlet and the web page should allow users to input data into the tables employing drop down boxes for the foreign keys fields. It will also run predefined queries. I will do the work but I need some assistance with how to set up the page to do this.

I need some guidance with a school project I’m working on. I have created an Oracle database and I’m creating a web page that queries data from it. I have connected to the dBase with a JAVA servlet and the web page should allow users to input data into the tables employing drop down boxes for the foreign keys fields. It will also run predefined queries. I will do the work but I need some assistance with how to set up the page to do this. I need sample code to have the page do this and retrieve the data from the database.

We’re looking for individuals only…please no large companies.

Must have a good working knowledge of XPath Queries, PHP, HTML, MySQL,and CSS.

This position includes finding comments on pages and parsing the URLs in them for regexp processing. Applicants will be given an example URL and will have to create the correct XPath query before they will be considered.

This is a part-time position lasting 1-2 weeks. Hours will vary daily, but we are estimating around 20-30 hours per week. Payment will be $20 per hour.

You must be reachable via Google, or MSN, or Skype, or Yahoo during the hours of 8:00AM – 5:00PM EDT (GMT -4:00) daily to discuss the project.

It is essential that you have a stackoverflow.com profile that we are able to look through. If not, please do not apply.

Please see my feedback from my previous company:

https://www.scriptlance.com/cgi-bin/freelancers/feedback.cgi?w=gargin

I need some guidance with a class project I’m working on. I have created an Oracle database and I’m creating a web page that queries data from it. I have connected to the dBase with a JAVA servlet and the web page should allow users to input data into the tables employing drop down boxes for the foreign keys fields. It will also run predefined queries. I will do the work but I need some assistance with how to set up the page to do this.

Create SQL Database and Queries based on provided data structure and tables. Instructions attached.

Howdy

Gather Data (via Script) from 7 sites to My Website.

Need you to write a script to gather data from these 7 websites (add a .com to the end of each except for Teambuy):
Groupon, LivingSocial, Teambuy.ca, KGBDeals, BuyWithMe, GiltCity, and BloomSpot.

Our developers have an API written for outside script to directly write to our database and it is attached.

A few other requirements:

-Queries to scrape those sites above must be done every 12 hours.
-All cities for all 7 sites above.
-Queries must be passed through proxies so as not to reveal our IPs.
-All fields to be scraped are listed in the api.
-Your queries must only scrape NEW listings that have not been scraped before.

Please go over all 7 sites carefully as they are quite different.

You may write the scraper in whatever language you prefer. The finished script will need to be installed on a vps that I have.

Looking to start immediately and will need fast turnaround on this.

We have a site that we have to start doing some GIS type lookups and such.

We need someone for a few hours to help ensure that we have the GIS setup correct in MYSQL, and can help the team optimize a few queries based on this new GIS data.

Refer to this article for more info: http://tinyurl.com/64jbj

Please ONLY respond if you have worked with this before. The LAST thing we need is another person who assumes they can handle this, yet never has.

Needed immediately. Open PMB with Questions

This is more of an exploratory posting to see if someone here can do what I need.

I have a # of tables in Excel that I need to bring into Mysql eventually, and need to do work on them in MySql which basically amounts to;
Merging duplicate records (some of which will be able to be done automatically based on some rule matches and some of which will need to be examined manually in a report.

Reorganize nested tables so that I can move records/sections around and/or copy them so they exist with multiple hierarchies.

Link records between tables.

The tables are all fairly large (10k records) and nested.

Linking/merging will be happening mostly on keyword and in some case semantic matches,

I have looked at products like Navicat that has decent QuertyBuilders and then some by DHTMLX that allows you to do things like expand/collapse nested tables easily, drag and drop to change nesting, etc.

Ideally I can list my needs in terms of Queries/Reports/Merging/Linking Rules which will include the ability to add to Compare/Merge/Ignore terms, view reports, etc.

So I think I am looking for someone who can tweak either of these apps so I have a series of custom Queries/Reports/Functions to allow me to do my work as I am not a Sql/db expert but know how I need to combine/merge/re-order and it happens in the background.

I have been optimizing some mysql queries, but I feel like they can be optimized more.

I have experimented with many possibilities including indexes. I am not a MYSQL newbie. I need a mysql expert to make the queries lightning fast.

Maximum of 5 queries of 620 characters.

I have been optimizing some mysql queries, but I feel like they can be optimized more.

I have experimented with many possibilities including indexes. I am not a MYSQL newbie. I need a mysql expert to make the queries lightning fast.

Maximum of 5 queries of 620 characters.

I have a website with a number of slow queries. 4 of these have been identified, but there are others. I am looking for a programmer who is very experienced with mySQL and php and can optimize these heavy queries, add tables as needed, rewrite queries as needed, or make other changes in order to speed up the load time of specific pages.

I expect the job to take 24 hours of work, please bid on this amount of time. If the project requires more hours we can create another project.

Feel free to ask questions as needed and to bid.
Thanks!

We are looking for experienced Excel/VBA Web Queries Programmers for a project. The scope of the project will be as follows :

1. Base on a list of given symbols, extract and export data from a
URL into excel spreadsheet.

2. Add in a few columns in the excel spreadsheet with same
conditional values.

3. Base on a list of given symbols and date range, extract and
export data from a URL into a second excel spreadsheet.

I will either require A macro to store the source code of your programming or whichever means you see deems fit.

This should be a simple project if you know Excel/VBA programming and Web Query.

Thank you,
Leslie

Perl and MySQL coding. Increase the speed of Mysql Queries

I have a site that functions (PERL), but using MySQL PERL DBI search FULLTEXT BOOLEAN is slow, some query’s words slower than others. Some query’s take 25 seconds to load a page. The same happens in phpMyAdmin with the same SQL statements.

I need help to increase the Query speed to the minimum possible.
I need to be able to achieve this with Shared hosting, (so any coding should have minimal impact on the host servers), using cPanel and phpMyAdmin.

I will require explanations of any changes and why they work faster.
The database in use at this time is about 1Mb, about 2Million rows), but it will need to be over 2gb of data once the code functions at full speed.

Any charges quoted must be full costs and complete to fix the slow queries. No extra charges are available. That is Full costs MUST be fully known and complete before any job is posted for me.

Data is poor quality e.g. For example not normalised, at this time and uses some REAL variables for BOOLEAN values.

Full and complete total costs/pricing must be stated.

Perl and MySQL coding. Increase the speed of Mysql Queries

I have a site that functions (PERL), but using MySQL PERL DBI search FULLTEXT BOOLEAN is slow, some query’s words slower than others. Some query’s take 25 seconds to load a page. The same happens in phpMyAdmin with the same SQL statements.

I need help to increase the Query speed to the minimum possible.
I need to be able to achieve this with Shared hosting, (so any coding should have minimal impact on the host servers), using cPanel and phpMyAdmin.

I will require explanations of any changes and why they work faster.
The database in use at this time is about 1Mb, about 2Million rows), but it will need to be over 2gb of data once the code functions at full speed.

Any charges quoted must be full costs and complete to fix the slow queries. No extra charges are available. That is Full costs MUST be fully known and complete before any job is posted for me.

Data is poor quality e.g. For example not normalised, at this time and uses some REAL variables for BOOLEAN values.

Iam looking for a MYSQL guru to optimize a couple of slow queries, please don’t bid on this project unless you are a expert in mysql and can dramatically reduce the time these queries take.

Below are the problem queries taken from the slow query log.

# Query_time: 8 Lock_time: 0 Rows_sent: 8 Rows_examined: 378201
SELECT *, COUNT(file_id) AS image_count FROM uploader_userfolders JOIN uploader_userfiles USING(folder_id) WHERE file_isimage=1 AND folder_i$

# Query_time: 16 Lock_time: 3 Rows_sent: 30 Rows_examined: 682764
SELECT pm.pfile_id, pm.mfile_id, pu.*, mf.file_description, mf.file_extension, mf.file_date, mf.file_key, mf.userid, mf.folder_id,uf.*, MAKE$
MAKE_SET( 1 |2, COUNT(mf.file_id), COUNT(pf.file_id) ) AS image_count,
MAKE_SET( 1 |2, pf.file_name, mf.file_name ) AS file_name,
MAKE_SET( 1 |2, pf.file_location, mf.file_location ) AS file_location,
MAKE_SET( 1 |2, pf.file_size, mf.file_size ) AS file_size,
MAKE_SET( 1 |2, pf.file_views, mf.file_views ) AS file_views,
MAKE_SET( 1 |2, pf.file_lastview, mf.file_last_view ) AS file_lastview,
MAKE_SET( 1 |2, pf.file_isimage, mf.file_isimage ) AS file_isimage,
MAKE_SET( 1 |2, uf.folder_name, pu.upload_name ) AS set_name,
ud.username,ud.avatar
FROM uploader_pmfiles AS pm
LEFT JOIN uploader_puploads AS pu ON ( pm.pfile_id = pu.upload_id )
LEFT JOIN uploader_pfiles as pf USE INDEX(upload_id) USING(upload_id)
LEFT JOIN uploader_userfiles AS mf ON ( pm.mfile_id = mf.file_id )
LEFT JOIN uploader_userfolders AS uf ON ( mf.folder_id = uf.folder_id )
LEFT JOIN uploader_users AS ud ON ( mf.userid = ud.userid )
WHERE (pu.upload_ispublic = 1 OR uf.folder_ispublic = 1)
GROUP BY mf.folder_id, pu.upload_id
ORDER BY pm.file_date DESC
LIMIT 0, 30;

Unfortunately our online email support representative is leaving us due to a change in their personal life. As a result, we need a replacement and we need it FAST!

You will need to have extensive knowledge in our product which will require you to read the web site, the FAQ, the Guides, Training Manuals and Training Videos. There will be of course questions you will not know the answer too, which we will assist you with. This is will be a learning curve, however, you will be required to do 95% of it yourself.

EXPERIENCE in customer service is required. Perfect English is required. You will be answering an average of 100 emails. (depending on demand). This is a long term position.

You will handle pre sale queries, general queries and technical queries for now. As you become more familar you can handle additional departments.

A CV would be appreciate per each applicant. Payment will be made $150 bi-weekly, via PayPal.

Please respond with your CV and as much information about you and your background as possible.

Work Hours are from: 11:30am-7:30pm EST, Mon.-Sun. (Work From Home)

EXPERIENCED IS REQUIRED. ENGLISH IS A MUST. AMERICAN IS PREFERRED.

i have a joomla 1.5.3 site running in php 5.2.9 and mysql 5.0.81 …i get around 18-20,000 visitors a day (300-350 at a time) and growing steadily, since there were load issues as mysqld was causing over 35% load most of the time. My VPS RAM – 1.5 GB GARUNTEED (3 GB BURST). The main thing causing problems i believe are slow queries which do not use indexes/proper indexes ..many scripts said that many JOINs couldn’t use indexes properly, so i want a person who can optimize my indexes and queries for optimal performance! (i have the mysql slow query log to help) …also over 42% of the temporary tables were created on disk, even after i kept increase tmp_tables_size in my.cnf which leads me to believe this is because of BLOB and TEXT columns, so this is part of fixing/optimizing queries and indexes! please don’t bid ridiculously high! don’t bid if u dont have sufficient knowledge or don’t believe you can do this 100%, i will only fully pay once i can see(through tests) that ur optimization has worked!

i have a joomla 1.5.3 site running in php 5.2.9 and mysql 5.0.81 …i get around 18-20,000 visitors a day (300-350 at a time) and growing steadily, since there were load issues as mysqld was causing over 35% load most of the time. My VPS RAM – 1.5 GB GARUNTEED (3 GB BURST). The main thing causing problems i believe are slow queries which do not use indexes/proper indexes ..many scripts said that many JOINs couldn’t use indexes properly, so i want a person who can optimize my indexes and queries for optimal performance! (i have the mysql slow query log to help) …also over 42% of the temporary tables were created on disk, even after i kept increase tmp_tables_size in my.cnf which leads me to believe this is because of BLOB and TEXT columns, so this is part of fixing/optimizing queries and indexes! please don’t bid ridiculously high! don’t bid if u dont have sufficient knowledge or don’t believe you can do this 100%, i will only fully pay once i can see(through tests) that ur optimization has worked!

i have a joomla 1.5.3 site running in php 5.2.9 and mysql 5.0.81 …i get around 18-20,000 visitors a day (300-350 at a time) and growing steadily, since there were load issues as mysqld was causing over 35% load most of the time. My VPS RAM – 1.5 GB GARUNTEED (3 GB BURST). The main thing causing problems i believe are slow queries which do not use indexes/proper indexes ..many scripts said that many JOINs couldn’t use indexes properly, so i want a person who can optimize my indexes and queries for optimal performance! (i have the mysql slow query log to help) …also over 42% of the temporary tables were created on disk, even after i kept increase tmp_tables_size in my.cnf which leads me to believe this is because of BLOB and TEXT columns, so this is part of fixing/optimizing queries and indexes! please don’t bid ridiculously high! don’t bid if u dont have sufficient knowledge or don’t believe you can do this 100%, i will only fully pay once i can see(through tests) that ur optimization has worked!

i have a joomla 1.5.3 site running in php 5.2.9 and mysql 5.0.81 …i get around 18-20,000 visitors a day (300-350 at a time) and growing steadily, since there were load issues as mysqld was causing over 35% load most of the time. My VPS RAM – 1.5 GB GARUNTEED (3 GB BURST). The main thing causing problems i believe are slow queries which do not use indexes/proper indexes ..many scripts said that many JOINs couldn’t use indexes properly, so i want a person who can optimize my indexes and queries for optimal performance! (i have the mysql slow query log to help) …also over 42% of the temporary tables were created on disk, even after i kept increase tmp_tables_size in my.cnf which leads me to believe this is because of BLOB and TEXT columns, so this is part of fixing/optimizing queries and indexes! please don’t bid ridiculously high! don’t bid if u dont have sufficient knowledge or don’t believe you can do this 100%, i will only fully pay once i can see(through tests) that ur optimization has worked!

i have a joomla 1.5.3 site running in php 5.2.9 and mysql 5.0.81 …i get around 18-20,000 visitors a day (300-350 at a time) and growing steadily, since there were load issues as mysqld was causing over 35% load most of the time. My VPS RAM – 1.5 GB GARUNTEED (3 GB BURST). The main thing causing problems i believe are slow queries which do not use indexes/proper indexes ..many scripts said that many JOINs couldn’t use indexes properly, so i want a person who can optimize my indexes and queries for optimal performance! (i have the mysql slow query log to help) …also over 42% of the temporary tables were created on disk, even after i kept increase tmp_tables_size in my.cnf which leads me to believe this is because of BLOB and TEXT columns, so this is part of fixing/optimizing queries and indexes! please don’t bid ridiculously high! don’t bid if u dont have sufficient knowledge or don’t believe you can do this 100%, i will only fully pay once i can see(through tests) that ur optimization has worked!

I’ve tried everything to write this query myself with no luck, so I’m giving up and hoping that a professional here can write it for me. I will deposit funds for the winning bidder into escrow and release them for you when I see that the query works. Or if you don’t want escrow, I will pay when the project is complete and the query works. I need to get this query as soon as possible, so this will be a quick auction. Hopefully it won’t take a professional db developer very long to write it, as I would think this is actually a common task. Here is what I need:

The database I use is MySQL 5 (my application is in PHP 5). My application stores multiple payment amounts paid by different customers to different companies. Assume that each customer

Hello,

Unfortunately our support representative is leaving us due to a change in their personal life. As a result, we need a replacement and we need it fast. We pay $1 per answered ticker (this does not include mulitply relies to the same ticket).

You will need to have extensive knowledge in our product which will require you to read the web site, the FAQ, the Guides, Training Manuals and Training Videos. You will also have access to a demo version of the product and a demo account so as to answer technical queries. We will provide you access to our Knowledge Base to help you find instant answers. There will be of course questions you will not know the answer too, which we will assist you with. This is will be a learning curve, however, you will be required to do 95% of it yourself.

Experience in customer service, and ticket support systems is required. Perfect English is required. You will be answering an average of 100 tickets. (depending on demand). This is a long term position.

You will handle pre sale queries, general queries and technical queries for now. As you become more familar you can handle additional departments.

A CV would be appreciate per each applicant. Payment will be made once per month, via Check, PayPal or Bank Wire. PayPal is preferred and we will cover your PayPal fees.

Please respond with your CV and as much information about you and your background as possible.

Again, $1 per ticket. 100 Tickets per day – $500 per week average.

Thank you.

I am looking for a programmer to create a search script (using PHP) for my web site that will query an existing MySQL database, and return the results to the user. The MySQL database is a simple database of about 2,150 products and includes variables such as: product_name, price, URL, product_ID, category, subcategory, sub_subcategory. There are two parts to this project. The actual search feature that the end user will see, and reports that the only Webmaster will be able to see.

SEARCH: The search script needs to return results by relevance, i.e. the results must show in ascending order the products/categories/subcategories/sub_subcategory that have the most number of search terms matching words in those corresponding tables. The search results must be presented to the user in an organized into category, subcategory, and sub-subcategory — with each being a clickable hypertext link to the respective page (excluding subcategories). The search results must be presented to the user in an attractive/intuitive way and integrated with my web site’s template. (No graphics knowledge will be required for the integration, only basic HTML and JavaScript knowledge as my template uses some JavaScript.)

Because the search term(s) input by the user will be displayed back to the user on the

The Problem
It’s the first day of class and you are barely awake. You are hoping to snooze through a typical syllabus day when your new teacher commands you to get up and find the person in the room with the closest birthday to yours. Luckily, you’ve taken AP Computer Science already and realize that the key to solving the problem is to sort EVERYONE by their birthday, and then simply look directly to the left and right of you (the birthday that occurs immediately before and after yours) and see which of the two is closer. If you on the end of the list, you have to check with the person at the beginning and vice versa.

In order to solve this problem, you’ll get several different classes from an input file. Each class will have several queries. You are required to implement either Merge Sort of Quick Sort in the solution of your assignment.

Input File Specification (birthday.txt)
The input file has a single positive integer, n, on its first line, specifying the number of classes in the input file.

The first line of each input file will have a single positive integer k (k < 1001), representing the number of students in the class. The next k lines will have information about each student. Each line will have the following information separated by spaces: first name, last name, month, day and year of birth. All names will only contain uppercase alphabetic characters and be no longer than 29 characters long. The month will be represented in its full spelling, in uppercase letters. The day and year will be the appropriate integers. You are guaranteed that all of this information is valid. (Thus, no April 31st will appear, etc.) It is also guaranteed that each full name will be unique. (Namely, no two people in a class will have the exact same first AND last name.)

Following those k lines will be a line containing a single positive integer m (m < k), representing the number of queries for that class. The following m lines will contain the first and last name (separated by a space) of the student in question. (Your goal will be to find the name of the student with the closest birthday to the queried student.)

Output Specification
For each input class, print out a header with the following format:

Class #c:

where c represents the day of the simulation (1 ≤ c ≤ n).

Follow this with a blank line.

The following k lines will answer the queries for that class in the order they were given. For each of these queries, output a single line with the following format:

FIRST2 LAST2 has the closest birthday to FIRST LAST.

where FIRST LAST is the name of the queried student and FIRST2 LAST2 is the name of the student with the closest birthday to FIRST LAST.

To avoid ambiguity, sort the students in the following manner:

1) By birthdate, ignoring the year.
2) To break ties between students with the same exact birthdate, use last name as compared by the strcmp function.
3) To break ties where both #1 and #2 are the same, use the first name, which in these cases, is guaranteed to be different.

To further avoid ambiguity, if both the person who appears right before and right after the queried person are the same number of days away (in birthday) as the queried person, always choose the first who comes AFTER the queried person in the array. Note: for these purposes, February 29th won’t count as an actual day, unless someone in the class has that birthday. For example, if the queried person’s birthday is March 1st, the person right before her has a February 28th birthday and the person right after her as a March 3rd birthday, then the person with the February 28th birthday is considered the closest (1 day way) as compared to the March 3rd birthday (2 days away). BUT, if there IS a February 29th birthday in the class, then that does count as a day.

Put a blank line between the output for each case.

Implementation Restrictions
You must store all the relevant information about a student in an appropriate struct. You must implement either Merge Sort or Quick Sort. You must follow all the tie-breaking procedures described above.

Sample Input File
2
3
SAM MALONE MAY 3 1961
DIANE CHAMBERS AUGUST 16 1970
NORM PETERSON DECEMBER 12 1955
2
SAM MALONE
NORM PETERSON
4
DAN MARINO SEPTEMBER 15 1961
JOHN ELWAY JUNE 28 1960
JOE MONTANA JUNE 11 1956
DAN FOUTS JUNE 10 1951
1
JOE MONTANA

Sample Output
Class #1:

DIANE CHAMBERS has the closest birthday to SAM MALONE.
DIANE CHAMBERS has the closest birthday to NORM PETERSON.

Class #2:

DAN FOUTS has the closest birthday to JOE MONTANA.

Please write in C.

ok so i am using JOOMLA 1.5.3(don’t tell me to upgrade because i won’t), and i just go a new vps and have optimized all i could, and recently i ran mysqltuner.pl and tuning-primer.sh scripts through ssh in my VPS and both recommened that i need to Adjust my join queries to always utilize indexes, and also about 45% of temporary tables are created on disk, i tried to increase the memory for tmp tables in my.cnf but it didn’t really fix the problem since its still around 45%, so i need someone to fix these two things, or which ever one of these u can! it shouldn’t be too hard to do for some1 experienced in this, please don’t bid above my limit as i won’t choose any1 above it, although if the work is done nice, and all problems are resolved then ill throw in a lil extra!

hi it seems mysql was using too much cpu so i enabled slow-queries-log and i since im not an expert i want some1 to check and fix the queries using the top resource in mysql! this should be easy enuf for some1 who noes what they are doing have have experience, so dont bid more than my max cuz thts my budget and i cant choose u if u bid over tht :/

Had a custom script written in PHP that Queries MySQL. It is for a pharmacy locator. The script queries a couple tables in the database. One is for zip codes, the other a list of pharmacies. It uses latitudes and longitudes to find pharmacies within a given radius (Up to 25 miles) The script seems to work perfectly, but only HALF the time. The other half of the time it just grinds with no timeout or anything. I need someone with a good knowledge of PHP and MySQL to troubleshoot so it works ALL the time.

Here is a link to the script to see: http://174.132.77.158/~freedisc/index.php?option=com_wrapper&view=wrapper&Itemid=85

I’ve checked with hosting provider, and error logs show no errors. I do however see this in PHP myadmin: 3,021.06 M The number of requests to read the next row in the data file. This is high if you are doing a lot of table scans. Generally this suggests that your tables are not properly indexed or that your queries are not written to take advantage of the indexes you have.
brb
Sent at 3:58 PM on Wednesday
Chris: is the server linux or windows?
Sent at 4:00 PM on Wednesday
me: linux
Sent at 4:14 PM on Wednesday
Chris: yea I cant ssh. Maybe ask the hosting company for logs
me: yeah im submiting ticket now
Sent at 4:16 PM on Wednesday

Maybe indexed?

Hi,

I need someone who is proficient in PHP, SQL, and CSS and AJAX.

I want you to use this: http://bit.ly/nrNkv to create a clone of this: http://bit.ly/QBsVz

Readymade scripts to do this are available for less than $10, so why am I paying for a custom implementation? Because I need it to be extremely efficient, light on server resources, excellently coded and documented, fast, and importantly, I need it to comply with the Terms of Use (see the restriction about the number of queries allowed per second — I need it to comply with this limit through intelligent managing of user queries. Users can be kept waiting through Ajax etc.)

Secondly, you will have to integrate the script into two HTML pages I designed (one the search page, one the results page), and use CSS to integrate a custom search button I have designed into the HTML page too.

This is a fairly simple job and I don’t think it will take more than 2-3 hours. But you must be a very capable PHP programmer, who knows what he is doing, and who is capable of making this script very light on server resources and fast. Most importantly, it needs to comply with the usage guidelines (see the ‘API Basics’ PDF file on the first bitly link).

PS – Take a good look at the second bitly link above and note all the features (including limiting number of queries for an IP per day, and pointing out possible undesirable domains through color etc.)