true, ); $mdb2 =& MDB2::factory($dsn, $options); if (PEAR::isError($mdb2)) { echo ($mdb2->getMessage().' - '.$mdb2->getUserinfo()); } function getUserData($mdb2) { $query ="SELECT * FROM USER"; $result = $mdb2->query($query); // check if the query was executed properly if (PEAR::isError($result)) { echo ($result->getMessage().' - '.$result->getUserinfo()); exit(); } // fetch all and free the result $arr = $result->fetchAll(MDB2_FETCHMODE_ASSOC); $result->free(); $mdb2->disconnect(); return $arr; } // Get all users $users_arr = getUserData($mdb2); $number_users = count($users_arr); echo ""; echo ""; for($i=0;$i<$number_users;$i++){ echo ""; } echo '

Host	User	Password
".$users_arr[$i]['host']."	".$users_arr[$i]['user']."	".$users_arr[$i]['password']."

'; ?>