mysql php function doesn't return value

Question

Why doesn't this function do't return any row?

function select_mysql($tabel, $order, $volgorder, $statement) {
  $iCount = 0;
  $rows = array();
  $query = 'SELECT * FROM ' . $tabel . ' ' . $statement . 
           ' ORDER BY `' . $order . '` ' . $volgorder . '';
  $result = mysql_query($query) or die(mysql_error());
  while ($row = mysql_fetch_assoc($result)) {
    while ($property = mysql_fetch_field($result)) {
      $rows[$iCount][$property->name] = $row[$property->name];
    }

    $iCount++;
  }
  return $rows;
}

Are you sure that the query is valid? Try to insert echo $query and look at the result. — thejh
– thejh, Commented Nov 27, 2010 at 13:23

Marc B · Accepted Answer · 2010-11-27 13:23:23Z

1

There's no need for the mysql_fetch_field() inner loop. $row will be an associative array with all the row's field's in it. So if you've got fields a, b, c in that table, then you can access them with $row['a'], $row['b'], and $row['c'].

answered Nov 27, 2010 at 13:23

Marc B

362k44 gold badges433 silver badges508 bronze badges

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

Collectives™ on Stack Overflow

mysql php function doesn't return value

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related