Show Bid Request MySQL Update PHP Bid Request Id: 47940 Bookmark in my 'To Do' list Posted by: alek (2 ratings) (Software buyer rating 10) Non-action Ratio: Very Good - 0.00% Buyer Security Verifications: Good Approved on: Feb 12, 2003 9:40:07 AM EDT Bidding Closes: Feb 18, 2003 EDT Viewed (by coders): 195 times Deadline: 2/18/2003 TIME EXPIRED Phase: 100% of work completed and accepted. Coder has been paid. Max Accepted Bid: Bidding is closed Project Type: Small Business Project: $100 (USD) + Bidding Type: Open Auction Categories: Database, Language Specific, PHP, UNIX, MySQL Enter chat room for this bid request (0 active users at Jul 10, 2003 11:51:43 AM EDT) Description: Hello! I need a small PHP script. Basically the following is needed: In a MySQL table there are following fields catid runnum I need a script that does the following: Every Monday* change if catid=5* highest runnum to "1" all other runnum "+1" * must be editable ALTERNATIVELY: Not "Every Monday, but every 4th* day. - There are currently 4 catid this must work mit. - Script must execute itself (can be included in a page that is called at least once a day) - The highest Runnum varies from catid to catid! EXAMPLE: Current look of the table: `id`,`galset`,`catid`,`adddate`,`runnum`,`runnumv`,`max`,`desc1` 5,blab,5,2002-05-06,3,0,54,blabtext 74,blub,5,2002-05-04,2,0,48,blubtext 24,bleb,3,2002-05-07,2,0,2,blebtext 1,blib,5,2002-03-23,1,0,47,blibtext 85,blob,3,2002-05-06,1,0,35,blobtext WITH Every Monday change in table=galset if catid=5* highest runnum to "1" all other runnum "+1" THE RESULT WOULD BE: 5,blab,5,2002-05-06,1,0,54,blabtext 74,blub,5,2002-05-04,3,0,48,blubtext 24,bleb,3,2002-05-07,2,0,2,blebtext 1,blib,5,2002-03-23,2,0,47,blibtext 85,blob,3,2002-05-06,1,0,35,blobtext Hope you underatnd what I need :-) Thanks for your bids! Deliverables: 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Platform: Unix PHP Must be 100% finished and received by buyer on: Feb 18, 2003 EDT Deadline legal notes: All times are expressed in the time zone of the site EDT (UT - 5). If the buyer omitted a time, then the deadline is 11:59:59 PM EDT on the indicated date. Remember that contacting the other party outside of the site (by email, phone, etc.) on all business projects < $500 (before the buyer's money is escrowed) is a violation of both the software buyer and seller agreements. We monitor all site activity for such violations and can instantly expel transgressers on the spot, so we thank you in advance for your cooperation. If you notice a violation please help out the site and report it. Thanks for your help.   Bidding/Comments: All monetary amounts on the site are in United States dollars. Rent a Coder is a closed auction, so coders can only see their own bids and comments. Buyers can view every posting made on their bid requests. See all rejected bids (and all comments) Name   Bid Amount    Date   Coder Rating   FriendlyDeveloper (9 ratings) in Stockholm, Stockholm Sweden Bid id: 514,999   N/A Feb 12, 2003 10:34:50 AM EDT  9.22 (Superb)     Hello Sir/Madam! This looks like an intresting project. I would like to use PHP,mySQL and the PHP component cron jobs. Please check that your host support 'cron jobs'. This will take me 2 days(48 hours) maximum, so I have plenty of time for testing. Hope to hear from you. I believe 80$ is a fair bid for this. So that is my bid. Please don't hesitate if you have any questions. Best Regards Klas - Sweden           See 15 private reply(ies) to/from FriendlyDeveloper.