Advanced Search

Results 1 to 3 of 3

Thread: quiz test website Warning: mysql_query():

  1. #1
    Join Date
    Nov 2011
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default quiz test website Warning: mysql_query():

    Hi all,
    I have been on hotscripts and downloaded a quiz, you know the type were by you make up the questions and answers (mutiwebtest)
    Anyway I was off to a flying start until I hit this error or 2

    Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/content/07/7560507/html/myquiz/index.php on line 21

    Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/content/07/7560507/html/myquiz/index.php on line 22

    This is a copy of my index.php

    <?php

    #All code is written by Neil Gardner and is copyright MultiWebVista 2003
    #This Quiz System is LinkWare,i.e. you are free to use it for your Website as long as you keep a
    #link back to MultiWebVista site at http://www.multiwebvista.com/index.php

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

    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";
    $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'); ?>

    Can anyone see a problem with this or even better know off a script that works without fault
    Regards Nige

  2. #2
    Join Date
    Apr 2008
    Location
    So.Cal
    Posts
    3,627
    Thanks
    63
    Thanked 516 Times in 502 Posts
    Blog Entries
    5

    Default

    Quote Originally Posted by mysql View Post
    Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/content/07/7560507/html/myquiz/index.php on line 21

    Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/content/07/7560507/html/myquiz/index.php on line 22
    the first warning means that $conn is not a valid mysql resource: i.e, db_connect() failed to establish a connection with your database.

    The second warning shows up because you're trying to use the result of a query that failed (because the connection failed).

    use mysql_error() to try and figure out what's going wrong.

    however, this is a rather old script. it's using things (like HTTP_SESSION_VARS, for example), that have been depreciated for some time. You'd be well-advised to find/write a new script.
    We Only Torture the Folks We Don't Like (You're Probably Gonna Be Okay)
    It's a Party in the CIA

  3. #3
    Join Date
    Nov 2011
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    Thanks a lot, This is a great forum maybe I will have a go at creating my own and use this site for tips

    Then maybe in a few years I will consider my self an (Elite Coder) but that is a long way away.
    Last edited by mysql; 11-21-2011 at 09:47 PM. Reason: hmmm

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •