hi guys a little advice???

[lanceox]

Hey everyone

 

A little advice would be great.  okay... I have a system that registers users and then allows them to take part in a quiz, which uses sessions and a database however what the problem is, is that i would like the user to be able to see the results of there quiz rather than destroying a session on logout.php

 

for example when they login, they will click member area for example and this will display info about the quiz they completed.... i.e. Scores

 

How would i do keep this info so its not lost on logging out??

 

Thanks in advance guys

 

Lance

[dawsba]

you have a database already!?! why not store it in there!?

[lanceox]

yea i have a db but im not too good with them. Havn't really used them much. How would i go about storing the users score in the DB so it can be retrieved?

 

 

[spiderwell]

the same way you store their details when they first register!

[lanceox]

ahhh okay, however rather than storing this information through a text field I would like to do it so the user can click save button on the final page and the  quiz information is stored onto the database.

 

How could i do this?

 

 

Thanks

[dawsba]

if you hold the scores in an array, cheat - use serialize and unserialize

$dbdata = serialize($scorearray);
$dbinject = mysql_query("INSERT INTO `tbl_dataheldhere` (`id`,`userid`,`date`,`data`)VALUES('','$userid',NOW(),'$dbdata')");