Need advice from a MySQL pro

This should be an easy project for a pro at MySQL.

I need to get an answer to this question today.

In your bid response, please elaborate on what specific help you can provide; bids that are just bids without any supporting explanations will be ignored.

I am having a few problems with an application I am developing using PHP/MySQL. Most of the problems have to do with getting the MySQL code correct.

IMPORTANT: I am using MySQL version [url removed, login to view], so your answers must conform to the abilities of that version and not any subsequent or previous version. Again, this is very, very important.


1) Timestamp field randomly updating to the current date and time after an UPDATE to the table without explicitly setting the timestamp field in the UPDATE as well. Current workaround is to explicitly set the timestamp field on the UPDATE.

2) Doing an UPDATE with a COUNT of a value from another table. I've tried both the transact-SQL method and the MySQL method. The MySQL method seemed to get closer with no syntax errors, except it would always error with "Invalid use of group function". Here's the syntax used:

UPDATE table1, table2

SET table1.value=COUNT([url removed, login to view])

WHERE table1.value2=20 AND table1.value3=[url removed, login to view]

And I've tried this syntax as well:

UPDATE table1 LEFT JOIN table2 ON table1.value3=[url removed, login to view]

SET table1.value=COUNT([url removed, login to view])

WHERE table1.value2=20

3) The other main disadvantage with the current MySQL versions other than a lack of stored procedure support, is the lack of support for sub-queries. This is coming in version 4.1 and will make the creation and implementation of SQL queries a lot easier, reducing 4-8 queries into 1. But for now, I need to figure out how to best use the version I am on.



## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

MySQL version [url removed, login to view]

Evner: Ingeniørarbejde, MySQL, PHP, Software Arkitektur, Software Testning

Se mere: where to hire a coder to help you, what can you do with php and mysql, what can i do with php and mysql, web pro it, u. s. a. today, software advice, pro hire, pro coder, need for web developing, i need to hire sql, i need to hire an engineering, how do i get to work from here, get answers now, answers from, be a pro, join get a coder, hire pro, hire it pro, hire a pro, help i need a coder today

Om arbejdsgiveren:
( 79 bedømmelser ) Wilmington, United States

Projekt ID: #3326357

Tildelt til:


See private message.

$29.75 USD på 1 dag
(150 bedømmelser)

3 freelancere byder i gennemsnit $27 på dette job


See private message.

$8.5 USD på 1 dag
(21 bedømmelser)

See private message.

$42.5 USD på 1 dag
(14 bedømmelser)