Salve a Tutti
ho un problema con una query di delete...
io inserisco i dati su una pagina A (che manda i dati alla pagina B tramite post, in B avviene la query) in poche parole la query non dà alcun esito....non genera errori ma non elimina il record;
mi sapreste dare un aiuto?
pagina "A":
pagina "B"Codice PHP:<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Documento senza titolo</title>
</head>
<body>
<?
session_start();
$link = mysql_connect('localhost', '', '')
or die('Could not connect: ' . mysql_error());
mysql_select_db('my_fabiovergotti') or die('Could not select database');
$utente = $_POST['utente'];
$sesso = $_POST['sesso'];
$tipo = $_POST['tipo'];
$query = "SELECT DOMANDA FROM generale WHERE ID='".$utente."' AND PASSWORD='".$pwd."' AND SESSO='".$sesso."'";
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
$domanda=mysql_result($result,0,'DOMANDA');
$_SESSION['DOMANDA']=$domanda;
?>
<table width="100%" border="0">
<tr align="center" valign="middle">
<td align="left"><table width="100%" border="0">
<tr valign="middle">
<td width="50%" height="50%" align="right"><table width="69%" height="163" border="1" align="right">
<tr>
<td colspan="2">ACCOUNT DA ELIMINARE:</td>
</tr>
<tr>
<td>ID:</td>
</tr>
<tr>
<td>PASSWORD:</td>
</tr>
<tr>
<td>SESSO:</td>
</tr>
<tr>
<td height="29"><? echo $domanda ?></td>
</tr>
<tr>
<td> </td>
</tr>
</table></td>
<td width="50%" height="50%" align="left">
<form action="interrogazione.php" method="post" name="inviadati" >
<table width="55%" border="1">
<tr>
<td> </td>
</tr>
<tr>
<td><input name="utente" type="text" class="celle_inserimento" id="textfield" style="text-transform:capitalize"/></td>
</tr>
<tr>
<td><input name="pwd" type="text" class="celle_inserimento" id="pwd" style="text-transform:capitalize"/></td>
</tr>
<tr>
<td><select name="sesso" class="celle_inserimento" id="SESSO" >
<option selected="selected"> </option>
<option value="m">Maschio</option>
<option value="f">Femmina</option>
<option value="anonimo">Anonimo</option>
</select></td>
</tr>
<tr>
<td><input name="risposta" type="text" class="celle_inserimento" id="risposta" /></td>
</tr>
<tr>
<td><input type="submit" name="button" id="button" value="procedi" /></a></td>
</tr>
</table>
</form></td>
</tr>
</table></td>
</tr>
</table>
</body>
</html>
Codice PHP:<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Documento senza titolo</title>
</head>
<body>
<?
session_start();
$link = mysql_connect('localhost', '', '')
or die('Could not connect: ' . mysql_error());
mysql_select_db('my_fabiovergotti') or die('Could not select database');
$utente = $_POST['utente'];
$sesso = $_POST['sesso'];
$pwd = $_POST['pwd'];
$domanda = $_POST['domanda'];
$risposta = $_POST['risposta'];
// AND DOMANDA='".$domanda."'
$query = " SELECT * FROM generale WHERE ID='".$utente."' AND SESSO='".$sesso."' AND PASSWORD='".$pwd."' AND DOMANDA='".$domanda."' AND RISPOSTA='".$risposta."'";
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
$num_rows = mysql_num_rows($result);
//echo $num_rows;
if ($num_rows ==1){
$query = "DELETE * FROM generale WHERE ID='".$utente."' AND SESSO='".$sesso."' AND PASSWORD='".$pwd."' AND DOMANDA='".$domanda."' AND RISPOSTA='".$risposta."'";
}
//AND DOMANDA='".$domanda."'
?>
</body>
</html>
Grazie in anticipo
Fabio
P.S. sono Fabio1cgec.....ho dovuto cambiare host
