Arrays ?? Help

Anon

Is there a way of creating an array from a mysql table.
For arguments sake I have in a mysql table a list of hobbies with index being id (Table name sports)eg below
id hobbie_name
1 Golf
2 Tennis
3 Footbal

etc etc
I have then made a mysql loop to move through these an output them as a form ie below
$result = mysql_query( "SELECT * FROM games ORDER BY hobbie_name" );
$nuw_rows = mysql_num_rows( $result );
while ( $a_row = mysql_fetch_array( $result ) )
{
print "<input type=\"checkbox\" name=\"game[]\" value=\"$a_row[id]\">$a_row[hobbie_name]<br>";
}
?>

This will then give me input box to tick so that you can select what games you like to play. I would then want to collect this info from the user store it as an array ?? poss then put it into the user details (table name user) ie
id user_name hobbie
1 j.bloggs ??
2 k.bloggs ??

How can i get this info of check boxes into mysql table and then read from it again. Is an array the way to go ??

Im a little confused any help would be gratefull

Thanks

Anon

Can you store it into array...

Sure you can... I am not going to write the whole code...but consider this...

array_push() function

you can store users choices into lets say $user=array(); then you can add stuff to $user doing this $user=array_push($user, $value)....

Then you can retrieve data out of an array and using multiple queries store them into database...

for example

$connection=mysql_connect("host", "user", "password");
$db=mysql_select_db("yourdatabase");
//initialize query array
$sql=array();
for($i=0; $i<count($user); $i++)
{
$sql[]="insert into $tablename values (null, \"$user[$i]\")";
}

for($i=0; $i<count($sql); $i++)
{
$res=mysql_query($sql[$i]);
}

//Then check if your query was successful
if($res)
{
echo "<script>window.alert(\"Successful query...\")</script>";
}

I hope that helps...

Modify code to suit your queries... But concept should work fine...