[smithygotlost]

Hey guys,

What im trying to do is allow a user to customize the forms they have to input data ( in this case for a stock sheet ) so they can go to a certain page and add say Barcode to it, when they then add an item an input field called bardcode exists.

The above i have done. the issue is how to store it. i thought of making a table called items, having 1 numbers than defines all of it i.e 1 then having optionid ( i.e 1 = name 2 = barcode) then value of that field

I currently have all the fields stores in catform like this

formid
value
type
catid
clientid

then when building the form i use

PHP Code:

<?php

$catid = $_GET["catid"];

if(isset($catid)){

$catform = mysql_query("select * FROM `ci_catform` WHERE `catid`='$catid'");



?>



   

                    <div>

                    

<?php



                        while ($row = mysql_fetch_assoc($catform)) {

                            echo'

                        <div class="'.$row['type'] .'Field">

                        

                            <div>'.$row['value'] .':</div>

                            

                            <input type="'.$row['type'] .'" name="'.$row['formid'] .'" value="" />

                        

                        </div>



                                ';

                        }



?>

Now this builds the form perfectly.

its just taking said info processing it and storing it. Any ideas ?

Cheers
Mike

[alxkls]

Well as far as I was able to work out your problem you are having difficulties posting the information. If that is te case i see a few problems:
1.you are missing form opening and closing tag(in your case you need one before the while loop and one after it) which will take the user input somewhere.
2.this is a dynamic form meaning that you might add new inputs in the database at any gievn time. Which means that your inserting method will skip the new once if it's a single "insert into sometable" query. So what you could do is store each input in a separate row. your option is to organize your database like
id, user_id, some_stock_id_or_whatever, input

then assuming it wont be 5000 inputs each time you could do something like

Code:

foreach ($_POST as $r)
mysql_query("insert into mytable (user_id, some_stock_id_or_whatever, input) values ('some_id', 'some_stock_id', '".$r."')");

thats just a quick reply really so you might need to fix it up a bit but that should give you a headstart... if that's of course what you are trying to achieve....