Posted 27 June 2006 - 11:12 PM
I'm a techy for a school and we currently log everything on paper with reguards to each workstation. We basically have a table on paper listing all the software packages and precedures for setting up workstations.
I'm wanting to make a website using PHP and MySQL which will list all the software and display what softwares installed when I click on the workstation name.
Now i have a few ideas as to prehaps i should go about it. For example... 2 tables,
(this is where i get stuck, do i just create about 30 new rows? e.g softwareID1, softwareID2 and make the values 1 or to indicate thats installed? or do i create the 30 odd new rows and put the corrisponding software id?...)
- etc etc
Also... I have not yet tired arrays, I was thinkin that prehaps if i had 1 field on the computers table for a long strong with software ID's seperated with a space then explode it and query each to find the software title?
I'm sure you guys are prehaps alot more confident at answering this as i was writing it. Please help me, im sure there's a more simple way.
Thanks for anyhelp, much apprecaited!
Posted 28 June 2006 - 12:12 AM
Disclaimer: Free advice is usually worth what you paid for it. ( or at least when it's coming from me! )
Posted 28 June 2006 - 10:38 AM
Posted 28 June 2006 - 11:01 AM
"select * from relational_table where SoftwareID = 7"
This will give you all the computer id's which have the software installed which has a softwareID of 7.
If you wanted to know what was installed on a particular computer you could then do this;
"select * from relational_table where ComputerID = 3"
So you end up with the SoftwareID's of all the software installed onto computer number 3.
Hope this makes sense.
Posted 29 June 2006 - 08:48 PM
Cheers again wisewood - your truely wise [img src=\"style_emoticons/[#EMO_DIR#]/wink.gif\" style=\"vertical-align:middle\" emoid=\":wink:\" border=\"0\" alt=\"wink.gif\" /]
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users