I have a MySQL database that will contain questions for a quiz. It's columns are
Date
Question Number
Question
Answer
I need to have some code written that will pull the 10 questions on a date and display them on a webpage.
So far I have this
===
<h2>Today's questions <span class = "light">(1 point each)</span></h2>
<div class = "questions">
<?php
// SELECT RECORDS WHERE DATE MATCHES THE CURRENT DATE
$result = mysql_query("SELECT * FROM dailyqanda WHERE date=CURRENT_DATE()");
$num=mysql_num_rows($result);
// PRINT THE RESULT
$row = mysql_fetch_assoc($result);
echo "<p><strong>"; echo $row['question-num'];echo ".</strong> ";
echo $row['questions'];echo "</p>";
?>
</div><!-- END QUESTIONS -->
===
Urgent job, need completed within 30 minutes
Good day!
I could certainly give you a hand right away, but will require access to your server and DB.
Come chat with me so we can discuss this project - I'm ready to start right away :)
I've lowered my bid :)
Dear sir, please contact me. We will discuss about your requirements. When I understand your requirements I'll do it for you. In your code I see it get all question of the day and show the first question_num and question in list. I understand now you want get 10 questions and show all 10 questions.