53266 Quick PHP/MySQL Fix

Need a quick PHP/MySQL/HTML fix. Here's the issue: We have a web based app, that allows parents to login and check on thier kids (attendance, visits to the princiapl, grades, etc.) Well, a parent may have more than one kid in the school, so we want to present them with a list of their kids, and they can clikc on whatever kid they want to get info on. When a parent logs in, we check a "users" table for that parent, and they grab their relevant ID and off they go. So when we build the list of kids to display them, the SQL goes (in everyman's english translation here): "SHOW me all KIDS WITH PARENT ID [parent id]". Well, here's the problem. If a parent has three kids, she will have 3 parent ID entries in the user table, and it appears that upon loggin in, she simply grabs the first ID. So the SQL only ever returns 1 kid. (the ID is an autonumber field, and as parent's are matched with kids, the parent keeps getting a new ID for each kid). So, now I need a SQL that goes kinda like this: "SHOW ME ALL IDS associated with PARENT", then "SHOW ME ALL KIDS WITH PARENT ID [p1]" then "SHOW ME ALL KIDS WITH PARENT ID [p2]" etc. until we run out of parent IDs. And to complicate it further, we present the list as a clickable HTML List of kids: (html in attached doc) I presume I need to build some sort of array, and then a for each loop. Any help anyone? Thanks.

Beceriler: Her şey Kabul, PHP

Daha fazlasını gör: sort array c, build app in php, web app translation, school kids, php mysql html, kids school, kids first, html issue fix, grades, app php mysql, mysql sort field, mysql sort, php web fix, php table array, sql parents, mysql grab, display mysql, php array quick sort, check parent, html table fix

İşveren Hakkında:
( 9 değerlendirme )

Proje NO: #1802292



Very easy project, can be started immedietly.

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD
(0 Değerlendirme)