[mdaoust]

Hey guys...

I'm trying to convert an array that is generated from MySQL into a valid array to be used for Sessions. Any help you can give would be appreciated. Here is what I have right now...

PHP Code:

    $sql = mysql_query("SELECT * FROM xxxx WHERE xxxx = '$u'");

    if(!$sql){

        header("Location: ".$baseURL."login.php?err=1");

        exit;

    }

    $row = mysql_fetch_array($sql); 

    foreach($row as $k => $v){

        $_SESSION[$k]=$v;

    } 

I know that this doesn't work properly as the session is not being passed to another page. However, if I outright declare the elements of the Sessions array as follows:

PHP Code:

    while($row = mysql_fetch_array($sql)){

        $_SESSION['clientId'] = $row['clientId'];

        $_SESSION['password'] = $row['password']; //etc..



    } 

the session passes with no problems.

Am I creating the Sessions Array improperly in the first example?