I want to Select random rows from database and list them out in order. Below is the code

Question

This is the Code:

<?php
    $db=mysqli_connect('localhost', 'root', '', 'db');
    $sql = 'SELECT `Questions`, `OptionA`, `OptionB`, `OptionC`, `OptionD` FROM `ccoai questions` ORDER BY RAND() LIMIT 2';
    $result = $db->query($sql);
    echo '<table width="100%">
    ';

    // Print each file
    for($i=0;$i<$limit;$i++)
    {
    echo "<ol><li>";
    while($row = $result->fetch_assoc()) {
       // $nice_date = date('d-m-Y', strtotime( $row['doregistration'] ));
        echo "
            <tr>
                <td>{$row['Questions']}</td></tr>
                <tr><td><input type='radio' value='{$row['OptionA']}'>{$row['OptionA']}</td></tr>
                <tr><td><input type='radio' value='{$row['OptionB']}'>{$row['OptionB']}</td></tr>
                <tr><td><input type='radio' value='{$row['OptionC']}'>{$row['OptionC']}</td></tr>
                <tr><td><input type='radio' value='{$row['OptionD']}'>{$row['OptionD']}</td></tr>
            </tr>";
    }

    // Close table
    echo '</li></ol></table>';
    }
}

// Free the result
$result->free();
}
 else
{
echo 'Error! SQL query failed:';
echo "<pre>{$db->error}</pre>";
}

// Close the mysql connection
$db->close();

    ?>

Right ^ and didn't you already ask something similar already and got an answer? https://stackoverflow.com/q/52644562/1415724 — Funk Forty Niner, Oct 09 '18 at 12:49
it doesnt work. It is stuck at 1. doesnt go beyond 1 in numbering — e-logiX Youtube, Oct 09 '18 at 12:50
Yes I did ask but others doesnt seem to know to actual problem — e-logiX Youtube, Oct 09 '18 at 12:50
What is stuck at 1 ? In your code, I dont see anything printing numbering. — Madhur Bhaiya, Oct 09 '18 at 12:54
Get rid of your `for` statement. It is trying to go up to `$limit` which you have not set. — waterloomatt, Oct 09 '18 at 12:56
Yes. for is a mistake. I removed for loop. Still the problem persist. — e-logiX Youtube, Oct 09 '18 at 12:58
I don't think that's going to work. I'm fairly sure you can't have list tags in the middle of a table tag that like, and you're iterating through all of the results before you hit the next list element anyway. Use a counter instead. — aynber, Oct 09 '18 at 12:58
Update your code in your question to the latest version. Also, you have a `LIMIT` in your query set to 2. How many rows are you expecting? — waterloomatt, Oct 09 '18 at 12:58
I just want every row with a number in order may be 1. 2. 3. or i. ii. iii. — e-logiX Youtube, Oct 09 '18 at 12:59
Remove the for loop and the list tags. Add a counter before the loop `$i = 1;`, echo it out before your question, then increment it at the end of the while loop. — aynber, Oct 09 '18 at 13:00

waterloomatt · Answer 1 · 2018-10-09T13:54:42.917

0

Documentation - https://developer.mozilla.org/en/docs/Web/HTML/Element/ol

Open the <ol> once and then add a single <li> for each row.

Edit - removed <tr> content because I am not sure what the expected output should be.

<?php
...
// Open the <ol> (ordered-list) once and the add one <li> (list item) for each row.
echo '<table width="100%"><ol>';

while ($row = $result->fetch_assoc()) {
    // Add a single <li> for each row.
    echo "<li>...</li>";
}

// Close the <ol> 
echo '</ol></table>';
...

edited Oct 09 '18 at 13:54

answered Oct 09 '18 at 13:11

waterloomatt

3,662
1
19
25

`Its still not working.` doesn't help me help you. What are you seeing? What are you not seeing? Is it because you're `LIMIT`ing your query to 2 rows and you're expecting more rows? – waterloomatt Oct 09 '18 at 13:48
1

you have tags inside of tags and are missing a tag at that. Im not sure syntax like that works – Matt Jameson Oct 09 '18 at 13:51

I want to Select random rows from database and list them out in order. Below is the code

1 Answers1