mysql_result trouble

Hi I can't understand why when I execute a query :

$select = "SELECT nom_utilisateur, mot_de_passe,
nom,prenom,date_de_naissance,
site_internet,avatard,email FROM utilisateur
WHERE nom_utilisateur = '$nom_utilisateur'";
$req = mysql_query($select) or die('Erreur SQL !');
$nom = mysql_result($req,0,"nom");
$prenom = mysql_result($select,0,"prenom");
$adresse = mysql_result($select,0,"adresse");
$email = mysql_result($select,0,"email");

I only can print $nom value anybody see ?

thanks in advance

re: mysql_result trouble

.oO(Alexandre)
[color=blue]
>Hi I can't understand why when I execute a query :
>
>$select = "SELECT nom_utilisateur, mot_de_passe,
> nom,prenom,date_de_naissance,
> site_internet,avatard,email FROM utilisateur
> WHERE nom_utilisateur = '$nom_utilisateur'";
>$req = mysql_query($select) or die('Erreur SQL !');
>$nom = mysql_result($req,0,"nom");
>$prenom = mysql_result($select,0,"prenom");
>$adresse = mysql_result($select,0,"adresse");
>$email = mysql_result($select,0,"email");
>
>I only can print $nom value anybody see ?[/color]

You're passing $select instead of $req to the mysql_result() function.
Didn't PHP complain about that? Is error_reporting set to E_ALL?

You might also want to have a look at mysql_fetch_assoc(), would be much
easier and probably faster.

Micha

re: mysql_result trouble

On 2005-01-20, Alexandre <what@msn.com> wrote:[color=blue]
> Hi I can't understand why when I execute a query :
>
> $select = "SELECT nom_utilisateur, mot_de_passe,
> nom,prenom,date_de_naissance,
> site_internet,avatard,email FROM utilisateur
> WHERE nom_utilisateur = '$nom_utilisateur'";
> $req = mysql_query($select) or die('Erreur SQL !');
> $nom = mysql_result($req,0,"nom");
> $prenom = mysql_result($select,0,"prenom");
> $adresse = mysql_result($select,0,"adresse");
> $email = mysql_result($select,0,"email");
>
> I only can print $nom value anybody see ?[/color]

You're saying:
[color=blue]
> $nom = mysql_result($req,0,"nom");[/color]
^^^^

But then you're saying:
[color=blue]
> $prenom = mysql_result($select,0,"prenom");[/color]
^^^^^^^

You might want to look into mysql_fetch_array() though.

--
Cheers,
- Jacob Atzen