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](http://www.php.net/manual/en/function.mysql-query.php) — spencer7593, Jul 01 '14 at 20:40

score 3 · Accepted Answer · edited May 23 '17 at 12:00

You forgot to fetch your results

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

score 1 · Answer 2 · answered Jul 01 '14 at 20:45

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 01 '14 at 20:45

Jignesh Rawal

2 Answers2