function has_child($id) { //$query = "select count(*) from collections where parent_id=$id"; $query = select_query("count(*)", "collections", "parent_id={$id}"); $rs = my_mysql_query($query); $row = my_mysql_fetch_array($rs); return $row[0] > 0 ? true : false; }
<?php include '../sql_helper.php'; include '../conn.php'; $result = array(); $query = select_query($_fields_collections, $_t_collections, NULL); $rs = my_mysql_query($query); while ($row = my_mysql_fetch_array($rs)) { array_push($result, $row); } echo json_encode($result);