Forums

hi,

how to drag values to new field....
and update it....
i try to do it...
but it doesnt work....
can some 1 check 4 me...
using CF v3

form html

<div class="form_item">
<div class="form_element cf_textbox">
<label class="cf_label" style="width: 150px;">Buy Token</label>
<input class="cf_inputbox" maxlength="150" size="30" title="" id="text_2" name="buytoken" type="text" />

</div>
<div class="cfclear"> </div>
</div>

<div class="form_item">
<div class="form_element cf_textbox">
<label class="cf_label" style="width: 150px;">Token Balance</label>
<input class="cf_inputbox" maxlength="150" size="30" title="" id="text_5" name="tokenbal" type="text" />

</div>
<div class="cfclear"> </div>
</div>

<div class="form_item">
<div class="form_element cf_textbox">
<label class="cf_label" style="width: 150px;">After Balance</label>
<input class="cf_inputbox" maxlength="150" size="30" title="" id="text_3" name="afterbal" type="text" />

</div>
<div class="cfclear"> </div>
</div>

<div class="form_item">
<div class="form_element cf_textbox">
<label class="cf_label" style="width: 150px;">Contact No.</label>
<input class="cf_inputbox" maxlength="150" size="30" title="" id="text_6" name="contactno" type="text" />

</div>
<div class="cfclear"> </div>
</div>

<div class="form_item">
<div class="form_element cf_button">
<input value="Submit" name="button_4" type="submit" />
</div>
<div class="cfclear"> </div>
</div>

onsubmit

<?php
$mainframe = &JFactory::getApplication();
$balance   = JRequest::getString('tokenbal', '', 'post');
$mainframe->enqueuemessage('Token Balance:'.print_r($balance, true).'<hr />');
$totalbuy = JRequest::getString('buytoken', '', 'post');
$mainframe->enqueuemessage('Buy Token: '.print_r($totaldays, true).'<hr />');
$available = abs($balance - $totalbuy);
$mainframe->enqueuemessage('After Balance: '.print_r($available, true).'<hr />');
JRequest::setVar('afterbal', $available);
?>

what i want to do is to make update for the new token balance to be carried forward and called back to update the total token balance....can sum1 help me with mysql?
is this the correct way ?
thanks....