PHP Error message: Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/jplane/certcent/phpweb/quiz/index.php on line 20

[techjohnny]

Error:

Warning: mysql_query(): supplied argument is not a valid MySQL-Link
resource in /home/jplane/certcent/phpweb/quiz/index.php on line 20

Warning: mysql_num_rows( ): supplied argument is not a valid MySQL
result resource in /home/jplane/certcent/phpweb/quiz/index.php on line
21

PHP CODE:

session_start() ;
require_once('i nc/db_config.inc.p hp');
$conn = db_connect();

if (isset($HTTP_SE SSION_VARS['scoreboard'])) {
echo '<p id="hornav"><a href="results.p hp">View Results Sheet</a></
p>';
}
?>
<h2>Welcome to the Test Zone</h2>
<h3>Please select a subject area and the number of questions you wish
to answer.</h3>
<ol id="numbered">
<?php
$sqlsu = "SELECT * FROM subjects ORDER BY ID";
line 20 $ressu = mysql_query($sq lsu, $conn);
line 21 if (mysql_num_rows ($ressu)) {

[ZeldorBlat]

On Jun 15, 7:27 pm, "techjoh...@gma il.com" <techjoh...@gma il.com>
wrote:

Error:

Warning: mysql_query(): supplied argument is not a valid MySQL-Link
resource in /home/jplane/certcent/phpweb/quiz/index.php on line 20

Warning: mysql_num_rows( ): supplied argument is not a valid MySQL
result resource in /home/jplane/certcent/phpweb/quiz/index.php on line
21

PHP CODE:

session_start() ;
require_once('i nc/db_config.inc.p hp');
$conn = db_connect();

if (isset($HTTP_SE SSION_VARS['scoreboard'])) {
echo '<p id="hornav"><a href="results.p hp">View Results Sheet</a></
p>';}

?>
<h2>Welcome to the Test Zone</h2>
<h3>Please select a subject area and the number of questions you wish
to answer.</h3>
<ol id="numbered">
<?php
$sqlsu = "SELECT * FROM subjects ORDER BY ID";
line 20 $ressu = mysql_query($sq lsu, $conn);
line 21 if (mysql_num_rows ($ressu)) {

The message means you aren't connected to the database -- or, more
specifically, that $conn is not a valid connection resource.

What's in inc/db_config.db.ph p ?

[Jerry Stuckle]

te********@gmai l.com wrote:

Error:

Warning: mysql_query(): supplied argument is not a valid MySQL-Link
resource in /home/jplane/certcent/phpweb/quiz/index.php on line 20

Warning: mysql_num_rows( ): supplied argument is not a valid MySQL
result resource in /home/jplane/certcent/phpweb/quiz/index.php on line
21

PHP CODE:

session_start() ;
require_once('i nc/db_config.inc.p hp');
$conn = db_connect();

if (isset($HTTP_SE SSION_VARS['scoreboard'])) {
echo '<p id="hornav"><a href="results.p hp">View Results Sheet</a></
p>';
}
?>
<h2>Welcome to the Test Zone</h2>
<h3>Please select a subject area and the number of questions you wish
to answer.</h3>
<ol id="numbered">
<?php
$sqlsu = "SELECT * FROM subjects ORDER BY ID";
line 20 $ressu = mysql_query($sq lsu, $conn);
line 21 if (mysql_num_rows ($ressu)) {

Check the result from mysql_query. You'll find it returned false,
probably because of a proboem with the select statement.

Also see mysql_error() in the doc to help you diagnose your error.

--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attgl obal.net
=============== ===