maintaining relation while POSTing and while fetching.

[rpnew]

Hello friends....
I'm developing one project in PHP-MySql on FC4.....
I'm facing a problem here at one place. Let me describe it....

I've one page in php on which i'm generating a table containing checkboxes for option. These options have suboptions. User need to chose these options and suboptions. with suboption they are getting textboxes in which they can enter values for suboptons. When they submit the form i need to get all these data and accordingly store them into the database.
Now problem comes because all these checkboxes and textboxes are generated dynamically meaning through values in database. So i've made an arrays for all these so that i can get the values of selected checkboxes and textboxes. So the problem is on the second page i cant determine which suboption and textbox value goes to which option means relation is broken i need to maintain this relation so that i can store these values in database maintaining foreign key..

Now let me describe my database a bit so that if you have any other option then this you can suggest me.

In database i've four tables say table1,table2,t able3 and table4.

Table1 contains name of OPTION and NUMBER of SUBOPTION it has.
Table2 contains name of SUBOPTIONS and OPTIONS they belongs(foreign key)

Table3 is similar to Table1 and Table4 is similar to Table2(with one field added which will store the value of SUBOPTION coming through TEXTBOXES which user is providing at runtime.)

So what i'm doing is getting the OPTIONS and SUBOPTIONS values from Table1 and 2 respectively and generating form. So when user submits the form i want to store these values into Table3 and 4 respectively.

I told you what i'm doing. so if you can help with that its good and if you have any other idea with GUI as well let me know.

[rpnew]

Glad you solved your problem.
What about a 2d array?

Well i've three arrays actually to manage.. to maintain their relation what i've done is....
The first one is aa array which contains values of CHECKBOXES..
The second one is also an array of CHECKBOXES(valu es of checkboxes)
The third is an array of TEXTBOXES..

Now i've given the name of the TEXTBOXES as content(value) of the second array(CHECKBOXE ) and For name of the Second array i've taken content(value) of the first array(CHECKBOX) ... and passed the first array across the pages....

So on the second page i'm already getting first array.. to get value of second array i'm using first array value and to get the third one i'm using value of the second array.. in that way by passing only one array i can access all three arrays... and relation is also maintained..

RP

[code green]

You could possibly improve this by using an associative aray and naming the keys the same as checkbox/textbox name

[pbmods]

Heya, RP.

You may find this document of some interest.

[rpnew]

You could possibly improve this by using an associative aray and naming the keys the same as checkbox/textbox name

hi......
well thanks for your suggestion..... but i dont know how to use associative array so if you can give me some information it will be useful....howev er i'll also try to search it on net..

Thanks,
RP

[rpnew]

Heya, RP.

You may find this document of some interest.

Thanks to you as well..

RP

[code green]

A little example using associtive arrays
[PHP]$assocArray = array();
$nBoxes = 3;
for($c=0;$c<$nB oxes;$c++)
{
$name = 'box'.$c; creates a string called 'box' with a numeric suffix
$value = 'Any string '.1;

$assocArray[$name] = $value;
echo '<input type="textbox" name="'.$name.' id="'.$c.'value ="'.$value.' >';
}
//Creates an array such
assocArray ('box0'=> 'Anystring 0','box1'=> 'Anystring 1','box2'=> 'Anystring 2')
//

//Read array
foreach($assocA rray as $key=>$value)
{
echo 'Name = '.$key;
echo ' Value = '.$value.'<br>' ;
}
//Will output
Name = box0 value = Anystring 0
Name = box1 value = Anystring 1
Name = box2 value = Anystring 2
//Or at least it should do [/PHP]

[rpnew]

A little example using associtive arrays
[PHP]$assocArray = array();
$nBoxes = 3;
for($c=0;$c<$nB oxes;$c++)
{
$name = 'box'.$c; creates a string called 'box' with a numeric suffix
$value = 'Any string '.1;

$assocArray[$name] = $value;
echo '<input type="textbox" name="'.$name.' id="'.$c.'value ="'.$value.' >';
}
//Creates an array such
assocArray ('box0'=> 'Anystring 0','box1'=> 'Anystring 1','box2'=> 'Anystring 2')
//

//Read array
foreach($assocA rray as $key=>$value)
{
echo 'Name = '.$key;
echo ' Value = '.$value.'<br>' ;
}
//Will output
Name = box0 value = Anystring 0
Name = box1 value = Anystring 1
Name = box2 value = Anystring 2
//Or at least it should do [/PHP]

hmm well thats an useful example..

Thanks,
RP