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,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

[Michael Fesser]

.oO(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,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 ?

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

[Jacob Atzen]

On 2005-01-20, Alexandre <wh**@msn.com> wrote:

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 ?
You're saying:
$nom = mysql_result($req,0,"nom"); ^^^^

But then you're saying:
$prenom = mysql_result($select,0,"prenom");

^^^^^^^

You might want to look into mysql_fetch_array() though.

--
Cheers,
- Jacob Atzen