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...
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????
Indians
0
Junior Poster in Training
Recommended Answers
Jump to PostI'm not sure what your asking for.
to get the id of the last insert into the db: mysqli.insert-id
show the code you have problems with
Jump to Poststore 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
Jump to PostWhat are your db-tables look like?
post your code
Jump to PostYou 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 …
All 13 Replies
pzuurveen
90
Posting Whiz in Training
Indians
0
Junior Poster in Training
AARTI SHRIVAS
2
Posting Pro in Training
pzuurveen
90
Posting Whiz in Training
Indians
0
Junior Poster in Training

diafol
Indians
0
Junior Poster in Training

diafol
Indians
0
Junior Poster in Training
Indians
0
Junior Poster in Training
Helpmeplease123
0
Newbie Poster

diafol
Indians
0
Junior Poster in Training
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.