|
|
Posted by Rik on 06/19/07 23:39
On Wed, 20 Jun 2007 00:54:52 +0200, techjohnny@gmail.com =
<techjohnny@gmail.com> wrote:
> On Jun 19, 2:26 pm, Rik <luiheidsgoe...@hotmail.com> wrote:
>> On Tue, 19 Jun 2007 23:22:29 +0200, techjoh...@gmail.com
>>
>>
>>
>> <techjoh...@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.co=
m>
>> >> > 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 enab=
led
>> >> >> logging
>> >> >> > >> > ALL in the php.ini, but nothing. If I change the name o=
f =
>> the
>> >> db
>> >> >> in
>> >> >> > >> > the include file, I get an error message, so I guess thi=
s
>> >> means
>> >> >> it's
>> >> >> > >> > connecting to the mysql db. I've included the first cou=
ple
>> >> >> lines of
>> >> >> > >> > code for this page:
>>
>> >> >> > >> First rule of hunting errors: do not surpress any errors b=
y =
>> @ if
>> >> >> > >> something
>> >> >> > >> isn't working.
>>
>> >> >> > >> Second: I do not see any output, so as far as I'm concerne=
d =
>> 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 t=
he
>> >> query
>> >> >> > >> itself.
>>
>> >> >> > > The entire page:
>>
>> >> >> > Well, that's nice, I do not spot any clear syntax errors.(Tha=
t =
>> is,
>> >> if
>> >> >> I
>> >> >> > assume correctly that '// Check if scoreboard contains entrie=
s =
>> in
>> >> this
>> >> >> > category and, if so,list results' is on 1 single line) Howeve=
r,
>> >> 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 anythin=
g.
>>
>> >> And how many rows in the dataset? Keep in mind I normally say =
>> different
>> >> 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, t=
ry
>> again. Still keep in mind the earlier remark that if the query has ze=
ro
>> rows it will not show you anything in a browser (unless you look at t=
he
>> source).
>
> mysql> show tables;
> 2 rows in set (0.01 sec)
>
> mysql> select * from questions;
> Empty set (0.00 sec)
>
> mysql> select * from subjects;
> 1 row in set (0.00 sec)
>
> Just a little more information.
Little droplets keep pouring in, I've got a feeling we're almost =
there...:-). This offcourse is still not what I was asking, but it'll do=
: =
no data in the resultsets, so no output, ergo no information screen. =
Please fill you database, with junk if need be, but no data in it equals=
=
no output from it I'd think.
-- =
Rik Wasmus
Navigation:
[Reply to this message]
|