SQL Update code
$30-250 USD
Completed
Posted over 13 years ago
$30-250 USD
Paid on delivery
Hi,
I have a DYNAMIC table with items from a database.
The table outputs the following (SAMPLE)
-----------------------------
<body>
<table width="800" border="0">
<tr>
<td><form id="frmMerchandise" name="frmMerchandise" method="post" action="">
<table width="100%" border="0">
<tr>
<td width="55%">Apples</td>
<td width="7%"><input name="Item_ID" type="hidden" id="Item_ID" value="2545"></td>
<td width="19%"><label>
<input type="text" name="Item_Price_Reg" id="Item_Price_Reg" />
</label></td>
<td width="19%"><input type="text" name="Item_Price_Sale" id="Item_Price_Sale" /></td>
</tr>
<tr>
<td>Cherries</td>
<td><input name="Item_ID2" type="hidden" id="Item_ID" value="34"></td>
<td><input type="text" name="Item_Price_Reg" id="Item_Price_Reg" /></td>
<td><input type="text" name="Item_Price_Sale" id="Item_Price_Sale" /></td>
</tr>
<tr>
<td>Bananas</td>
<td><input name="Item_ID3" type="hidden" id="Item_ID" value="136"></td>
<td><input type="text" name="Item_Price_Reg" id="Item_Price_Reg" /></td>
<td><input type="text" name="Item_Price_Sale" id="Item_Price_Sale" /></td>
</tr>
<tr>
<td>Cucumbers</td>
<td><input name="Item_ID4" type="hidden" id="Item_ID" value="3789"></td>
<td><input type="text" name="Item_Price_Reg" id="Item_Price_Reg" /></td>
<td><input type="text" name="Item_Price_Sale" id="Item_Price_Sale" /></td>
</tr>
<tr>
<td>Other</td>
<td><input name="Item_ID5" type="hidden" id="Item_ID" value="245"></td>
<td><input type="text" name="Item_Price_Reg" id="Item_Price_Reg" /></td>
<td><input type="text" name="Item_Price_Sale" id="Item_Price_Sale" /></td>
</tr>
</table>
<p>
<label>
<input type="submit" name="Submit" id="Submit" value="Submit" />
</label>
</p>
</form></td>
</tr>
</table>
</body>
----------------------------------
From this page I wish to have a page constructed ([login to view URL]) which will receive the values from the Item_ID, Item_Price_Reg and Item_Price_Sale and update an SQL database.
The SQL update code needs to be dynamic,and accept the values from the previous page dynamically, the Item_ID will change depending on which items are shown on the page.
Regards
Project ID: 909022
About the project
13 proposals
Remote project
Active 13 yrs ago
Looking to make some money?
Benefits of bidding on Freelancer
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
6.6
6.6
13 freelancers are bidding on average $64 USD for this job
6.8
6.8
1.0
1.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
About the client
Toronto, Canada
4
Member since Mar 8, 2007
Client Verification
Other jobs from this client
$250-750 USD
$30-250 USD
$30-100 USD
$250-750 USD
Similar jobs
$30-250 CAD
₹1500-12500 INR
€5000-10000 EUR
€12-18 EUR / hour
$250-750 USD
$15-25 CAD / hour
£10-15 GBP / hour
€30-250 EUR
₹100-400 INR / hour
$13-15 USD / hour
$1500-3000 USD
$25-50 AUD / hour
₹1500-12500 INR
₹12500-37500 INR
₹5000-7000 INR
$10-30 USD
€2-6 EUR / hour
$30-250 USD
min €36 EUR / hour
₹12500-37500 INR
Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Copy to clipboard failed, please try again after adjusting your permissions.
Copied to clipboard.
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.