Design & Logic Question PHP mySQL HTML

[RPGguy]

I'm not sure of the best way to approach this application and I'd like a smart way to do it.

I have 2 tables, the first is a parts master list. The second contains equipment and all the parts that go into the equipment.

I'm thinking I want a screen with two frames. The left frame shows the equipment name on top (let's say an A/C compressor) and all the parts that make up the compressor underneath.

The right frame is a list of all parts in the parts master file. The user needs to be able to select parts from the master and add them to the compressor/parts table. I'm also thinking of adding a cell to the extreme right of each line in both frames. The left frame would have an image of a minus sign which would remove the part from the compressor/part table when clicked. The right frame would have an image of a plus sign which would insert the part into the equipment/part table. I would also like to refresh the screen when either functions are performed.

All help is greatly appreciated.

Scott

 

[hos2]

wow that's a lot you want. how far did you already get ??

 

[RPGguy]

I have the frames working, listing the two files and showing the (-) and the (+) on each line. I have also created functions to add and delete the part from the equipment/part table. What I don't know how to do is to call the functions (when the - or + is clicked), pass the key fields from the clicked line to the function and refresh the screen. Ideally, I don't want another screen to pop up. I just want to see the part listed or removed from the list.

 

[sleipnir214]

Passing the key fields:
The links under - and + should be of the form: <a href=&quot;somescript.php?someaction=delete&someid=23&quot;>...</a>


Calling the functions:
Have somescript.php use if-blocks to change its behavior according to input.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!