Recupero ID

[Rossella_75]

ciao a tutti,

è corretto recuperare l'ID cosi:

if($user != ""){
	mysql_select_db($database_conn, $conn);
	$query = "SELECT user, password FROM clienti WHERE user='$user' AND password='$password'";
	$Login = mysql_query($query, $conn) or die(mysql_error());
	$row_result = mysql_fetch_assoc($Login);
	$totalRows_result = mysql_num_rows($Login);
	if(mysql_num_rows($Login)) {
	$_SESSION['username'] = $row_result['ID']; 
	header("Location: autenticato.php"); 
	exit;
	}else{
	 $risp = "ERROR!";  
	}
}

mi torna sempre nullo :master:

[Rossella_75]

scusate la domanda stupida

if($user != ""){
	mysql_select_db($database_conn, $conn);
	$query = "SELECT * FROM clienti WHERE user='$user' AND password='$password'";
	$Login = mysql_query($query, $conn) or die(mysql_error());
	$row_result = mysql_fetch_assoc($Login);
	$totalRows_result = mysql_num_rows($Login);
	$id = $row_result['ID'];
	if(mysql_num_rows($Login)) {
	$_SESSION['username'] = $user; 
	header("Location: autenticato.php?id=$id"); 
	exit;
	}else{
	 $risp = "ERROR! $id";  
	}
}

[andr3a]

SELECT id FROM clienti WHERE user='$user' AND password='$password'
...

$id = $row_result['id'];