mysql query returning wrong value

Question

<?php 
 $droll=$_SESSION['roll'];
 $sql=" SELECT name FROM hostel_register WHERE roll=$droll";
 $result=mysql_query($sql);
 echo $result;
?>

This code instead of returning name returns value "Resource id #5" everytime. Can someone help?

This behavior is expected and defined. The successful execution of the mysql_query function returns a resultset object, not a scalar value, not an array, etc. (N.B. Warning This extension is deprecated as of PHP 5.5.0, and will be removed in the future. Instead, the MySQLi or PDO_MySQL extension should be used.) http://www.php.net/manual/en/function.mysql-query.php — spencer7593
– spencer7593, Commented Jul 1, 2014 at 20:40

Community · Accepted Answer · 2017-05-23 12:00:05Z

3

You forgot to fetch your results

$result = mysql_query($sql);
$row = mysql_fetch_assoc($result);
echo $row['name'];

CommunityBot

11 silver badge

answered Jul 1, 2014 at 20:35

John Conde

220k100 gold badges464 silver badges504 bronze badges

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

Comments

Jignesh Rawal · Accepted Answer · 2014-07-01 20:45:15Z

1

While fetching the records use a while loop :

 <?php
  $result = mysql_query($sql);
  while($row = mysql_fetch_assoc($result)){
   echo $row['name'];
  }
 ?>

answered Jul 1, 2014 at 20:45

Jignesh Rawal

5497 silver badges21 bronze badges