Excel – Mysql + Lookup

Excel – Mysql + Lookup
I need someone to create a small mysql table and import an excel spreadsheet into it. My website is a WordPress site. On the main page, I want visitors to enter a 6 digit code. This code is one of the fields in the database.. After they enter the code, I would like to have your code pull up the sql row and display 6 pieces of data on the screen.

That’s it!

Thanks in advance.

Need 30 Articles Asap

Need 30 Articles Asap
I need 30 articles of 250-400 words each for an insurance blog. I need those submitted at a minimum 2 each day, and to be completed within no more than 2 weeks. If I find a good bidder, I will have more similar projects. The Payment will be in escrow upfront.

These articles will be related to auto insurance, home insurance, life and health insurance. If you’re not familiar with writing financial related articles, please DO NOT BID.

The articles have to be written in American English, and I WILL READ EVERY WORD to ensure that they are written properly — Preferably in short paragraphs with bullet points and easy to read. I will provide a list of keywords as each article will focus on a specific keyword for SEO.

I can currently afford $2 per article, and YES they can re-written articles to be fair. But they must be readable and pass Copyscape.

So my max payment will be $65 at $2 per article, and $5 for your SL fee.

Psd To Html Website

Psd To Html Website
we are a website development company. We have a website in PSD (home page and 4 inside pages) that we need :

– converted into HTML with sample content, we will enter the real content. Images to be used in the header will be provided and these we be put in place by you.
– main image on home page needs to be flash transition, however, we have the FLA file to be used. This has been selected as it works with our CMS. A simple flash as in: http://dev14.webberz.com/index.php
– we also provide the javascript to be used for the navigation. This has been selected as it works with our CMS. A simple navigation as in: http://dev14.webberz.com/index.php
– the galley page must use some code. e.g. javascript that allows the user to scroll the list from left to right or roght to left.
– in page links need to have the hpyerlink code
– HTML must be coded keeping in mind that it must integrate into a CMS (we will do that), e.g. a list of articles must have individual tags or table rows so it can be auto-generated from the CMS

Requirements
– programmer must be available during 6am and 2pm EST
– after delivery we will need access to you via chat to communicate and make changes quickly i.e. at the same time as we requests the changes .. in real time
– We need this done in 2 days

pages attached

Portfolio Community Edit 2

Portfolio Community Edit 2
I just hired a programmer to make changes to my site: www.modelhighway.com if you visit the site, you will see the errors I need fixed, and some additional features added. here is what needs to be fixed:
http://www.modelhighway.com/castings.php
the spacing is real far away from each other

http://www.modelhwy.com/castings.php
this is how the castings.php should show up

http://www.modelhighway.com/myfriends.php
same spacing issue as casting

http://www.modelhighway.com/pics.php footer is too high up, should be on bottom

toggle work safe mode is not working

http://www.modelhighway.com/blog_posted_by.php
footer is too high on page, should be on bottom

http://www.modelhighway.com/preferences.php adjust left margin please

after the search results, the very bottom grey bar is on the left of the screen, needs to be in centered
look on the very bottom

http://www.modelhighway.com/makeshoutout.php no left margin

search page is messed up on internet explorer.

I need a 2257 compliance link added when a member wants to label their photo as nude,

I need an option to make photo avatar on the drop down when a member edits their photos

I want to make the new members uplaod at least 5 images in order for their account to be approved.

I want ad spaces through out site, on top and bottom and right column where there is space, and be able to easy change the ads by copy and paste code within my admin panel.

I want List feature for members to add lists, and have them show up on under their photos, so if a members wants to create a artistic nude list, the link shows on the bottom of the photo, and it links to a page showing all the members who they added to the list.

on blogs page, and casting page, and search page, I would like it to look nicer, like lines on top/bottom of each one seperating them.

would like header bar wtih links not so thick, and be like myspace where when you click one, it’s not hyperlink rollover, but hyperlink indents.

need to have option where members can add a MH# for credit for photos they upload

worksafe mode needs to work, so the images labeled as nude or adult don’t show up, unless work safe mode is off.

need travel/availability notice for members

on search page, needs to be like: modelhwy.com and have a button for advanced search which will go to another page with all the current search criteria and more, like it currently has. but needs to work.

Programmer needs to understand there are a few other errors not listed, here, so I want the understanding that any errors I find during the job, must be fixed as part of this project.

when I say errors, I mean page layout problems.

any additional features, I will negotiate for a fee.

I am seeking a programmer than can be trusted to make changes for future request at a reasonable price.

I spent all the money I had to invest in this site, but now I have to hire someone to fix the other programmers crap.

Please be aware when placing a bid.

would like to be able to easily change logo from admin if possible.

I want a programmer who, while we are working, if I say can you do this or that, they do it and don’t have an issue. like change a background color on a table, or add something here or there, small things.

would like a differnt layout of buttons on members My Account view.

Need a photo of the day contest with voting option and results page.

I would like to try a couple differnt color schemes and background colors also for the overall look of the site, would like some paitence with this.

Once a bid is accepted, I don’t want to worry about any extra charges until the project is complete and we talk about othe things not listed here.

I also need search engine optimization, would like to change my meta data.

that’s all I can think of, so I guess that’s it.

Good luck.

there are a few changes I would like to make in member profiles also in regard to layout and buttons/tabs for details about work interests, bio/history.

The whole layout needs a bit of a face lift. Everything I am asking for, must meet my approval. Thank you.

Joomla Site 2

Joomla Site 2
I need someone to design an adult website in Joomla. I would need the proper plug ins to upload video, photos (and thumbnail galleries) as well as write a review of weekly videos that are updated.

You can use a template but pretty much need about 3 columns with the multimedia plug ins. I don’t know Joomla very well so I am looking to just log in and be able to upload video and pictures, as well as text comments, very easily.

Content Writer For A Website

Content Writer For A Website
We are looking for writers who can produce error free content for a website offering psd to html conversion service.The content should contain the keywords(That are supplied) with the specified density

Also we are looking to hire writers with some experience who are aware of the importance of deadlines.

The total number of webpages to be written should be 4-5.

1. Must be an EXCELLENT Writer with an EXCEPTIONAL command of written English!

2.Content submitted should be of high quality and unique.

3.Content of every page should pass copyscape(don’t bid if you are not aware of copyscape)

4.Each webpage content should be proofread for spellings,typos,grammar and word count.

5.Content will be rejected if its not according to the required format,if its showing results on copyscape, word count is not met and if it is grammatically poor.

The payment for every 500 word writes will be $2.The payment is made according to wordcount.

If you are interested please leave a PM detailing a small writeup that why you believe that you’re the best person or team for this job.

Need Joomla Design Expert Now

Need Joomla Design Expert Now
Hello,

For my custom Joomla design I need a Joomla expert to fix something.

The website is www. ri mo host.nl without the spaces.

The menu is not working as it should be.

As you can see,there should be a submenu when you go over a menu button,but this doesn’t work.

Find here an example how it should work:

Home

The job has to be done immediately,I will pay you $15 after the job is done via Paypal.

Deangraziosi.com -similar Site

Deangraziosi.com -similar Site
Ok I’ll take my time and explain this is some detail. I DO NOT want a clone of this site, I want someone to create something fairly similar in terms of functionality. The content will be all mine and added overtime.

Dean Graziosi is a Real Estate Investor and gives his members inside information about how to make money in real estate

I am a internet marketer and I wnt to show people how to make money online through internet marketing.

I want members to be able to sign up and interact with each other as well as me. I will be selling products just like the deangraziosi.com site.

I would really appreciate it if before you place a bid you check out the site for yourself and get a feel for what its all about.

Phpprobid Commission System

Phpprobid Commission System
I’m looking for an automated and secured system for my sales commission on the PHPProbid 6.07 auction platform
– at the end of the auction: invoice mail to seller with commission to pay (now invoices are made only after payment and mails aren’t send with detailed commission to seller – only ‘object sold’ confirmation)
– automatic mail with invoice (pdf f.e.) after paying setup fee (only for direct payments)
– automatic mail with invoice after paying sales commission
– overdue clients shouldn’t be able to start another auction until invoices are paid
– all current auctions of overdue clients should be listed, with the option to delete or put on hold auctions until invoices are paid (can this be automated, let’s say for all clients who are 10 days overdue are put on-hold until they bring their account to current status)

Cron Mailer Fix

Cron Mailer Fix
I have a script that is uses multiple mail servers and will not
work. I used to work but I am not sure what happen.

When you create a message to go out it creates like queue at the bottom of screen. When the cron runs it takes the message away. but it is not going out. Everything in the mysql database is correct. I believe
the error is in the cron_mailer.php file.

I have included it here..If you can fix please bid. I need this done quickly.

News And Trading Site

News And Trading Site
Please see attached.

Phase 1 – News Portal
Custom startpage like http://myweb.phpcow.com/ (this will be referred to as MyWeb going forward) with all the features and functionality on there.

Changes to above:

“Add content” button should open with the following options not the ones on MyWeb: Search, Add RSS feed, News Directory, Add Widget, Widget Directory.

Search: have a search box where users can search across the news directory and widget directory to find content that they may want to add. Just a simple keyword search to search across feed title, feed source etc. present search results in a list with “add” button next to each result. Ussers can press add to add to their page.

Add RSS Feed: should be the same as the “add a feed” button where users can simply enter the url of any RSS feed to add it to their page.

News Directory: is basically the same thing as the “feed directory” where users will see a tree structure of feeds contained within various categories. Admin should have the ability to manage list of feeds and categories. This should be able to have up to 1000+ RSS feeds and be scalable to add more if required.

Add Widget: ability for users to add any online widget to custom startpage by entering the widget source code. To see an example of this please go to netvibes.com, select add content, then essential widget, then on the third page of widgets you will find one called UWA Module. This UWA Module lets users enter the code to add a widget to their custom page.

Widget Directory: Admin should also have the ability to make a pre determined list of widgets available for users to add. Like the News Directory this should be scalable and be able to handle 100+ widgets.

Enter Page Title Here: This is not required. I will have my company name/logo across the top. You do not need to design this just to provide the space.

Top Menu: should be the same as MyWeb with Search, Settings, Login, Register, Newsletter (details below) and one additional link to “Chartdesk” which should open the online trading system (Phase 2) in a new window.

Page Tabs: Page should open with one preset page (admin to determine which feeds/ widgets this page should have by default). And there should be a tab to “Add Page” to add additional pages. Users should have the ability to add up to 5 page tabs

Tab options: should be the same as MyWeb but the icons should be replaced with about 20 different ones that I will provide.

Feed Options: This should be the same as it is on MyWeb with all the options to change title, colour, view details etc.

Newsletter:
Either of the options below will be sufficient:
1. Users should be able to email their custom start page: for example all the rss feeds they have on their startpage as well as their selected widgets should be emailed to them daily (in one email). Users to be able to select time for email delivery and also confirm their timezone.
2. If, above is not possible, users should have the ability to set up a newsletter. Newsletter option to include:
• Select rss feeds from feed directory list or add custom rss feed (up to 10 feeds per newsletter),
• Select article view: headline and article or headline only for each newsletter.
• Select number of articles (5 or 10) per feed
• Confirm email address (should already be populated with users email address)
• Select email delivery time and time zone. Not sure if newsletter systems allow this of if its easier for all newsletters to be sent at one time? I am open to suggestions here

Register:
To register users will need to enter the following:
Firstname
Lastname:
Email
Telephone
Company
Address
Postcode
Country
Username:
Password:
Security code: enter security code (from automatically generated picture of a random code)

There should be automatic email confirmation link sent to users upon completion before user registration is completed. Only after this should users be allowed to login to their account.

Admin account:
Admin should have ability to manage all users profiles, make changes, add, remove etc. Also ability to export/import list of all users. Manage all feeds, widgets, default start page, newsletters etc

Advertising: Admin should have ability to add adverts to news portal as well as newsletter. For newsletters adverts should be placed at the header and footer. For custom startpage adverts should be placed in the footer or between rss feeds in any column (2 adverts max)

Source code: Need to provide full source code and also allow for changes to Header and footer which I can do using dreamweaver.

Phase 2: Trading System
Online trading software exactly like http://www.freestockcharts.com/ with all the features detailed.

This will be a subscription based service you so need to integrate payment method (paypal or something similar) and provide access to all features only after payment has been confirmed. Users that don’t subscribe should be able to view all the features but only with a hand full of stocks. All the rest should require a subscription.

Menu along top: File, Scan, Brokers, Tools, View & Help should be replaced with the following:

File: As it is with options to search for symbols, create/save/load layout etc
View:
– view/close scrolling ticker or not
– view/close full screen chart
Newsdesk: Should open the news portal (phase 1) in a new browser
Alert: Same as the “alert” button on the next menu down
Subscribe: Should open a new browser with subscription options. 2 types of subscriptions, 1 for web access and an additional for web and mobile access (Phase 4).
Company Name: with sub menus for company overview, contact. Links to be provided. Links to open a new browser.

Second menu: (below scrolling stocks) Stocks, Notes, Profile, Friends & Alerts should be replaced with the following:
Stocks: Should show all the stocks as it is.
Platts: Should show external data (Phase 3)
ICE: to show Intraday Futures Chart from http://data.theice.com/DataDistribution/WebPanels/Default.aspx# within this panel
Movers & Shakers With tabs for each of the following:
– Sector Summary: to show sector summary from http://www.google.com/finance?tab=we.
– Trends – Popular Gainers/Losers similar to google finance
– Price – Gainers/ losers similar to google finance
– Market cap – as above
– Volume – as above

The following features below are on freestockcharts.com and I would like them on my site:

SCROLING STOCKS
Exactly as on freestockcharts with ability to view any custom portfolio

PORTFOLIO
Exactly as on freestockcharts with
– ability to have several tabs with different portfolios.
– Ability to have up to 10 portfolios.
– Each portfolio may have up to 40 stocks.
– Price increase should be in green, decrease in red
– Ability to add/remove columns
– Ability to expand/contract panel

CHARTS:
– Ability to resize all panels
– Ability to drag chart to expand date range
– Ability to analyse charts with many technical indicators – around 60 available on freestockcharts.com. You can see by pressing the “add indicator” button on chart. More details on technical indicators and source code for .net at http://forexsb.com/library/source/ (I haven’t tested this one to see if it works or not but there are a number of other sources for the source code for these indicators).
– Ability to add several indicators to one chart
– Ability to change frequency of data on chart: minute, hour, daily monthly etc
– Ability to chart several prices on one graph
– Ability to customise each graph or elements within graph – change/add label/text, change colours etc
– Ability to copy chart as image
– Ability to export data to excel
– Ability to export data with DDE link so previously exported data can be updated
– Change view/ tabbed view buttons

Drawing Tools: As on freestockcharts.com

LATEST NEWS: This should open the News Directory section (from Phase 1) and users should be able to choose which rss feeds to view within this panel. Or view all news from any news category. Ability to expand/contract panels

Data:
For the underlying stock data please use a free source like Yahoo finance, Google finance or something similar. You will need to set this up so its always updated with the latest data.

Phase 3: External Data
Additional Data for online trading software above: Daily pricing data will be provided via FTP or CSV including 3-4 updates daily. A CSV file will be provided with full history to start this off and the daily data needs to be added to this going forward so history builds up.

Data will be made up of several categories (approx 70), Each category may have anything up to 50+ different sets of data. Each set will have a high, low and mid price, as well as date, description, data symbol and 3-4 other fields.

Permission to access data: This entire section needs to be permission based. Admin should have full control of which categories of data a user may have access to. This is a subscription based element but subscriptions will be managed elsewhere. However, Admin needs to be able to monitor when a user was given permission and for which catagories. Admin to control all permissions (by user) and have ability to give access/terminate access at will.

When a user (that doesn’t have permission) clicks Platts a message box should appear with a note “Not Available – To subscribe click here (link to be provided)”. Link should open in new window.

Data search: users should have the ability to search for data using the data symbol or description (exactly the same as File/Search for Symbol/company ) and be presented with a list of options which they can select from. This should search across description and symbol fields

Data visualised in exactly the same format as the Stocks with all the formulas and analysis tools as they are. When a data (price) is selected the chart should update with the price history. Colours should be the same as the stocks with green for increase and red for decrease etc.

For charts: users should be able to enter the code symbol (from this data) to refresh the chart. Similar to changing from one stock chart to another on freestockcharts.com

The add column button should open up a list of fields that I have for this data. Users should be able to select the ones they want to view in portfolio. And have ability to sort by any folder

Portfolio: Ability to create portfolio from this data (as above). Users should be able to have data from Stocks as well as Platts in one portfolio if required.

This should be extensible and have ability to add more data if required.

Phase 4: Mobile App
Mobile App similar to Bloomberg App for blackberry at http://appworld.blackberry.com/webstore/content/939

With this app (only available after login and if subscription has been paid) users should be able to view:
– a basic chart similar to the Bloomberg app where users can shoose to view chart by stock code or external data symbol.
– News section where users can pick rss feeds to view
– View portfolio in similar format to the portfolio in freestockcharts. Don’t need all the functionality. Just ability to view

Other details:
I have the domain already and have a business hosting package with 1and1.com. This should be sufficient but if it needs to be upgraded or if other features are required then please let me know.

Design – please use CSS files so I can adjust the look and feel. Not sure if this is possible with Silverlight? But definitely for the new portal part.

Source code: I would like the entire source code and full ownership to do as I please. Once completed you can include in your portfolio but should no resell the complete (Phase 2) project as it is. You may not include any reference to your company within any part of this project.

All the above features should be scalable and not limited to just what’s listed above. I would prefer one company that has experience in similar projects and can develop more as my requirements increase. Also, I expect to add more data sources in future so you need to be able to add more options/buttons to above menus (Phase 1 and Phase 2) and integrate more data in future.

Please provide quote for the entire project and expected time to complete. My preference is to have this site launched ASAP.

Sources:
Extract Yahoo financial data: http://www.codeproject.com/KB/IP/YahooFinance_Managed.aspx

Ten Articles – Us Writers Only

Ten Articles – Us Writers Only
I need 10 ORIGINAL articles written on Mother’s Day topics. Each article should be at least 500 words and SEO Optimized to the titles that we will assign you.

I am looking writers who grew up in the US with excellent knowledge of US culture, customs, grammar, spelling, and punctuation.

THE PROCESS: We will assign you 5-10 articles at a time. At first, pick just one topic and complete it in ONE DAY. We will edit it and publish it, and before you continue writing more, you should read the edited version and any notes sent to you by the editor. Any future articles should take into consideration the edits made on your previous articles.

SEO ARTICLE WRITING INSTRUCTIONS:

1. Visit our website to learn about formatting (subtitle, bolding of keyphrases, keyphrase variations, intro paragraph, etc). Register for the site and we will also provide you access to our private writer’s forum.

2. We will assign SEO keyphrases as article titles, and you are to write an article which is SEO optimized to that keyphrase (and occassionally one or two more phrases).

3. Search the internet on the target keywords AND related keywords for content ideas. Your writing must include CREDIBLE information (not your opinion), but do NOT copy or simply paraphrase other people’s work.

4. Write a cohesive organized article using a regular essay format (ie. intro paragraph, 3-5 body paragraphs, conclusion). Write in an informal, upbeat, informative journalistic style and may include creative, descriptive phrasing and appropriate examples.

5. Add some basic SEO formatting:
—Bold the keyphrase in the opening paragraph and 1-3 other times (about half of the occurances) and italicize it once in the article
—Find 4-7 keyphrase variants or derivatives in the article and bold them each once (plurals, possessive, change the order of the words, add words before or after, etc)
—Add bulleting or breaks if needed for lists to maintain graphic flow, etc. of article
—DO NOT alter margins, fonts or colors, etc. The ONLY formatting should be bold, italics, bullets, and paragraph returns.

6. Use CopyScape to verify that your content is 500 words or more in length and 100% original (we will give you access to our copyscape account if you need it)

7. Submit the article via email as a Word or RTF file format.

COPYRIGHT NOTICE: This is an article contract writing position. All publication AND COPYRIGHTS are retained by us upon payment. When you write for us, you transfer all copyrights to us, and we can use and resell this content as we see fit, including publishing it under any name we choose.

WARNING – If you fail to follow the instructions or your article requires significant grammatical, cultural or factual modifications, we may either reject the work completely and give you no payment and a NEGATIVE review, or pay only 50% of your bid to pay for the editor’s time. We will NOT send it back to you for edits. If there are problems and you want to continue to write for us, you are to examine the final edited work and compare it to your draft, and learn from the changes made by the editor.

Cms Template Install & Set-up

Cms Template Install & Set-up
I am a designer and I have a client who will need a CMS site. It is a tool rental company. I am considering Joomla or Drupal for the CMS. The attached Excel document outlines all of the categories. I need the following:

• Provide recommendation Joomla or Drupal
• Install Template and set up all modules (I will buy template from templatemonster)
• Install a drop-down menu extension..similar to this one:

Excel 07 Documentation


• Set-up a page for each topic (there looks to be 5-7 topics for each category. 5 categories total. No need to fill the pages with content, I will populate the content
• Perhaps recommend an extension for entering and organizing multiple products..if a good one exists. But this is not necessary.