PHP Blank Page.

[techjohnny]

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:

index.php
<?php
session_start();
require_once('inc/db_config.inc.php');
$conn = db_connect();
$sqlsu = "SELECT * FROM subjects ORDER BY ID";
$ressu = mysql_query($sqlsu, $conn);
if (mysql_num_rows($ressu)) {
while ($qry = mysql_fetch_array($ressu)) {
$cat = stripSlashes($qry['cat']);
$resns = mysql_query("SELECT * FROM questions WHERE test LIKE '$cat'",
$conn);
$numcat = mysql_num_rows($resns);

inc/db_config.inc.php
function db_connect()
{
$result = @mysql_pconnect('localhost', 'root', 'password);
if (!$result)
return false;
if (!@mysql_select_db('quiz'))
return false;

return $result;
}
?>

[Rik]

On Tue, 19 Jun 2007 19:18:02 +0200, te********@gmail.com
<te********@gmail.comwrote:

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.

--
Rik Wasmus

[techjohnny]

On Jun 19, 10:59 am, Rik <[e-mail]:

On Tue, 19 Jun 2007 19:18:02 +0200, [e-mail]

<[e-mail]:

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.

--
Rik Wasmus

The entire page:

<?php
include('inc/header.inc.php');
require_once('inc/db_config.inc.php');
session_start();
$conn = db_connect();

$sqlsu = "SELECT * FROM subjects ORDER BY ID";
$ressu = mysql_query($sqlsu, $conn);
if (mysql_num_rows($ressu)) {
while ($qry = mysql_fetch_array($ressu)) {
$cat = stripSlashes($qry['cat']);
$resns = mysql_query("SELECT * FROM questions WHERE test LIKE '$cat'",
$conn);
$numcat = mysql_num_rows($resns);
if ($numcat 0) {
// Check if scoreboard contains entries in this category and, if so,
list results
if (isset($HTTP_SESSION_VARS['scoreboard']) &&
($HTTP_SESSION_VARS['scoreboard'][$cat])) {
$totsub = 0;
$correctans = 0;
foreach ($HTTP_SESSION_VARS['scoreboard'][$cat] as $questi)
{
if ($questi == 'c') { $correctans++; }
$totsub++;
}
}
echo "\n".'<form name="teststart'.$qry['ID'].'" action="quiz.php"
method="post">';
echo '<li><p id="hornav">';
if ((!$totsub) || ($totsub < $numcat)) {
if ($totsub) { $togo = ($numcat - $totsub); } else { $togo =
$numcat; }
echo '<select name="limit">';
if ($togo 5) { echo '<option value="5" SELECTED>5 questions</
option>'; }
for ($j = 1; $j < 12; $j++) {
if ($togo ($j * 10)) { echo '<option value="'.($j*10).'">'.($j*10).'
questions</option>'; }
}
echo '<option value="'.$togo.'">';
if ($togo 1) {echo ' all '; }
echo $togo;
if ($totsub 0) { echo ' remaining'; }
echo '</option></select>';
}
if ($totsub >= $numcat) {
echo ' Test completed</p>'; }
else if ($totsub 0) {
echo '<a href="javascript:document.teststart'.
$qry['ID'].'.submit()">Continue Test</a></p>'; }
else {
echo '<a href="javascript:document.teststart'.
$qry['ID'].'.submit()">Start Test</a></p>'; }

echo '<strong>'.$cat.'</strong';
echo '<em>('.$numcat.' questions)</em>';
echo '<br />';
echo '<input type="hidden" name="testsub" value="'.$cat.'">';
echo stripslashes($qry['descr']);

if ($totsub 0) {
echo '<h3>Total score: '.$correctans.'/'.$totsub.'</h3>';
$totsub = 0;
$correctans = 0;
}

echo '</li>'."\n".'</form>'."\n";

echo '<hr />';
}
}
}
?>

</ol>
<br />
<?php include_once('inc/footer.inc.php'); ?>

[Rik]

On Tue, 19 Jun 2007 20:11:44 +0200, te********@gmail.com
<te********@gmail.comwrote:

On Jun 19, 10:59 am, Rik <[e-mail]:

>On Tue, 19 Jun 2007 19:18:02 +0200, [e-mail]

<[e-mail]:

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

[techjohnny]

On Jun 19, 11:39 am, Rik <[e-mail]:

On Tue, 19 Jun 2007 20:11:44 +0200, [e-mail]

<[e-mail]:

On Jun 19, 10:59 am, Rik <[e-mail]:

On Tue, 19 Jun 2007 19:18:02 +0200, [e-mail]

<[e-mail]:
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

[techjohnny]

On Jun 19, 12:46 pm, "[e-mail]" <[e-mail]>
wrote:

On Jun 19, 11:39 am, Rik <[e-mail]:

On Tue, 19 Jun 2007 20:11:44 +0200, [e-mail]

<[e-mail]:

On Jun 19, 10:59 am, Rik <[e-mail]:
>On Tue, 19 Jun 2007 19:18:02 +0200, [e-mail]

><[e-mail]:
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.

-TJ

[Rik]

On Tue, 19 Jun 2007 21:47:46 +0200, te********@gmail.com
<te********@gmail.comwrote:

On Jun 19, 12:46 pm, "[e-mail]" <[e-mail]>
wrote:

>On Jun 19, 11:39 am, Rik <[e-mail]:

On Tue, 19 Jun 2007 20:11:44 +0200, [e-mail]

<[e-mail]:
On Jun 19, 10:59 am, Rik <[e-mail]:
On Tue, 19 Jun 2007 19:18:02 +0200, [e-mail]

><[e-mail]:
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

[techjohnny]

On Jun 19, 1:38 pm, Rik <[e-mail]:

On Tue, 19 Jun 2007 21:47:46 +0200, [e-mail]

<[e-mail]:

On Jun 19, 12:46 pm, "[e-mail]" <[e-mail]>
wrote:

On Jun 19, 11:39 am, Rik <[e-mail]:

On Tue, 19 Jun 2007 20:11:44 +0200, [e-mail]

<[e-mail]:
On Jun 19, 10:59 am, Rik <[e-mail]:
>On Tue, 19 Jun 2007 19:18:02 +0200, [e-mail]

><[e-mail]:
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;

[Rik]

On Tue, 19 Jun 2007 23:22:29 +0200, te********@gmail.com
<te********@gmail.comwrote:

On Jun 19, 1:38 pm, Rik <[e-mail]:

>On Tue, 19 Jun 2007 21:47:46 +0200, [e-mail]

<[e-mail]:

On Jun 19, 12:46 pm, "[e-mail]" <[e-mail]>
wrote:
On Jun 19, 11:39 am, Rik <[e-mail]:

On Tue, 19 Jun 2007 20:11:44 +0200, [e-mail]

<[e-mail]:
On Jun 19, 10:59 am, Rik <[e-mail]:
On Tue, 19 Jun 2007 19:18:02 +0200, [e-mail]

><[e-mail]:
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.

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;

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

[techjohnny]

On Jun 19, 2:26 pm, Rik <[e-mail]:

On Tue, 19 Jun 2007 23:22:29 +0200, [e-mail]

<[e-mail]:

On Jun 19, 1:38 pm, Rik <[e-mail]:

On Tue, 19 Jun 2007 21:47:46 +0200, [e-mail]

<[e-mail]:
On Jun 19, 12:46 pm, "[e-mail]" <[e-mail]>
wrote:
On Jun 19, 11:39 am, Rik <[e-mail]:

On Tue, 19 Jun 2007 20:11:44 +0200, [e-mail]

<[e-mail]:
On Jun 19, 10:59 am, Rik <[e-mail]:
>On Tue, 19 Jun 2007 19:18:02 +0200, [e-mail]

><[e-mail]:
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.

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;

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

mysqlshow tables;
+----------------+
| Tables_in_quiz |
+----------------+
| questions |
| subjects |
+----------------+
2 rows in set (0.01 sec)

mysqlselect * from questions;
Empty set (0.00 sec)

mysqlselect * from subjects;
+------+---------+---------+--------+
| ID | cat | descr | random |
+------+---------+---------+--------+
| 0001 | TESTING | TESTING | 1 |
+------+---------+---------+--------+
1 row in set (0.00 sec)

Just a little more information.

[Rik]

On Wed, 20 Jun 2007 00:54:52 +0200, te********@gmail.com
<te********@gmail.comwrote:

On Jun 19, 2:26 pm, Rik <[e-mail]:

>On Tue, 19 Jun 2007 23:22:29 +0200, [e-mail]

<[e-mail]:

On Jun 19, 1:38 pm, Rik <[e-mail]:
On Tue, 19 Jun 2007 21:47:46 +0200, [e-mail]

><[e-mail]:
On Jun 19, 12:46 pm, "[e-mail]" <[e-mail]>
wrote:
On Jun 19, 11:39 am, Rik <[e-mail]:

On Tue, 19 Jun 2007 20:11:44 +0200, [e-mail]

<[e-mail]:
On Jun 19, 10:59 am, Rik <[e-mail]:
On Tue, 19 Jun 2007 19:18:02 +0200, [e-mail]

><[e-mail]:
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.

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;

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).

mysqlshow tables;
2 rows in set (0.01 sec)

mysqlselect * from questions;
Empty set (0.00 sec)

mysqlselect * 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

[techjohnny]

On Jun 19, 4:39 pm, Rik <[e-mail]:

On Wed, 20 Jun 2007 00:54:52 +0200, [e-mail]

<[e-mail]:

On Jun 19, 2:26 pm, Rik <[e-mail]:

On Tue, 19 Jun 2007 23:22:29 +0200, [e-mail]

<[e-mail]:
On Jun 19, 1:38 pm, Rik <[e-mail]:
On Tue, 19 Jun 2007 21:47:46 +0200, [e-mail]

<[e-mail]:
On Jun 19, 12:46 pm, "[e-mail]" <[e-mail]>
wrote:
On Jun 19, 11:39 am, Rik <[e-mail]:

On Tue, 19 Jun 2007 20:11:44 +0200, [e-mail]

<[e-mail]:
On Jun 19, 10:59 am, Rik <[e-mail]:
>On Tue, 19 Jun 2007 19:18:02 +0200, [e-mail]

><[e-mail]:
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.

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;

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).

mysqlshow tables;
2 rows in set (0.01 sec)

mysqlselect * from questions;
Empty set (0.00 sec)

mysqlselect * 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

Thanks for all your time. I'm closing this issue, because it's now
working.

There's a good chance this was working all along. Since the questions
were failing to populated, the page wasn't displaying the subjects.

Lack of awareness is my problem.

--TJ