CREATE TABLE IF NOT EXISTS journal (
userid MEDIUMINT UNSIGNED ZEROFILL NOT NULL,
journalid MEDIUMINT UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT PRIMARY KEY,
journal_title TEXT,
description TEXT,
type ENUM('jpg','gif','png'),
entries SMALLINT UNSIGNED DEFAULT 0,
views MEDIUMINT UNSIGNED DEFAULT 0
);

CREATE TABLE IF NOT EXISTS journal_entries (
entryid MEDIUMINT UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT PRIMARY KEY,
journalid MEDIUMINT UNSIGNED ZEROFILL NOT NULL,
date TIMESTAMP,
entry_title TEXT,
text TEXT,
threadid MEDIUMINT UNSIGNED DEFAULT 0
);

CREATE TABLE IF NOT EXISTS journal_photos (
photoid MEDIUMINT UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT PRIMARY KEY,
journalid MEDIUMINT UNSIGNED ZEROFILL NOT NULL,
entryid MEDIUMINT UNSIGNED NOT NULL,
type ENUM('jpg','gif','png')
);

function arassoc($select,$table,$condition,$index,$order,$c  ount,&$ar)
{
    global $connection;
    $sql = "SELECT $select
    FROM $table
    ";
    if ($condition != "") {
    $sql .= "WHERE $condition
    ";
    }
    if ($index != "") {
    $sql .= "ORDER BY $index";
    }
    if ($order != "") {
    $sql .= " $order
    ";
    }
    if ($count != "") {
    $sql .= "COUNT $count
    ";
    }
    connect($host,$user,$password,$db);
    $result = query($sql);
    $rows=mysql_num_rows($result);
    if ($rows!=0) {
      while ($row=mysql_fetch_assoc($result)) {
        $ar[]=$row;
      }
    }
    return $rows;
}