Posted by Rik on 06/19/07 21:26

On Tue, 19 Jun 2007 23:22:29 +0200, techjohnny@gmail.com =

<techjohnny@gmail.com> wrote:

> 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 t=
he =

>> 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 i=
f
>> >> 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 i=
s, =

>> if
>> >> I
>> >> > assume correctly that '// Check if scoreboard contains entries i=
n =

>> 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 s=
ay.
>>
>> >> > 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 - head=
ers
>> >> 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 differ=
ent
>> things in a post, not just one.
>>
>
> 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=3DMyISAM;
>
> 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=3DMyISAM;
>

I can clearly see that's not the query you are performing. Round 2, try =
=

again. Still keep in mind the earlier remark that if the query has zero =
=

rows it will not show you anything in a browser (unless you look at the =
=

source).

-- =

Rik Wasmus

[Back to original message]