Salve, ho il seguente script:
Codice PHP:
<?php
session_start();
include ("connessione.php");
if(isset($_POST['add']))
{
if(! get_magic_quotes_gpc() )
{
$name = addslashes ($_POST['project_name']);
$cyl = addslashes($_POST['cyl']);
}
else
{
$name = $_POST['project_name'];
$cyl =$_POST['cyl'];
}
if ($name == " " )
{
$_SESSION['form_error'] = 'Mandatory field! Please insert value.';
header("location: errore.php");
}
else{
$query = "INSERT INTO project_name "."(project_name) "." VALUES ('$name')";
$result = mysql_query($query);
if (!$result) {
$_SESSION['form_error'] = 'Empty field or the table already exists! Please insert value or checking in database.';
header("location: errore.php");
}
}
if ($cyl == "" )
{
$_SESSION['form_error'] = 'Mandatory field! Please insert value.';
header("location: errore.php");
}
else{
$sql = "INSERT INTO tabella"."(Fcyl) "." VALUES
('$cyl')";
mysql_select_db('rail');
$retval = mysql_query( $sql, $cn );
if(! $retval )
{
die('Could not enter data: ' . mysql_error());
}
if ($cyl ==1)
{
header("location: a.php");
}
else
{
header("location: b.php");
}
}}
else
{
/*HTML*/
<?php
}
?>
Non capisco perchè la seconda query riesco ad eseguirla e la prima no. Per quale motivo secondo voi? Dov'è l'errore? Grazie a tutti