I guess there is a way to make a function out of this but ..

As i said... I have several calls to the same "action" which i guess
could be resolved as a function: but i'm learning and i have no idea how
to do that.

I post the code, extremely boring i suppose. It's in italian, but it
shouldnt make such a difference, right?

The idea is that of making a form where the select options are taken
straight out of a mysql table, actually, a single column.

<?php

$database=****;

$link = mysql_connect('localhost', '***', '**********'); # connette a
mysql con user e pass
if (!$link) {
die('Could not connect: ' . mysql_error());
}

@mysql_select_db($database) or die( "Unable to select database"); #
connette al database indicato nella var database



# qui comincia il form coi vari select per i vantaggi etc...

<form action="pagina3.php" method="post">
<select name="vantaggi1">
<option value="NULL" selected="selected">niente<br>
<?php

$i=0;
$query="select van from vantaggi";
$res=mysql_query($query);
for ($i=0;$i<19;$i++){
$val=mysql_result($res,$i);
echo "<option value='$val'>$val";
}
?>
</select>

<select name="vantaggi2">
<option value="NULL" selected="selected">niente<br>
<?php

$i=0;
$query="select van from vantaggi";
$res=mysql_query($query);
for ($i=0;$i<19;$i++){
$val=mysql_result($res,$i);
echo "<option value='$val'>$val";
}
?>
</select>

<select name="vantaggi3">
<option value="NULL" selected="selected">niente<br>
<?php

$i=0;
$query="select van from vantaggi";
$res=mysql_query($query);
for ($i=0;$i<19;$i++){
$val=mysql_result($res,$i);
echo "<option value='$val'>$val";
}
?>
</select>

# qui iniziano gli svantaggi

<br>
<select name="svantaggi1">
<option value="NULL" selected="selected">niente<br>
<?php

$i=0;
$query="select svan from svantaggi";
$res=mysql_query($query);
for ($i=0;$i<24;$i++){
$val=mysql_result($res,$i);
echo "<option value='$val'>$val";
}
?>
</select>

<select name="svantaggi"2>
<option value="NULL" selected="selected">niente<br>
<?php

$i=0;
$query="select svan from svantaggi";
$res=mysql_query($query);
for ($i=0;$i<24;$i++){
$val=mysql_result($res,$i);
echo "<option value='$val'>$val";
}
?>
</select>
<select name="svantaggi"3>
<option value="NULL" selected="selected">niente<br>
<?php

$i=0;
$query="select svan from svantaggi";
$res=mysql_query($query);
for ($i=0;$i<24;$i++){
$val=mysql_result($res,$i);
echo "<option value='$val'>$val";
}
?>
</select>

# qui iniziano le abilità speciali

<br>
<select name="abspec1">
<option value="NULL" selected="selected" >niente<br>
<?php

$i=0;
$query="select abspec from abspec";
$res=mysql_query($query);
for ($i=0;$i<11;$i++){
$val=mysql_result($res,$i);
echo "<option value='$val'>$val";
}

?>
</select>

<select name="abspec2">
<option value="NULL" selected="selected" >niente<br>
<?php

$i=0;
$query="select abspec from abspec";
$res=mysql_query($query);
for ($i=0;$i<11;$i++){
$val=mysql_result($res,$i);
echo "<option value='$val'>$val";
}

?>
</select>

<select name="abspec3">
<option value="NULL" selected="selected" >niente<br>
<?php

$i=0;
$query="select abspec from abspec";
$res=mysql_query($query);
for ($i=0;$i<11;$i++){
$val=mysql_result($res,$i);
echo "<option value='$val'>$val";
}
mysql_close($link);
?>
</select>

<input type="submit" value="spara">
</form>

On Sat, 15 Oct 2005 14:49:47 +0200, none wrote:

>As i said... I have several calls to the same "action" which i guess
>could be resolved as a function: but i'm learning and i have no idea how
>to do that.
>
>I post the code, extremely boring i suppose. It's in italian, but it
>shouldnt make such a difference, right?
>
>The idea is that of making a form where the select options are taken
>straight out of a mysql table, actually, a single column.
>

You can do something like this:

function options ($table, $field) {
$qy = "SELECT $field FROM $table";
$rs = mysql_query ($qy) or die (mysql_error());
while ($r = mysql_fetch_array($rs)) { ?>
<option value="<?=$r[0]?>">$r[0]?></option>
?> }
}

This way you can just pass the field and table to the function and
display the results for all of your options.