|
Posted by Jerry Stuckle on 06/16/07 02:17
techjohnny@gmail.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('inc/db_config.inc.php');
> $conn = db_connect();
>
> if (isset($HTTP_SESSION_VARS['scoreboard'])) {
> echo '<p id="hornav"><a href="results.php">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($sqlsu, $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.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|