PHP fetching Data from MYSQL

Question

I am trying to fetch the flag field from mysql of the $_SESSION['sess_user'] But I dont know it never works with me... **

$c_user=$_SESSION['sess_user'];

    $queryflag = "SELECT `flag` FROM `members` WHERE `user`='" . $c_user . "'";
    $resultflag = mysql_query($queryflag);
    echo $resultflag;

**

Community · Accepted Answer · 2017-05-23 12:20:19Z

1

You need to use mysql_fetch_array() or mysql_fetch_assoc()

$resultflag = mysql_query($queryflag) or die(mysql_error());
while ($row = mysql_fetch_assoc($resultflag)) {
  print_r($row)
}

Please note that mysql_* functions were deprecated, you need to switch to PDO or MySQLI

edited May 23, 2017 at 12:20

CommunityBot

11 silver badge

answered Sep 9, 2013 at 18:14

user1646111

Sign up to request clarification or add additional context in comments.

Comments

phponwebsites · Accepted Answer · 2014-10-31 09:15:38Z

0

Try this method,

   $name = $_SESSION['sess_user'];
   $q = mysql_query("select flag from members where user='".$name."' ") or die(mysql_error());
   $res = mysql_fetch_assoc($q);
   $flag = $res['flag'];

You can use mysql_fetch_assoc() to retrieve filed from database here. Reference: here

answered Oct 31, 2014 at 9:15

phponwebsites

6717 silver badges9 bronze badges

Collectives™ on Stack Overflow

PHP fetching Data from MYSQL

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related