Get a Freelance Job

I need when a user joins based on conditions certain rows are inserted using an insert query. Users can select which ads they want to run in this ad rotating script, this is accomplished in the DB where is they select an ad to run in the users ad rotation this creates a row for that ad and size.

I also need a refer program added to the same spot

I need when a user joins based on conditions certain rows are inserted using an insert query. Users can select which ads they want to run in this ad rotating script, this is accomplished in the DB where is they select an ad to run in the users ad rotation this creates a row for that ad and size.

I also need a refer program added to the same spot

We are looking for a new developer to outsource work to, so you may consider this project an interview.

We chose this project because it will show your skills and iniative.

The script basically has to take a QFX file (bank statement) and enter all the individual transactions into a database (MySQL).

The format is as follows:

<STMTTRN>
<TRNTYPE>POS
<DTPOSTED>20081130
<TRNAMT>-1000
<FITID>2008113001
<NAME>A SHOP SOMEWHERE
<MEMO>EFTPOS
</STMTTRN>

<STMTTRN>
<TRNTYPE>POS
<DTPOSTED>20081130
<TRNAMT>-1000
<FITID>2008113001
<NAME>A SHOP SOMEWHERE
<MEMO>EFTPOS
</STMTTRN>

<STMTTRN>
<TRNTYPE>POS
<DTPOSTED>20081130
<TRNAMT>-1000
<FITID>2008113001
<NAME>A SHOP SOMEWHERE
<MEMO>EFTPOS
</STMTTRN>

You must be quick and relaible – thank you.

We have a script that tells us what items to pull down from a shelf to make up a product. We’ve changed db tables and names and need the script udated to the new info. Below is a list of items from a select statement that is no longer working.

Sku – should show from product.sku (tied together by pulling_herb.name = product.id)
Name – should show from product.name (tied together by pulling_herb.name = product.id)
Lot # – should show from pulling_herbs.lot
Qty – should show from pulling_herb.qty
Inventory – should show from lot.inventory (tied together by lot.id = pulling_herbs.lot_id)

We have checkboxes that we check once the item has been pulled down from the shelf but after we made the changes they were all disabled and should not be if we have inventory. So we need this updated also to the new db fields.

Lastly when finishing the ‘pulling’ job it’s updating some fields from pulling but 2 of them we don’t want updated any longer. They are id, so right now it’s adding 1 to the id but we need it to stay the same without adding 1. The last is product it currently has the id from the product table but is changing it to the item sku and we don’t want that. The rest are fine.

I’ll attach longer notes with code so you can see what your looking with. This shouldn’t take very long and ask any questions on the message board and we’d like it finished pretty quickly. Thanks.

We have a script that tells us what items to pull down from a shelf to make up a product. We’ve changed db tables and names and need the script udated to the new info. Below is a list of items from a select statement that is no longer working.

Sku – should show from product.sku (tied together by pulling_herb.name = product.id)
Name – should show from product.name (tied together by pulling_herb.name = product.id)
Lot # – should show from pulling_herbs.lot
Qty – should show from pulling_herb.qty
Inventory – should show from lot.inventory (tied together by lot.id = pulling_herbs.lot_id)

We have checkboxes that we check once the item has been pulled fown from the shelf but after we made the changes they were all disabled and should not be if we have inventory. So we need this updated also to the new db fields.

Lastly when finishing the ‘pulling’ job it’s updating some fields from pulling but 2 of them we don’t want updated any longer. They are id, so right now it’s adding 1 to the id but we need it to stay the same without adding 1. The last is product it currently has the id from the product table but is changing it to the item sku and we don’t want that. The rest are fine.

I’ll attach longer notes with code so you can see what your looking with. This shouldn’t take very long and ask any questions on the message board and we’d like it finished pretty quickly. Thanks.