UserPreferences

MysqlAdventures

using this SQL script 
CREATE TABLE edshare (
       course_id character(30),
       other_id character(30),
       priviledge character(15)
);
CREATE TABLE edlog (
       id character(15) NOT NULL,
       course_id character(30),
       logdate timestamp NOT NULL,
       message character(60)
);
CREATE TABLE reserve (
       doc_id int4 NOT NULL, 
       id character(15) NOT NULL, 
       course_id character(30) NOT NULL, 
       filename TEXT, 
       author TEXT, 
       year character(10), 
       publisher character(60), 
       title TEXT, 
       pages character(15), 
       status character,
       PRIMARY KEY (doc_id)
);
CREATE TABLE course_roster (
        id character(15) NOT NULL,
        course_id character(30) NOT NULL,
        status character,
        PRIMARY KEY (id, course_id)
);
CREATE TABLE course (
        course_id character(30) NOT NULL,
        course_desc character(70),
        id character(15) NOT NULL,
        webpage text,
        status character,
        background_image int4,
        PRIMARY KEY (course_id)
);
CREATE TABLE quest_bank (
        id character(15) NOT NULL,
        qbname character(15) NOT NULL,
        ku_gen character(15),
        qb_desc text,
        PRIMARY KEY (id, qbname)
);
CREATE TABLE know_unit (
        ku character(15) NOT NULL,
        ku_gen character(15) NOT NULL,
        PRIMARY KEY (ku, ku_gen)
);
CREATE TABLE ku_gen (
        ku_gen character(15) NOT NULL,
        PRIMARY KEY (ku_gen)
);
CREATE TABLE share_group (
        id character(15) NOT NULL,
        share_id character(4) NOT NULL,
        PRIMARY KEY (id, share_id)
);
CREATE TABLE exam_details (
        eid int4 NOT NULL,
        id  character(15),
        share text,
        description char(65)
);
CREATE TABLE exam_instance (
        eid int4 NOT NULL,
        iid int4 NOT NULL,
        qid int4 NOT NULL,
        version int NOT NULL,
        id char(15),
        rel_pos char(20),
        abs_pos int,
        score numeric(30,6)
);
CREATE TABLE people (
        id character(15) NOT NULL,
        status character,
        fname character(20),
        lname character(30),
        email character(50),
        privs text,
        webpage text,
        bio text,
        password character(32) NOT NULL,
        mylinks text,
        save_folders text,
        password_retrieve character(10),
        PRIMARY KEY (id)
);
CREATE TABLE course_grade (
        course_id character(30) NOT NULL,
        gname character(15) NOT NULL,
        type character(15),
        misc character(15),
        max numeric(30,6),
        pos numeric(30,6),
        gcat_name character(15) NOT NULL,
        weight numeric(30,6),
        PRIMARY KEY (course_id, gname)
);
CREATE TABLE grade_cat (
        course_id character(30) NOT NULL,
        gcat_name character(15) NOT NULL,
        percent numeric(30,6),
        PRIMARY KEY (course_id, gcat_name)
);
CREATE TABLE gradebook (
        course_id character(30) NOT NULL,
        gname character(15) NOT NULL,
        id character(15) NOT NULL,
        grade numeric(30,6),
        grade_letter character(5),
        misc character(15),
        PRIMARY KEY (course_id, gname, id)
);
CREATE TABLE assignments (
        assign_id int4 NOT NULL,
        course_id character(30) NOT NULL,
        description character(65),
        url text,
        status character,
        viewable character(1),
        field character(30),
        due timestamp,
        assigned timestamp,
        type character(30),
        text text,
        PRIMARY KEY (assign_id)
);
CREATE TABLE homework (
        assign_id int4 NOT NULL,
        id character(15) NOT NULL,
        turnin timestamp,
        filename text,
        title character(40),
        text text,
        PRIMARY KEY (assign_id, id)
);
CREATE TABLE question (
        iid int4 NOT NULL,
        qid int4 NOT NULL,
        version int NOT NULL,
        old_iid int4,
        old_qid int4,
        old_ver int,
        status character,
        id char(15), 
        qdate timestamp NOT NULL,
        qtype character(35),
        ku_subject character(70),
        ku character(70),
        level int4,
        question text,
        explanation text,
        options text,
        answer text,
        score float,
        PRIMARY KEY (iid, qid, version, qdate)
);
CREATE TABLE answer (
        manager_id int4 NOT NULL,
        eid int4 NOT NULL,
        iid int4 NOT NULL,
        qid int4 NOT NULL,
        pos int NOT NULL,
        version int NOT NULL,
        qdate timestamp NOT NULL,
        id character(15) NOT NULL,
        answer text,
        details text,
        PRIMARY KEY (manager_id, eid, iid, qid, version, id)
);
CREATE TABLE exam (
        manager_id int4 NOT NULL,
        eid int4,
        ename character(65),
        id char(15),
        course_id character(30),
        gradebook character(15),
        password character(15),
        start timestamp,
        stop timestamp,
        intro text,
        debrief text,
        type char(15),
        status char(1),
        feedback char(15),
        ordering char(15),
        PRIMARY KEY (manager_id)
);
CREATE TABLE submission (
        sub_id int4 NOT NULL,
        id character(15) NOT NULL,
        course_id character(30) NOT NULL,
        version int4 NOT NULL,
        sub_date timestamp NOT NULL,
        text text,
        status character(10), 
        PRIMARY KEY (sub_id, id, course_id, version)
);
CREATE TABLE question_select (
        iid int4 NOT NULL,
        qid int4 NOT NULL,
        id char(15) NOT NULL, 
        PRIMARY KEY (iid, qid, id)
);
REVOKE ALL on question_select from PUBLIC;
GRANT ALL on question_select to PUBLIC;
CREATE TABLE my_links (
        id char(15),
        url text, 
        description char(30)
);
REVOKE ALL on my_links from PUBLIC;
GRANT ALL on my_links to PUBLIC;CREATE TABLE edshare (
       course_id character(30),
       other_id character(30),
       priviledge character(15)
);
CREATE TABLE edlog (
       id character(15) NOT NULL,
       course_id character(30),
       logdate timestamp NOT NULL,
       message character(60)
);
CREATE TABLE reserve (
       doc_id int4 NOT NULL, 
       id character(15) NOT NULL, 
       course_id character(30) NOT NULL, 
       filename TEXT, 
       author TEXT, 
       year character(10), 
       publisher character(60), 
       title TEXT, 
       pages character(15), 
       status character,
       PRIMARY KEY (doc_id)
);
CREATE TABLE course_roster (
        id character(15) NOT NULL,
        course_id character(30) NOT NULL,
        status character,
        PRIMARY KEY (id, course_id)
);
CREATE TABLE course (
        course_id character(30) NOT NULL,
        course_desc character(70),
        id character(15) NOT NULL,
        webpage text,
        status character,
        background_image int4,
        PRIMARY KEY (course_id)
);
CREATE TABLE quest_bank (
        id character(15) NOT NULL,
        qbname character(15) NOT NULL,
        ku_gen character(15),
        qb_desc text,
        PRIMARY KEY (id, qbname)
);
CREATE TABLE know_unit (
        ku character(15) NOT NULL,
        ku_gen character(15) NOT NULL,
        PRIMARY KEY (ku, ku_gen)
);
CREATE TABLE ku_gen (
        ku_gen character(15) NOT NULL,
        PRIMARY KEY (ku_gen)
);
CREATE TABLE share_group (
        id character(15) NOT NULL,
        share_id character(4) NOT NULL,
        PRIMARY KEY (id, share_id)
);
CREATE TABLE exam_details (
        eid int4 NOT NULL,
        id  character(15),
        share text,
        description char(65)
);
CREATE TABLE exam_instance (
        eid int4 NOT NULL,
        iid int4 NOT NULL,
        qid int4 NOT NULL,
        version int NOT NULL,
        id char(15),
        rel_pos char(20),
        abs_pos int,
        score numeric(30,6)
);
CREATE TABLE people (
        id character(15) NOT NULL,
        status character,
        fname character(20),
        lname character(30),
        email character(50),
        privs text,
        webpage text,
        bio text,
        password character(32) NOT NULL,
        mylinks text,
        save_folders text,
        password_retrieve character(10),
        PRIMARY KEY (id)
);
CREATE TABLE course_grade (
        course_id character(30) NOT NULL,
        gname character(15) NOT NULL,
        type character(15),
        misc character(15),
        max numeric(30,6),
        pos numeric(30,6),
        gcat_name character(15) NOT NULL,
        weight numeric(30,6),
        PRIMARY KEY (course_id, gname)
);
CREATE TABLE grade_cat (
        course_id character(30) NOT NULL,
        gcat_name character(15) NOT NULL,
        percent numeric(30,6),
        PRIMARY KEY (course_id, gcat_name)
);
CREATE TABLE gradebook (
        course_id character(30) NOT NULL,
        gname character(15) NOT NULL,
        id character(15) NOT NULL,
        grade numeric(30,6),
        grade_letter character(5),
        misc character(15),
        PRIMARY KEY (course_id, gname, id)
);
CREATE TABLE assignments (
        assign_id int4 NOT NULL,
        course_id character(30) NOT NULL,
        description character(65),
        url text,
        status character,
        viewable character(1),
        field character(30),
        due timestamp,
        assigned timestamp,
        type character(30),
        text text,
        PRIMARY KEY (assign_id)
);
CREATE TABLE homework (
        assign_id int4 NOT NULL,
        id character(15) NOT NULL,
        turnin timestamp,
        filename text,
        title character(40),
        text text,
        PRIMARY KEY (assign_id, id)
);
CREATE TABLE question (
        iid int4 NOT NULL,
        qid int4 NOT NULL,
        version int NOT NULL,
        old_iid int4,
        old_qid int4,
        old_ver int,
        status character,
        id char(15), 
        qdate timestamp NOT NULL,
        qtype character(35),
        ku_subject character(70),
        ku character(70),
        level int4,
        question text,
        explanation text,
        options text,
        answer text,
        score float,
        PRIMARY KEY (iid, qid, version, qdate)
);
CREATE TABLE answer (
        manager_id int4 NOT NULL,
        eid int4 NOT NULL,
        iid int4 NOT NULL,
        qid int4 NOT NULL,
        pos int NOT NULL,
        version int NOT NULL,
        qdate timestamp NOT NULL,
        id character(15) NOT NULL,
        answer text,
        details text,
        PRIMARY KEY (manager_id, eid, iid, qid, version, id)
);
CREATE TABLE exam (
        manager_id int4 NOT NULL,
        eid int4,
        ename character(65),
        id char(15),
        course_id character(30),
        gradebook character(15),
        password character(15),
        start timestamp,
        stop timestamp,
        intro text,
        debrief text,
        type char(15),
        status char(1),
        feedback char(15),
        ordering char(15),
        PRIMARY KEY (manager_id)
);
CREATE TABLE submission (
        sub_id int4 NOT NULL,
        id character(15) NOT NULL,
        course_id character(30) NOT NULL,
        version int4 NOT NULL,
        sub_date timestamp NOT NULL,
        text text,
        status character(10), 
        PRIMARY KEY (sub_id, id, course_id, version)
);
CREATE TABLE question_select (
        iid int4 NOT NULL,
        qid int4 NOT NULL,
        id char(15) NOT NULL, 
        PRIMARY KEY (iid, qid, id)
);
REVOKE ALL on question_select from PUBLIC;
GRANT ALL on question_select to PUBLIC;
CREATE TABLE my_links (
        id char(15),
        url text, 
        description char(30)
);
REVOKE ALL on my_links from PUBLIC;
GRANT ALL on my_links to PUBLIC;

Error

SQL-query :

REVOKE ALL ON question_select FROM PUBLIC

MySQL said:

There is no such grant defined for user 'PUBLIC' on host '%' on table 'question_select'

This is probably user error issue but I'm having the darnedest time figuring out this last bit. Where is the % and PUBLIC coming from? Is it part of the edventure install config params?

Furthermore what is the point of it?

Any help appreciated. running phpMyAdmin 2.3.3pl1

MySQL 3.23.52 running on localhost as root@localhost

ok, got rid of the last REVOKE and GRANT statements and phpmyadmin made no complaints... so the new sql looks like this 
CREATE TABLE edshare (
       course_id character(30),
       other_id character(30),
       priviledge character(15)
);
CREATE TABLE edlog (
       id character(15) NOT NULL,
       course_id character(30),
       logdate timestamp NOT NULL,
       message character(60)
);
CREATE TABLE reserve (
       doc_id int4 NOT NULL, 
       id character(15) NOT NULL, 
       course_id character(30) NOT NULL, 
       filename TEXT, 
       author TEXT, 
       year character(10), 
       publisher character(60), 
       title TEXT, 
       pages character(15), 
       status character,
       PRIMARY KEY (doc_id)
);
CREATE TABLE course_roster (
        id character(15) NOT NULL,
        course_id character(30) NOT NULL,
        status character,
        PRIMARY KEY (id, course_id)
);
CREATE TABLE course (
        course_id character(30) NOT NULL,
        course_desc character(70),
        id character(15) NOT NULL,
        webpage text,
        status character,
        background_image int4,
        PRIMARY KEY (course_id)
);
CREATE TABLE quest_bank (
        id character(15) NOT NULL,
        qbname character(15) NOT NULL,
        ku_gen character(15),
        qb_desc text,
        PRIMARY KEY (id, qbname)
);
CREATE TABLE know_unit (
        ku character(15) NOT NULL,
        ku_gen character(15) NOT NULL,
        PRIMARY KEY (ku, ku_gen)
);
CREATE TABLE ku_gen (
        ku_gen character(15) NOT NULL,
        PRIMARY KEY (ku_gen)
);
CREATE TABLE share_group (
        id character(15) NOT NULL,
        share_id character(4) NOT NULL,
        PRIMARY KEY (id, share_id)
);
CREATE TABLE exam_details (
        eid int4 NOT NULL,
        id  character(15),
        share text,
        description char(65)
);
CREATE TABLE exam_instance (
        eid int4 NOT NULL,
        iid int4 NOT NULL,
        qid int4 NOT NULL,
        version int NOT NULL,
        id char(15),
        rel_pos char(20),
        abs_pos int,
        score numeric(30,6)
);
CREATE TABLE people (
        id character(15) NOT NULL,
        status character,
        fname character(20),
        lname character(30),
        email character(50),
        privs text,
        webpage text,
        bio text,
        password character(32) NOT NULL,
        mylinks text,
        save_folders text,
        password_retrieve character(10),
        PRIMARY KEY (id)
);
CREATE TABLE course_grade (
        course_id character(30) NOT NULL,
        gname character(15) NOT NULL,
        type character(15),
        misc character(15),
        max numeric(30,6),
        pos numeric(30,6),
        gcat_name character(15) NOT NULL,
        weight numeric(30,6),
        PRIMARY KEY (course_id, gname)
);
CREATE TABLE grade_cat (
        course_id character(30) NOT NULL,
        gcat_name character(15) NOT NULL,
        percent numeric(30,6),
        PRIMARY KEY (course_id, gcat_name)
);
CREATE TABLE gradebook (
        course_id character(30) NOT NULL,
        gname character(15) NOT NULL,
        id character(15) NOT NULL,
        grade numeric(30,6),
        grade_letter character(5),
        misc character(15),
        PRIMARY KEY (course_id, gname, id)
);
CREATE TABLE assignments (
        assign_id int4 NOT NULL,
        course_id character(30) NOT NULL,
        description character(65),
        url text,
        status character,
        viewable character(1),
        field character(30),
        due timestamp,
        assigned timestamp,
        type character(30),
        text text,
        PRIMARY KEY (assign_id)
);
CREATE TABLE homework (
        assign_id int4 NOT NULL,
        id character(15) NOT NULL,
        turnin timestamp,
        filename text,
        title character(40),
        text text,
        PRIMARY KEY (assign_id, id)
);
CREATE TABLE question (
        iid int4 NOT NULL,
        qid int4 NOT NULL,
        version int NOT NULL,
        old_iid int4,
        old_qid int4,
        old_ver int,
        status character,
        id char(15), 
        qdate timestamp NOT NULL,
        qtype character(35),
        ku_subject character(70),
        ku character(70),
        level int4,
        question text,
        explanation text,
        options text,
        answer text,
        score float,
        PRIMARY KEY (iid, qid, version, qdate)
);
CREATE TABLE answer (
        manager_id int4 NOT NULL,
        eid int4 NOT NULL,
        iid int4 NOT NULL,
        qid int4 NOT NULL,
        pos int NOT NULL,
        version int NOT NULL,
        qdate timestamp NOT NULL,
        id character(15) NOT NULL,
        answer text,
        details text,
        PRIMARY KEY (manager_id, eid, iid, qid, version, id)
);
CREATE TABLE exam (
        manager_id int4 NOT NULL,
        eid int4,
        ename character(65),
        id char(15),
        course_id character(30),
        gradebook character(15),
        password character(15),
        start timestamp,
        stop timestamp,
        intro text,
        debrief text,
        type char(15),
        status char(1),
        feedback char(15),
        ordering char(15),
        PRIMARY KEY (manager_id)
);
CREATE TABLE submission (
        sub_id int4 NOT NULL,
        id character(15) NOT NULL,
        course_id character(30) NOT NULL,
        version int4 NOT NULL,
        sub_date timestamp NOT NULL,
        text text,
        status character(10), 
        PRIMARY KEY (sub_id, id, course_id, version)
);
CREATE TABLE question_select (
        iid int4 NOT NULL,
        qid int4 NOT NULL,
        id char(15) NOT NULL, 
        PRIMARY KEY (iid, qid, id)
);
CREATE TABLE my_links (
        id char(15),
        url text, 
        description char(30)
);CREATE TABLE edshare (
       course_id character(30),
       other_id character(30),
       priviledge character(15)
);
CREATE TABLE edlog (
       id character(15) NOT NULL,
       course_id character(30),
       logdate timestamp NOT NULL,
       message character(60)
);
CREATE TABLE reserve (
       doc_id int4 NOT NULL, 
       id character(15) NOT NULL, 
       course_id character(30) NOT NULL, 
       filename TEXT, 
       author TEXT, 
       year character(10), 
       publisher character(60), 
       title TEXT, 
       pages character(15), 
       status character,
       PRIMARY KEY (doc_id)
);
CREATE TABLE course_roster (
        id character(15) NOT NULL,
        course_id character(30) NOT NULL,
        status character,
        PRIMARY KEY (id, course_id)
);
CREATE TABLE course (
        course_id character(30) NOT NULL,
        course_desc character(70),
        id character(15) NOT NULL,
        webpage text,
        status character,
        background_image int4,
        PRIMARY KEY (course_id)
);
CREATE TABLE quest_bank (
        id character(15) NOT NULL,
        qbname character(15) NOT NULL,
        ku_gen character(15),
        qb_desc text,
        PRIMARY KEY (id, qbname)
);
CREATE TABLE know_unit (
        ku character(15) NOT NULL,
        ku_gen character(15) NOT NULL,
        PRIMARY KEY (ku, ku_gen)
);
CREATE TABLE ku_gen (
        ku_gen character(15) NOT NULL,
        PRIMARY KEY (ku_gen)
);
CREATE TABLE share_group (
        id character(15) NOT NULL,
        share_id character(4) NOT NULL,
        PRIMARY KEY (id, share_id)
);
CREATE TABLE exam_details (
        eid int4 NOT NULL,
        id  character(15),
        share text,
        description char(65)
);
CREATE TABLE exam_instance (
        eid int4 NOT NULL,
        iid int4 NOT NULL,
        qid int4 NOT NULL,
        version int NOT NULL,
        id char(15),
        rel_pos char(20),
        abs_pos int,
        score numeric(30,6)
);
CREATE TABLE people (
        id character(15) NOT NULL,
        status character,
        fname character(20),
        lname character(30),
        email character(50),
        privs text,
        webpage text,
        bio text,
        password character(32) NOT NULL,
        mylinks text,
        save_folders text,
        password_retrieve character(10),
        PRIMARY KEY (id)
);
CREATE TABLE course_grade (
        course_id character(30) NOT NULL,
        gname character(15) NOT NULL,
        type character(15),
        misc character(15),
        max numeric(30,6),
        pos numeric(30,6),
        gcat_name character(15) NOT NULL,
        weight numeric(30,6),
        PRIMARY KEY (course_id, gname)
);
CREATE TABLE grade_cat (
        course_id character(30) NOT NULL,
        gcat_name character(15) NOT NULL,
        percent numeric(30,6),
        PRIMARY KEY (course_id, gcat_name)
);
CREATE TABLE gradebook (
        course_id character(30) NOT NULL,
        gname character(15) NOT NULL,
        id character(15) NOT NULL,
        grade numeric(30,6),
        grade_letter character(5),
        misc character(15),
        PRIMARY KEY (course_id, gname, id)
);
CREATE TABLE assignments (
        assign_id int4 NOT NULL,
        course_id character(30) NOT NULL,
        description character(65),
        url text,
        status character,
        viewable character(1),
        field character(30),
        due timestamp,
        assigned timestamp,
        type character(30),
        text text,
        PRIMARY KEY (assign_id)
);
CREATE TABLE homework (
        assign_id int4 NOT NULL,
        id character(15) NOT NULL,
        turnin timestamp,
        filename text,
        title character(40),
        text text,
        PRIMARY KEY (assign_id, id)
);
CREATE TABLE question (
        iid int4 NOT NULL,
        qid int4 NOT NULL,
        version int NOT NULL,
        old_iid int4,
        old_qid int4,
        old_ver int,
        status character,
        id char(15), 
        qdate timestamp NOT NULL,
        qtype character(35),
        ku_subject character(70),
        ku character(70),
        level int4,
        question text,
        explanation text,
        options text,
        answer text,
        score float,
        PRIMARY KEY (iid, qid, version, qdate)
);
CREATE TABLE answer (
        manager_id int4 NOT NULL,
        eid int4 NOT NULL,
        iid int4 NOT NULL,
        qid int4 NOT NULL,
        pos int NOT NULL,
        version int NOT NULL,
        qdate timestamp NOT NULL,
        id character(15) NOT NULL,
        answer text,
        details text,
        PRIMARY KEY (manager_id, eid, iid, qid, version, id)
);
CREATE TABLE exam (
        manager_id int4 NOT NULL,
        eid int4,
        ename character(65),
        id char(15),
        course_id character(30),
        gradebook character(15),
        password character(15),
        start timestamp,
        stop timestamp,
        intro text,
        debrief text,
        type char(15),
        status char(1),
        feedback char(15),
        ordering char(15),
        PRIMARY KEY (manager_id)
);
CREATE TABLE submission (
        sub_id int4 NOT NULL,
        id character(15) NOT NULL,
        course_id character(30) NOT NULL,
        version int4 NOT NULL,
        sub_date timestamp NOT NULL,
        text text,
        status character(10), 
        PRIMARY KEY (sub_id, id, course_id, version)
);
CREATE TABLE question_select (
        iid int4 NOT NULL,
        qid int4 NOT NULL,
        id char(15) NOT NULL, 
        PRIMARY KEY (iid, qid, id)
);
CREATE TABLE my_links (
        id char(15),
        url text, 
        description char(30)
);

but now when I click on http://localhost/edventure/index.php

I get 

query("SELECT * from exam WHERE manager_id = $mid and eid = $eid;"); display_exam($mid, $eid,...
blah blah blah

until moins moins gets the curly bracket thing fixed it's difficult to post real code

Well, to the best of my abilities I've followed the instructions but when I go to look at an edventure.php I'm getting code, not html. Curious. PHP is being rendered, I tested that. But the edventure php is not working. I'm thinking it has something to do with mysql setup...but I may be wrong. Ideas suggestions welcomed!- dgd

So checking on the system:

bash-2.05b$ netstat -a|grep mysql |tcp| 0| 0| *:mysql| *:*| LISTEN| unix 2| [ ACC ]| STREAM | LISTENING | 1520| /var/lib| /mysql/mysql.sock|

bash-2.05b$ ps -el|grep mysql 100 S | 27| 757| 725| 0| 75| 0| - 7231 schedu |?| 00:00:00 mysqld|

which all looks relvativlely good if I knew what I was looking at ;)

The one that bothers me is the ? after schedu

in looking at the source of the poorly rendered page I'm seeing that moz1.2 is rendering the top half of the code as commented and the bottom half appears 'normal'. check this out from [WWW]edventure 
define (ED_COPYRIGHT,"<font size=-1><i><a href=http://dangermouse.brynmawr.edu/edventure/docs/ 
 target=_top>" . ED_SITE_NAME . 

        "</a>, &copy; 1996-2002. Version " . ED_VERSION . "</i>"
right up <font size=-1> the code is commented out(it's a different color) and then afterwards rendered as 'normal' code but not as html in the page. The first page of all the .php from edventure appears this way.

same with index.php 

// FIX: check passowrd, if needed 
  ed_plain_header();
  $dbi = new dbi();
  $dbi->query("SELECT *
the code appears commented out in the source up till dbi->query is normal. Wow! This is getting curiouser and curiouser. So, what are my variables in play here: -I'm a newbie and don't know what I'm doing -Moz. 1.2 renders php strangely elsewhere? ( let's check that right now, nope no problem there but then again there's no mysql linkage in my test page...I've got to get that checked out)

Ok after using the mysql test script I'm sure that mysql and php are working together. The question of why edventure and mysql are not communicating remains....