Inventory Management
Posted: Thu Aug 20, 2009 8:34 am
Alrighty,
I've been working on this project for a while but have run into a couple of snags.
An archive with all applicable files has been attached. Direct your attention to 2488test.php I have a static div table with 14 rows for weapon signout. I need each seperate mysql record to go into it's own row and create a new page if there are more than 14. I've tried lots of different things but haven't had any luck. Did some experimentation with 2488test2.php as well.
I changed my database structure to allow for multiple owners for each weapon and am using the assignment table to connect the personnel data with the weapon data but I can't seem to figure out how to better formulate the queries on the list.php (List weapons and owners) page as well as the personview.php (List Individual Personnel and all assigned weapons) page.
Any help with these would be greatly appreciated.
I've been working on this project for a while but have run into a couple of snags.
An archive with all applicable files has been attached. Direct your attention to 2488test.php I have a static div table with 14 rows for weapon signout. I need each seperate mysql record to go into it's own row and create a new page if there are more than 14. I've tried lots of different things but haven't had any luck. Did some experimentation with 2488test2.php as well.
I changed my database structure to allow for multiple owners for each weapon and am using the assignment table to connect the personnel data with the weapon data but I can't seem to figure out how to better formulate the queries on the list.php (List weapons and owners) page as well as the personview.php (List Individual Personnel and all assigned weapons) page.
Any help with these would be greatly appreciated.