Newbie query - Vary the number of fields in a form

branston

I need to create a form where the number of input fields and their labels will differ based upon the result of a sql query. Does anyone have some example code of this type that I can learn from?

TIA

sysera

Try this out:

mysql_connect($dbhost,$dbuser,$dbpass);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM $yourtable";
$result=mysql_query($query);

while ($row = mysql_fetch_array($result, MYSQL_BOTH)) 
{

//Repeat for each column you need data from
$value1= $row["column1"];

echo "Echo your form data for $value1 here";

}

mysql_free_result($result);
mysql_close();

bubblenut

I need to make a building, it must have windows and some doors :queasy: .... could you be a little more specific please?

sysera

Originally posted by bubblenut
I need to make a building, it must have windows and some doors :queasy: .... could you be a little more specific please?

I don't think the question was that vague. They're just looking for a starting point.
-Sys

bubblenut

This could have been any one of a hundred different things. Is the number of fields accroding to the number of result columns, the number of returned rows, a specific number returned within the resultset? Are the names of the fields dependant on the resultset field names, the number of fields, the values of the fields? The question was not so vague as to fail to mention the building needed windows and some doors but there was little indication to their orientation.....the fact that I'm the only tech. in the office while everyone else is out having fun has absolutely nothing to do with it :glare: 😉

branston

Apologies for being too vague. I was looking for a starting point to learn from and trying to avoid being complicated.

The form output is being used as input to another system by a program (Aimsoft) that keys in for you. The system that it will key into has multiple screens with varying numbers of input fields.

Because of the quantity of screens involved I did not want to have a script per underlying screen but instead have each database row to be a profile of a screen so that depending upon the screen selected, a form is displayed with the correct fields allowing the data to be input, manipulated and then automatically re-keyed into the other system.

The underlying system is an old screen screen application without mouse movements etc so each field on it is a simple input box.

Ideally the profile will hold the number of inputs on the underlying screen together with input length, input type for validation (eg date) and input sequence.

I have assumed so far that the database will have 2 tables, 1 to described the underlying screen and the 2nd to described each input field.

I hope that makes sense.

Thanks again

bubblenut

Oooh, even funkier than I first thought. You're right, you're going to need to two tables (assuming you need to store some data about the page in general). Then it'll be pretty simple.

$sql="SELECT * FROM form, element WHERE form.form_id=element.form_id && form.form_id=$form_id";
$res=mysql_query($sql) or die($sql."<br />\n".mysql_error());
$row=mysql_fetch_array($res);
//get the page details
$page_title=$row['page_title'];
//...
echo("<form name=\"$form_name\" method=\"$form_method\" action=\"$form_action\">");
do{
echo('<input type="text" name="'.$row['element_name'].'" />');
} while($row=myqsl_fetch_array($res));
echo("</form>");

HTH
Bubble