CREATE TABLE  `membre` (

`id` mediumint(8) NOT NULL auto_increment DEFAULT '0',

`Pseudo` varchar(30) NOT NULL default '',

`pass` varchar(32) NOT NULL default '',

) Type=MyISAM, AUTO_INCREMENT=1;

<?php

session_start();

?>

<form method="post">

<input type="text" name="login" value="Login" /><br/>

<input type="password" name="pass" value="pasznkjfd" />

<input type="submit" name="sub" value="Connexion" />

</form>

<?php



if(isset($_POST['sub']))

{

if(isset($_POST['login']) && isset($_POST['pass']) && !empty($_POST['login']) && !empty($_POST['pass']))

{

$sql = 'SELECT id,pseudo FROM membre WHERE pseudo = \''.htmlentities($_POST['login']).'\' AND pass = \''.md5($_POST['pass']).'\'';

$req = mysql_query($sql) or die(mysql_error());

if(mysql_num_rows($req) != 1)

{

echo 'Erreur lors de la connexion';

exit;

}

$data = mysql_fetch_array($req);

$_SESSION['id'] = $data['id'];

$_SESSION['pseudo'] = $data['pseudo'];



?>