0

here i am store the dynamic row values into mysql. i am using jquery and javascript for dynamic rows and auto calculation and then stored to mysql using php coding. that works perfectly. i already added dynamic row value into mysql perfectly. But, now i want to edit the table so how can i fetch the dynamic row? thats my question... basically i know how to retrieve the values from mysql. but i dont know how to retrieve the dynamic row values... 997433b4e5c8fa0790ecff20975c448a
i attached one image. look at this... if user clicks the plus button it will add rows. sometimes user can add 5 rows or 10 rows or 20 rows... these all rows are stored into mysql db successfully and then i assigned a specific reference id for these rows. any idea? how to retrieve dynamic rows using that specific reference id????

5
Contributors
13
Replies
55
Views
3 Years
Discussion Span
Last Post by Indians
Featured Replies
  • 1
    diafol 3,669   3 Years Ago

    You need to iterate over the resource... while ($row = mysql_fetch_object($tariff_query)) { echo $row->somefield; echo $row->someotherfield; } So you now get all the records not just the first one. BTW, if you want to use an object, why not use PDO or mysqli? mysql is dead - or as good … Read More

0

i want to fetch the dynamic rows from mysql. for exampl first (for example slno 1) user adds 10 rows and then second (for example slno2) users add 5 rows. these all rows values stored in mysql. now i want to edit the user details. if i click slno1 means it should show the values of 10 rows or else if i click slno2 means it should show the values of 5 rows. mysql_insert_id(); its not a problem. i already assigned specific values for these rows... FETCH DYNAMIC RECORDS USING ARRAY...

0

store user corrsponding user id too in table means user1 add 5 rows then every row has userid (user1) with the help of this user id you can fetch rows of perticular user

0

@ pzuurveen :

index.php

<td><input type="text" name="slno[]" value="" size="2"></td>
      <td><input type="text" size="10" name="date[]" id="SelectedDate" onClick="GetDate(this);" readonly="readonly"/></td>
      <td><input size="24" type="text" name="particulars[]" value="" placeholder="Description"></td>
      <td><select name="noofnights[]" value="0">
      <option value="empty"></option>
      <option value="1">1</option>
      <option value="2">2</option>
      <option value="3">3</option>
      <option value="4">4</option>
      <option value="5">5</option>
      <option value="6">6</option>
      <option value="7">7</option>
      <option value="8">8</option>
      <option value="9">9</option>
      <option value="10">10</option>
      <option value="11">11</option>
      <option value="12">12</option>
      <option value="13">13</option>
      <option value="14">14</option>
      <option value="15">15</option>
      <option value="16">16</option>
      <option value="17">17</option>
      <option value="18">18</option>
      <option value="19">19</option>
      <option value="20">20</option>
      <option value="21">21</option>
      <option value="22">22</option>
      <option value="23">23</option>
      <option value="24">24</option>
      <option value="25">25</option>
      <option value="26">26</option>
      <option value="27">27</option>
      <option value="28">28</option>
      <option value="29">29</option>
      <option value="30">30</option>
      <option value="31">31</option>
    </select>
        <input size="14" type="text" onKeyUp="return valtxt(this)" name="rate[]" value="0">
        <input size="14" type="text" name="price[]" value="0" readonly="readonly">
<input size="9" type="text" name="tax[]" onKeyUp="return valtxt(this)" value="0">
<input size="1" type="hidden" name="taxtotal[]" value="0" readonly="readonly"></td>

store.php

if (isset($_POST['submit_val']))
{
foreach ( $_POST['slno'] as $key=>$slno )
{
$date = $_POST['date'][$key];
$particulars = $_POST['particulars'][$key];
$c_date = mysql_real_escape_string($date);
$c_slno = mysql_real_escape_string($slno);
$tariff = mysql_query("INSERT INTO ebvouchertariffs ( TariffSlNo, TariffDate)", $link );
}
}

i written this code for dynamic row values inserted into db and some javascript functions too... now i want to fetch the datas using foreach..

0

basically i know how to retrieve the values from mysql. but i dont know how to retrieve the dynamic row values...
how to retrieve dynamic rows using that specific reference id????

So from this I take it you want to retrieve...

$query = "SELECT ... FROM table WHERE id = $id";

You're post was very confusing, so are you looking to display additional records with that form?

If so, you probably need to use the LIMIT clause...

$query = "SELECT ... FROM table LIMIT $start, $amount";

Edited by diafol

0

@diafol :
cd8c93ac0a6c65a67e52895050c41246 look at this image. this column name is VoucherID_Fk

in that image you can see some VoucherID_Fk values 37,37,37,36,36,36. these three row contains different values in other columns like TariffDate, TariffParticulars, TariffRate etc...,

select & fetch query code :

$tariff_query = mysql_query("SELECT * FROM ebvouchertariffs WHERE VoucherID_Fk = $id");
        $t_row = mysql_fetch_object($tariff_query);
        echo mysql_error();

        <td><?php echo $t_row->TariffDate ?></td>
                <td><?php echo $t_row->TariffParticulars ?></td>

i attached another images look at this... c7d2927d9d144ebbda42a2c2e9be7376

those 38 number column is VoucherID_Fk. you can see different row values from other rows 10,7 & 900,5000 & 9000,35000 & 6.25,5. so, now i want to fetch records using that VoucherID_Fk. but i got only 1st row values, i didn't get remaining values...
For example i fetch the VoucherID_Fk number 38..

i want output like this..

38 10 900 90000 6.25
38 7 5000 90000 5

but now i got like this..

38 10 900 90000 6.25

i didn't get the all rows of that particular id...????

Edited by Indians

1

You need to iterate over the resource...

while ($row = mysql_fetch_object($tariff_query)) {
    echo $row->somefield;
    echo $row->someotherfield;
}

So you now get all the records not just the first one.

BTW, if you want to use an object, why not use PDO or mysqli? mysql is dead - or as good as.

0

@ diafol : c70ac1b3cd3d4aa71885329df2ffa0ab it works. but look at this images. it splits the table. i want to fetch one by one row...

i want like this...

1st row
2nd row
3rd row
4th row

but i got like this...
<table>
1st row
</table>
<table>
2nd row
</table>
<table>
3rd row
</table>
<table>
4th row
</table>
<table>
5th row
</table>

Edited by Indians

0

How do you add a membership records in java(bluej) First Name, Last Name, phone number. Please can you help me

0

@HMP123

Please post to the correct forum (Java?) and give full details of your query. Your post is insufficient as it is. Include any code that you've written too.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.