I (try to ) work in PHP (version 5.3.1) and in MySQL (version 5.1.41).
Firstly, I connected successfully with the Database with these commands
$link=mysql_connect('localhost', 'root', '');
I want to create tables from the table joomla.voting of the Database. The joomla.voting table is like the following
Item | user | score
120 | 1 | 5
120 | 2 | 1
121 | 1 | 4
121 | 3 | 2
…. …. ……
In this example we have two items (120,121), 3 users(1,2,3) and their votes(scores).
I want to create tables for each user with the items’ votes like that:
Where table1 is the table for user 1, table2 is for user 2, etc.
The first position of the table is the first item’ s vote (in the table 1, the number 5 is the vote for item 120)
The second position of the table is the second item’ s vote (in the table 1, the number 4 is the vote for item 121).
If the user hasn’t voted yet an item, I want to put zero (0) in this position (as in the example of the table2 where the user hasn’t voted the item 121).
My (theoretical) solution is:
- Count unique the items from the table joomla.voting ( if it is necessary, we sort them because we want the first item to be in the first position of the table(that we want to create), etc)
- Count the users from the table joomla.voting( if it is necessary, we sort them because we want the first table (that we want to create) to be for the first user , etc)
- Create the above (step 1 and 2) tables and if is necessary we put zero in the non voting item.
I cannot do that with PHP commands. Can anyone help me, please?