Mysql selected set to multiple array

Question

$info = array
(
    while($row = mysqli_fetch_array($retval, MYSQL_ASSOC))
    {
        array($row["id"],$row["name"],$row["mname"],$row["sdate"],$row["fdate"],$row["bphoto"],$row["sphoto"],
        $row["text"],$row["one"],$row["two"],$row["three"],$row["four"],$row["five"],$row["six"],$row["seven"],
        $row["eight"],$row["nine"],$row["imdb"],$row["sztrailer"],$row["etrailer"]),
    }
);

Its Didn't worked. Please help me guys no i have more idea. (Sorry i have very bad english skill)

Parse error: syntax error, unexpected 'while' (T_WHILE), expecting ')' in .../Themes/default/sorozat.template.php on line 21

Thanks.

your login is not good first make the array and then add the values to it inside loop. — Rafael Shkembi, Jul 14 '16 at 07:36
You can't have a while loop inside an array declaration. You need to declare and initialise `$info = array()`. Then you need to fill the `$info` array with data within the loop. — scottevans93, Jul 14 '16 at 07:39

score 0 · Answer 1 · answered Jul 14 '16 at 07:40

Your code will not work. You can use this. First we make a array to store our values. After creating the array we store the values with a while loop. The key will be the id of your row

$info = array();
while($row = mysqli_fetch_array($retval, MYSQL_ASSOC)){    
    $info[$row["id"]]['name'] = $row["name"];
    $info[$row["id"]]['mname'] = $row["mname"];
    $info[$row["id"]]['sdate'] = $row["sdate"];
    $info[$row["id"]]['fdate'] = $row["fdate"];
    $info[$row["id"]]['bphoto'] = $row["bphoto"];
    $info[$row["id"]]['sphoto'] = $row["sphoto"];
    $info[$row["id"]]['text'] = $row["text"];
    $info[$row["id"]]['one'] = $row["one"];
    $info[$row["id"]]['two'] = $row["two"];
    $info[$row["id"]]['three'] = $row["three"];
    $info[$row["id"]]['four'] = $row["four"];
    $info[$row["id"]]['five'] = $row["five"];
    $info[$row["id"]]['six'] = $row["six"];
    $info[$row["id"]]['seven'] = $row["seven"];
    $info[$row["id"]]['eight'] = $row["eight"];
    $info[$row["id"]]['nine'] = $row["nine"];
    $info[$row["id"]]['imdb'] = $row["imdb"];
    $info[$row["id"]]['sztrailer'] = $row["sztrailer"];
    $info[$row["id"]]['etrailer'] = $row["etrailer"];
}

print_r($info);

score 0 · Answer 2 · answered Jul 14 '16 at 07:42

First of all, this looks really ugly. You gotta provide a better readability to your code.

Secondly, you should declare the $info array first instead of looping within the array itself.

Try this:

$info = array();

while($row = mysqli_fetch_array($retval, MYSQL_ASSOC))  {
        $info[] =   array(
               $row["id"], $row["name"], $row["mname"],
               $row["sdate"],$row["fdate"], $row["bphoto"], 
               $row["sphoto"], $row["text"], $row["one"],
               $row["two"], $row["three"], $row["four"],
               $row["five"], $row["six"], $row["seven"],
               $row["eight"],$row["nine"],$row["imdb"],
               $row["sztrailer"],$row["etrailer"]
           );
}

I post answer before your post. – Memphis Develerux Jul 14 '16 at 07:54 — Memphis Develerux, Jul 14 '16 at 07:54

Mysql selected set to multiple array

2 Answers2