Select语句不起作用

Question

I have wrote a select query using function but it is not returning data from MySQL database... can any one help me in this regard. I'm uploading screenshots.

Here is the name of my database, 'classified'

this is conn.php file

$conn   =   mysql_connect('localhost','root','');  
echo mysql_select_db('classified',$conn);

function to fetch record from database, 'adds' table

On index.php i've wrote this code.

include 'functions/crud_functions.php'  
  $adds = get_all_adds();  
 foreach($adds as $add) {

<tr>                 
    <td><?php echo $add['id']; ?></td>
    <td><?php echo $add['ad_title'];?></td>
    <td><?php echo $add['cat_id'];?></td>
    <td><?php echo $add['ad_description'];?></td>
    <td><?php echo $add['avatar'];?></td>
    <td><?php echo $add['price'];?></td>
    <td><?php echo $add['contact'];?></td>
    <td><?php echo $add['name'];?></td>
    <td><?php echo $add['time'];?></td>
    <td><a href="#">Edit </a> | <a href="#">Del </a></td>
</tr> 

but this is not displaying records.

Answer 1

Change :

if ($result) {
  return TRUE;
} else {
  return FALSE;
}

into this :

if ($result) {
  return $data;
} else {
  return array();
}