Hi, i would sen multiple select to mysql by form, my prb is:
[php]
file connect.php
<?php
$user="sundsx";
$pass="password ";
$db="testphp";
$val_form=$_POS T['val_form'];
$service =$_POST['service'];
mysql_connect(l ocalhost,$user, $pass);
@mysql_select_d b($db) or die( "Can't connect to db now");
$query = "INSERT INTO multi VALUES ('','$_POST[val_form]','$_POST[service]')";
mysql_query($qu ery);
mysql_close();
?>
file insert.php
!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dt d">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<title>Document o senza titolo</title>
</head>
<body>
<form action="connect .php" method="post">
<select name="val_form[]" size="4" multiple>
<option value="colloqio " >colloqio</option>
<option value="question ari chiusi" >questionari chiusi</option>
<option value="question ari aperti" >questionari aperti</option>
<option value="tesina-project work" >tesina-project work</option>
</select>
<br>
<select name="service[]" size="4" multiple>
<option value="patrocin io" >Patrocinio</option>
<option value="progetta zione" >Progettazion e</option>
<option value="valutazi one" >Valutazione</option>
<option value="docenti" >Docenti</option>
</select>
<br>
<input type="submit" value="Insert record">
</form>
</body>
</html>[/php]
was send on mysl:
ID Val_form service
20 Array Array
some help please?
Read the Posting Guidelines at the top of this forum before you continue!
Especially the part about enclosing code within php or code tags!!
moderator
[php]
file connect.php
<?php
$user="sundsx";
$pass="password ";
$db="testphp";
$val_form=$_POS T['val_form'];
$service =$_POST['service'];
mysql_connect(l ocalhost,$user, $pass);
@mysql_select_d b($db) or die( "Can't connect to db now");
$query = "INSERT INTO multi VALUES ('','$_POST[val_form]','$_POST[service]')";
mysql_query($qu ery);
mysql_close();
?>
file insert.php
!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dt d">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<title>Document o senza titolo</title>
</head>
<body>
<form action="connect .php" method="post">
<select name="val_form[]" size="4" multiple>
<option value="colloqio " >colloqio</option>
<option value="question ari chiusi" >questionari chiusi</option>
<option value="question ari aperti" >questionari aperti</option>
<option value="tesina-project work" >tesina-project work</option>
</select>
<br>
<select name="service[]" size="4" multiple>
<option value="patrocin io" >Patrocinio</option>
<option value="progetta zione" >Progettazion e</option>
<option value="valutazi one" >Valutazione</option>
<option value="docenti" >Docenti</option>
</select>
<br>
<input type="submit" value="Insert record">
</form>
</body>
</html>[/php]
was send on mysl:
ID Val_form service
20 Array Array
some help please?
Read the Posting Guidelines at the top of this forum before you continue!
Especially the part about enclosing code within php or code tags!!
moderator