ciao e grazie per l'interessamento
in locale = Win Xp Pro SP2, Apache 2.0.55, PHP 4.3.2 Mysql 4.0.26
via web = Linus, Apache 1.3.37, PHP 4.4.4, Mysql 4.0.20
e questa è la porzione di codice
Codice PHP:
$dati="SELECT * FROM titoli";
$q = mysql_query($dati);
$nc = mysql_num_fields($q);
echo '<div class="area">
<table>
<tr><th colspan="2">Inserimento spettacoli</th></tr>
<FORM METHOD=POST ACTION=main.php?bottom=AreaR/ins2.php>';
for ($i = 1; $i < $nc; $i++) {
echo "<tr><td bgcolor=\"#eeeeee\"><font color=\"green\">".mysql_field_name($q, $i )."</font></td><td>\n";
if (mysql_field_name($q, $i) == 'tipo') {
echo '<SELECT NAME="tipo">';
$sql="SELECT DISTINCT tipo FROM titoli ORDER BY 'tipo' ";
$ris=mysql_query($sql);
$nrighe=mysql_num_rows($ris);
while ($riga = mysql_fetch_array($ris)) {
$tipo=$riga[tipo];
echo "<OPTION>".$tipo."\n"; }
echo "</select>\n";
} else {
if (mysql_field_len($q, $i) <= 80) {
echo "<INPUT TYPE=\"TEXT\" NAME=".mysql_field_name($q, $i )." VALUE=\"\" SIZE=".mysql_field_len($q, $i).">\n";
// echo "<INPUT TYPE=\"TEXT\" NAME=".mysql_field_name($q, $i )." VALUE=\"\" SIZE=".mysql_fieldlen($q, $i).">\n";
} else {
$row = mysql_field_len($q, $i)/65;
$cols = mysql_field_len($q, $i)/$row;
if (mysql_field_len($q, $i) <= 300) {
echo "<TEXTAREA NAME=".mysql_field_name($q, $i )." ROWS=".$row." COLS=".$cols." SIZE=".mysql_field_len($q, $i)." MAXLENGHT=".mysql_field_len($q, $i)."></TEXTAREA>\n";
} else {
echo "<TEXTAREA NAME=".mysql_field_name($q, $i )." ROWS=\"3\" COLS=\"65\"></TEXTAREA>\n";
}
}
echo "</td></tr>\n";
}
}
echo '
<tr>
<td align=center colspan="2" ><INPUT TYPE=SUBMIT VALUE=Invia></td>
</tr>
</form>
</table>
</div>';
non ho minimamente idea della causa del problema...
ciao e grazie