Posted by techjohnny@gmail.com on 06/19/07 21:22

On Jun 19, 1:38 pm, Rik <luiheidsgoe...@hotmail.com> wrote:
> On Tue, 19 Jun 2007 21:47:46 +0200, techjoh...@gmail.com
>
>
>
> <techjoh...@gmail.com> wrote:
> > On Jun 19, 12:46 pm, "techjoh...@gmail.com" <techjoh...@gmail.com>
> > wrote:
> >> On Jun 19, 11:39 am, Rik <luiheidsgoe...@hotmail.com> wrote:
>
> >> > On Tue, 19 Jun 2007 20:11:44 +0200, techjoh...@gmail.com
>
> >> > <techjoh...@gmail.com> wrote:
> >> > > On Jun 19, 10:59 am, Rik <luiheidsgoe...@hotmail.com> wrote:
> >> > >> On Tue, 19 Jun 2007 19:18:02 +0200, techjoh...@gmail.com
>
> >> > >> <techjoh...@gmail.com> wrote:
> >> > >> > Ok,
>
> >> > >> > I posted earlier about this, a blank php page. I've enabled
> >> logging
> >> > >> > ALL in the php.ini, but nothing. If I change the name of the db
> >> in
> >> > >> > the include file, I get an error message, so I guess this means
> >> it's
> >> > >> > connecting to the mysql db. I've included the first couple
> >> lines of
> >> > >> > code for this page:
>
> >> > >> First rule of hunting errors: do not surpress any errors by @ if
> >> > >> something
> >> > >> isn't working.
>
> >> > >> Second: I do not see any output, so as far as I'm concerned if
> >> you've
> >> > >> got
> >> > >> no errors you would still see nothing.
>
> >> > >> - $qry['cat'] doesn't seem to be set anywhere, how come?
> >> > >> - check your queries for errors: echo mysql_error(), and the query
> >> > >> itself.
>
> >> > > The entire page:
>
> >> > Well, that's nice, I do not spot any clear syntax errors.(That is, if
> >> I
> >> > assume correctly that '// Check if scoreboard contains entries in this
> >> > category and, if so,list results' is on 1 single line) However, with
> >> no
> >> > query result the only output would be '</ol><br />', which obviously
> >> > doesn't show up in a browser.
>
> >> > Wether there's a parse error in your other includes I couldn't say.
>
> >> > So, check your queries, echo mysql_error(), check mysql_num_rows() and
> >> > echo it to check wether the result has data or is empty, etc.
>
> >> > --
> >> > Rik Wasmus
>
> >> Thanks.
> >> echo mysql_error();
>
> >> Warning: session_start(): Cannot send session cache limiter - headers
> >> already sent (output started at /www13/htdocs/quiz/inc/header.inc.php:
> >> 3) in /www13/htdocs/quiz/index.php on line 4
>
> > OK. I removed the header file and now it doesn't report anything.
>
> And how many rows in the dataset? Keep in mind I normally say different
> things in a post, not just one.
>
> --
> Rik Wasmus

Here is the mysql query:

DROP TABLE IF EXISTS questions;
CREATE TABLE questions (
ID int(4) unsigned zerofill NOT NULL auto_increment,
question text NOT NULL,
test varchar(31) NOT NULL default '',
ans1 text NOT NULL,
ans2 text NOT NULL,
ans3 text NOT NULL,
ans4 text NOT NULL,
ans5 text,
ans6 text,
corans varchar(8) NOT NULL default '',
expl text NOT NULL,
PRIMARY KEY (ID)
) TYPE=MyISAM;

DROP TABLE IF EXISTS subjects;
CREATE TABLE subjects (
ID int(4) unsigned zerofill NOT NULL auto_increment,
cat varchar(31) NOT NULL default '',
descr text NOT NULL,
random int(1) default NULL,
PRIMARY KEY (ID)
) TYPE=MyISAM;

[Back to original message]