All oDesk Jobs » Search Results » Job Facts
 oDesk Verified
Payment Method
Flag as inappropriate
Add logic to PHP program to read new database fields
Open
Date Posted:November 6, 2009
Planned Start Date:November 6, 2009
Type:Hourly
Main Category:Web Development
Sub Category:Web Design
Skills: PHP
MySQL
Estimated Workload:As needed - Less than 10 hrs/week
Estimated Duration:Less than 1 week
Last Buyer Activity:November 21, 2009
Candidates: 33 - average $11.10/hr
Interviews: none
Cancelled
Date Cancelled:November 21, 2009
Reason Cancelled:
Project was cancelled
 
 
Buyer Facts
Member Since:September 18, 2009
Country:United States (GMT-05)
City:Atlanta
Jobs Posted:12
Jobs Filled:5
Jobs Not Yet Filled:4
Current Team size:0
Hours billed, last 30 days:3
Total oDesk Hours:20.83
Feedback Score: 5.00 (4)
 

Hi,
We already have the php built, but we just need to add 1 more database call. We need to customize an oscommerce index page to do the following:


1) Check current date. 

2) We created a new database table called 'whats_new'. Now we are going to read table  checking the start and end date.
something like this:

SELECT * FROM `whats_new` WHERE type=1 AND current date BETWEEN start_date and end_date

3)If theres a record fount that meets this criteria, then we display 3 fields:

top_text
bottom_text,
whats_new_text

ELSE do this read for the default:

SELECT * FROM `whats_new` WHERE type=0 

If theres a record fount that meets this criteria, then we display 3 fields:

top_text
bottom_text,
whats_new_text


That's IT!! We are just reading a database table, checking the start and end date, and displaying 3 fields.

Can you start immediately? It should not take an experienced PHP developer more than 1 hour to complete this task. It would help if you have had Oscommerce experience before. Please let me know if you have.

THANKS!

Buyer's Other Job Openings
ID Title Type
5008177 ASP Classic + SQL Server 2005 - troubleshoot fix Hourly
4975809 Javascript + PHP: Help with Oscommerce Contribution Hourly
5038598 LimeSurvey Expert Needed Hourly

Buyer's Assignment History
Provider From/To Job Title Billed Feedback
364472 11/2009 - 11/2009 PHP/MySQL to Generate HTML formatted email $30 (3.00 hrs @ $10.00/hr)
410287 09/2009 - 10/2009 ABCPdf Expert Needed $33 (fixed-price)
410287 10/2009 - 10/2009 ABCPdf - Report Needs Adjusting $198 (18 hrs @ $11.11/hr)
163976 09/2009 - 10/2009 OsCommerce - PHP/MySQL Modifications $211 (fixed-price)

Candidate List
Title Name Initiated By Date
Php/Joomla/Mambo/Photpshop/Javascript Gurdeep S. Provider November 6, 2009
Senior PHP, Joomla, Drupal & Wordpress Developer Ali I. Provider November 6, 2009
PHP MySQL, Wordpress, Joomla, Smarty, Drupal, Action Script, CSS Progr Arshpreet Kaur Provider November 6, 2009
PHP/MYSQL/JAVASCRIPT/JOOMLA/AJAX/CSS/HTML/FLASH/PHOTOSHOP Pawankumar Sharma Provider November 6, 2009
php developer, zend expert Deepak S. Provider November 6, 2009
php,mysql,ajax,.NET,RubyonRails,drupal,java,j2ee,SOA,BI,Pentaho,Jboss Michael Angelo Provider November 6, 2009
PHP developer Sanjeev K. Provider November 6, 2009
Php, Java, Ruby, Javscript, HTML, AJAX,XML,XSLT,SOAP, CRM developer Mohan Rm Provider November 6, 2009
6+ Senior PHP/MySQL/JavaScript/Oscommerce/Drupal/Joomla/WP/CMS Mohit K. Provider November 6, 2009
ERP, Sharepoint Server, PHP, .Net 3.5,VB,Oracle Forms,SQL,C, C++, ASP Manjit Singh Provider November 7, 2009
PHP,MYSQL,AJAX,CSS,JAVASCRIPT,FLASH,FLEX,SMARTY,XHTML,JOOMLA,WRDPRSS Bharti G. Provider November 7, 2009
I want to be a good outsourceing programmer Zinu Mina Provider November 7, 2009
Expert HTML/XHTML, CSS, Web 2.0, PHP/MYSQL, AJAX, Photoshop, CMS Palivela K. Provider November 7, 2009
PHP Expert with AJAX,Jquery,Gmap,SMARTY,CMS(Dolphin,Joomla,Drupal) Pieter G. Provider November 7, 2009
PHP MySQL Ajax-Joomla Drupal,CodeIgnitor,Smarty,CakePHP Expert 10 year Angel Mary Provider November 7, 2009
★★★★★Expert in PHP/ASP.NET/ CMS/ Joomla/ MySql/MS-SQL with AJAX Abhishek Rai Provider November 7, 2009
SENIOR PHP DEVELOPER/MYSQL,Joomla,Wordpress,Javascript,html,dhtml etc Dinesh Kr Provider November 7, 2009
all rounder Consultants Munish Arora Provider November 7, 2009
Linxys Solutions Revin T. Provider November 7, 2009
IT expert with rich experience in web,desktop & database development Sukhendu S. Provider November 7, 2009
6 years experienced ASP/ASP.NET/Silverlight/RIA & AJAX developer. Vijay G. Provider November 7, 2009
C#/PHP developer, HTML,CSS Alex Shilin Provider November 7, 2009
PHP expert with Joomla/Drupal/Wordpress Sreedevi L. Provider November 7, 2009
linxys solutions Siyad K. Provider November 7, 2009
10 yr exp .NET/PHP/Flash/Joomla/Drupal/Webdesign/CRM/Sharepoint Kumar Madhu Provider November 7, 2009
Experieced OsCommerce,Ajax,Smarty,Wordpress,Cakephp,Magento Programmer Ranjana S. Provider November 7, 2009
Experienced PHP developer Prabhdeep S. Provider November 7, 2009
experienced PHP/Mysql, OsCommerce, X-cart developer Yashpal S. Provider November 7, 2009
5 Yrs of Experience in PHP/Mysql/Ajax/Python/Perl and Asterisk Preeteesh K. Provider November 7, 2009
PHP,Smarty,Joomla,CodeIgniter/.Net Real Estate,Google Maps API Expert Suresh S. Provider November 7, 2009
Brain bench certified programmer- .net,SQL Server(SSIS),ASP,VB,MOSS Mukthi T. Provider November 7, 2009
PHP/MySQL/SEO/AJAX/CSS/JavaScript Srijith V Provider November 7, 2009
Experienced PHP Web Programmer Vineet S. Provider November 8, 2009

Related Trends
PHP Developers
MySQL Administrators