Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql> SELECT * FROM answers ORDER BY question_id;
- +----+----------------------------+----------------+-----------+-------------+-------------------+
- | id | session_id | ip | survey_id | question_id | answer |
- +----+----------------------------+----------------+-----------+-------------+-------------------+
- | 1 | f9i0mg58lqnimjl37pi5519th7 | 192.168.59.170 | 1 | 1 | npoole@gmail.com |
- | 2 | f9i0mg58lqnimjl37pi5519th7 | 192.168.59.170 | 1 | 2 | 14 - 18 |
- | 3 | f9i0mg58lqnimjl37pi5519th7 | 192.168.59.170 | 1 | 3 | 5 - 10 |
- | 4 | f9i0mg58lqnimjl37pi5519th7 | 192.168.59.170 | 1 | 4 | 1 - 3 hours |
- | 5 | f9i0mg58lqnimjl37pi5519th7 | 192.168.59.170 | 1 | 5 | 1 - 2 days |
- | 6 | f9i0mg58lqnimjl37pi5519th7 | 192.168.59.170 | 1 | 6 | Adventure |
- | 7 | f9i0mg58lqnimjl37pi5519th7 | 192.168.59.170 | 1 | 6 | Puzzle |
- | 8 | f9i0mg58lqnimjl37pi5519th7 | 192.168.59.170 | 1 | 6 | Casual (Facebook) |
- | 9 | f9i0mg58lqnimjl37pi5519th7 | 192.168.59.170 | 1 | 7 | Yes |
- | 10 | f9i0mg58lqnimjl37pi5519th7 | 192.168.59.170 | 1 | 8 | Webkinznews.com |
- | 11 | f9i0mg58lqnimjl37pi5519th7 | 192.168.59.170 | 1 | 9 | No |
- | 12 | f9i0mg58lqnimjl37pi5519th7 | 192.168.59.170 | 1 | 11 | Yes |
- +----+----------------------------+----------------+-----------+-------------+-------------------+
- 12 rows in set (0.00 sec)
- I need the following format ...
- npoole@gmail.com | 14 - 18 | 5 - 10 | 1 - 3 hours | 1 - 2 days | Adventure | Yes | Webkinznews.com | No | Yes
- npoole@gmail.com | 14 - 18 | 5 - 10 | 1 - 3 hours | 1 - 2 days | Puzzle | Yes | Webkinznews.com | No | Yes
- npoole@gmail.com | 14 - 18 | 5 - 10 | 1 - 3 hours | 1 - 2 days | Casual (Facebook) | Yes | Webkinznews.com | No | Yes
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement