Hello All. I need some help on a project and am tearing my hair out doing this myself. At this time, I would like to pay for the services of someone experienced in MYSQL to help me out. What I am basically doing is trying to convert a site from using Joomla to Social Engine. I am trying to use MySql Queries to convert the data we have to something Social Engine will understand. I did a little bit myself, but some of these querys I will need create using INNER JOINS which is a bit over my head and I am running out of time. So what I would like to propose is to be able to email or PM someone a question I need help on. I would then need whoever takes this work to create a query (or small script) from the question I pose. I will pay $15 (paypal) per working query (I would need multiple ones) and I would think for someone experienced the querys would only take a few minutes. Here is an example of a question I would ask to create a query for: I basically have a table that is like the following: Table: Data Columns: Row ID Profile Import_ID Field_ID Product 1 5 Null 5 60 Can 2 0 Null 5 65 Hat 3 0 Null 5 70 Box 4 6 Null 6 60 Fish PHP: I basically want to take the word "Hat" in row 2 and place it into the "Profile" column of row 1, replacing the null value there. I am doing this for multiple rows. In the case of the multiple rows I want to take the "Profile" column and make it equal to the "Product" column. I only want this to happen in the rows where the "ID" value matches the "Import ID", and where the "Field ID" is 65 specifically. In the example above the "ID" 5 matches the "Import ID" 5, so I want to take the "Product" value "Hat" where the "Field ID" is 65, and place that value into the "Profile" column where the ID is 5. My table has over 9000 rows and 600 would have to be changed in this way, with various ID's needing various products inserted. The result I would like would be: Row ID Profile Import_ID Field_ID Product 1 5 Hat 5 60 Can 2 0 Null 5 65 Hat 3 0 Null 5 70 Box 4 6 Null 6 60 Fish PHP: I would basically want an UPDATE query statement written that would make the changes needed. Most of the questions would be something like this.
Hi bro I am Archis I am a freelancer with 4 Yr+ experience and i saw your advertise regarding your need in DP. So if you still need this job to be done contact me here i can do it asap with reasonable price. MSN - souvikmustdie at hotmail dot com Thanx Regards Archis
Hello, I have 5 years of experience in PHP, mysql and ajax. PM me more details. I can give you best quality work. Thanks you.