mysql_result trouble

[Alexandre]

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,a vatard,email FROM utilisateur
WHERE nom_utilisateur = '$nom_utilisate ur'";
$req = mysql_query($se lect) or die('Erreur SQL !');
$nom = mysql_result($r eq,0,"nom");
$prenom = mysql_result($s elect,0,"prenom ");
$adresse = mysql_result($s elect,0,"adress e");
$email = mysql_result($s elect,0,"email" );

I only can print $nom value anybody see ?

thanks in advance

[Michael Fesser]

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,a vatard,email FROM utilisateur
> WHERE nom_utilisateur = '$nom_utilisate ur'";
>$req = mysql_query($se lect) or die('Erreur SQL !');
>$nom = mysql_result($r eq,0,"nom");
>$prenom = mysql_result($s elect,0,"prenom ");
>$adresse = mysql_result($s elect,0,"adress e");
>$email = mysql_result($s elect,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_ass oc(), would be much
easier and probably faster.

Micha

[Jacob Atzen]

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,a vatard,email FROM utilisateur
> WHERE nom_utilisateur = '$nom_utilisate ur'";
> $req = mysql_query($se lect) or die('Erreur SQL !');
> $nom = mysql_result($r eq,0,"nom");
> $prenom = mysql_result($s elect,0,"prenom ");
> $adresse = mysql_result($s elect,0,"adress e");
> $email = mysql_result($s elect,0,"email" );
>
> I only can print $nom value anybody see ?[/color]

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

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

You might want to look into mysql_fetch_arr ay() though.

--
Cheers,
- Jacob Atzen