Hello, I have a small problem with a PHP script Im trying to make.
I've made a database designed to learn words (for a project)
The database consists of three tables:
Table users, with a.o.:
-userID(primary key)
-username
-e-mail
Tabel lists(lists of words people have created) with a.o.:
-listID(primary key)
-userID(foreign key)
Table words(created words with the list they belong to) with a.o.:
-wordID(primary key)
-listID(foreign key)
Now I would like to write a php script that shows for every userID: The nickname, the e-mail, the amount of lists created and the amount of words created.
Is this possible with php queries and if so, how?
I've made a database designed to learn words (for a project)
The database consists of three tables:
Table users, with a.o.:
-userID(primary key)
-username
Tabel lists(lists of words people have created) with a.o.:
-listID(primary key)
-userID(foreign key)
Table words(created words with the list they belong to) with a.o.:
-wordID(primary key)
-listID(foreign key)
Now I would like to write a php script that shows for every userID: The nickname, the e-mail, the amount of lists created and the amount of words created.
Is this possible with php queries and if so, how?