Hi,
I need a basic flashcard game in PHP + Mysql -------> in PDO queries :)
The database (as exemple) :
ID;Question;Answer;Category;SubCategory;Count
1;Speed Run of a dog?;35km/h;Animal;Dog;0
2;Speed Run of a cat?;12km/h;Animal;Cat;0
3;What eat a dog?;meat;Animal;Dog;0
4;What produce a dog?;Shit;Animal;Dog;0
5;What eat a cat?;Fish;Animal;Cat;0
As you can see below
i need :
1 search box
2 combobox (1 for catory and the other for subcategory)
When the user press search button,
The result must match the search
display the number of results + print a random question from the result
then the user can press a button to see the answer.. :)
when a question is displayed the attribute « count » need to incremented .
then the player can press the button to get a new question from the matching search
thx