Grazie per la celere risposta
Provando il seguente codice:
Codice PHP:
if (isset($_POST['submit'])) {
$connection = mysql_connect('localhost', 'root', '') or die(mysql_error());
mysql_select_db('admin');
$email = $_POST['email'];
$password = $_POST['password'];
$query="SELECT admin_level FROM site_user WHERE email='$email' AND password='$password'";
$res=mysql_query($query);
$type=mysq_result($res,0,"admin_level");
switch($type)
{
case "0":header("Location:pagina1.php");break;
case "1":header("Location:pagina2.php");break;
}
}
?>
<body>
<form id="form1" name="form1" method="post" action="index.php">
<table width="273" border="0">
<tr>
<td width="119">Email</td>
<td width="144"><label>
<input type="text" name="email" id="email" />
</label></td>
</tr>
<tr>
<td>Password</td>
<td><label>
<input type="text" name="password" id="password" />
</label></td>
</tr>
<tr>
<td></td>
<td><label>
<input type="submit" name="submit" id="submit" value="Invia" />
</label></td>
</tr>
</table>
</form>
Ottengo
codice:
Fatal error: Call to undefined function mysq_result() in C:\Programmi\EasyPHP5.3.0\www\sito\prova\index.php on line 20