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.
Inventory Management
Moderator: General Moderators
- Ollie Saunders
- DevNet Master
- Posts: 3179
- Joined: Tue May 24, 2005 6:01 pm
- Location: UK
Re: Inventory Management
Search these forums or with Google for "pagination" to find tutorials on what you wish to achieve.
It's more convenient for those wishing to help you, such as myself, if you post the relevant bits of your code inside php tags ( [syntax=php]code here[/syntax] ) rather than having us download, extract and search through a whole archive of files. I thank you for your effort to assist us nevertheless.
It's more convenient for those wishing to help you, such as myself, if you post the relevant bits of your code inside php tags ( [syntax=php]code here[/syntax] ) rather than having us download, extract and search through a whole archive of files. I thank you for your effort to assist us nevertheless.
Re: Inventory Management
Ollie Saunders wrote:Search these forums or with Google for "pagination" to find tutorials on what you wish to achieve.
It's more convenient for those wishing to help you, such as myself, if you post the relevant bits of your code inside php tags () rather than having us download, extract and search through a whole archive of files. I thank you for your effort to assist us nevertheless.Code: Select all
code here
My apologies. However I believe the entire 2488test file is relevant but it's a fairly long file, and I didn't want to clog the thread with it.
- Ollie Saunders
- DevNet Master
- Posts: 3179
- Joined: Tue May 24, 2005 6:01 pm
- Location: UK
Re: Inventory Management
Then the best thing is that you create a simplified version of the file the illustrates your problem. Sometimes in doing this you'll stubble upon a solution anyway. Go team!