CODEWITHSUNDEEP
phpmysql
Kundan Raj
Kundan Raj

Reputation: 59

store value return by mysql in php variable

For the code below i am trying to get the gender value in gen then store it in $gender but i am getting wrong output. I am getting Resource id #8 as my output instead of male or female. What shall i do to get the gender value and store it in $gender with use of minimal coding.

$gender=mysql_query("SELECT `gender` as gen FROM `register` WHERE `reg_id` = 'reg252'");
echo $gender;

One way i can do is by calling something like the way below -

$gender=mysql_query("SELECT `gender` FROM `register` WHERE `reg_id` = 'reg252'");
while($erow = mysql_fetch_array($gender))
{
    echo $erow['gender'];
}

Upvotes: 0

Views: 943

Answers (3)

Sergey Telshevsky
Sergey Telshevsky

Reputation: 12217

You have in your SQL

SELECT `gender` as gen ...

While you output echo $erow['gender'];

So either output echo $erow['gen'];, either SELECT gender FROM ...

Upvotes: 0

Mina Abadir
Mina Abadir

Reputation: 2981

You are returning the column as gen, so you have to check gen echo $erow['gen'];

In general check the comment from PeeHaa

Upvotes: 0

Peter
Peter

Reputation: 16943

list($gender) = mysql_fetch_row(mysql_query("SELECT `gender` as gen FROM `register` WHERE `reg_id` = 'reg252'"));

Upvotes: 1

Related Questions