| Re: mysqli fetch_assoc() straight to array [message #186008] |
Fri, 30 May 2014 20:23  |
Lew Pitcher
Messages: 60
Registered: April 2013
Karma:
|
Member |
|
|
On Friday 30 May 2014 07:59, in comp.databases.mysql, "richard"
<noreply(at)example(dot)com> wrote:
>
> Is there a way to make it simpler to just load an array based upon the
> results of $row?
> Rather than having to assign each individual column one at a time?
/This/ is the sort of posting that I was talking about earlier.
Richard, this isn't a mysql issue. Mysql does not define how PHP manages
array assignments, PHP does.
> $array=$row
> Versus
> $array[col1]=$row[col1]
> $array[col2]=$row[col2]
>
>
> while ($y<=69){
> while ($n<=40){
>
> if ($n<10){$n="0".$n;}
> $x=$y.$n;
> $sql = "SELECT * FROM top20 where songs='$x'";
> $result = $mysqli->query($sql);
> $row = $result->fetch_assoc();
>
> echo $n.") ".$row['songs']."<br>";
>
> $n++;
>
> }
> $n=1;
> $y++;
> }
Followup set to comp.lang.php
FWIW, PHP permits assignment of arrays, so
$row = $result->fetch_assoc();
$array = $row;
echo $n.") ".$array['songs']."<br>";
is legal PHP code.
--
Lew Pitcher
"In Skills, We Trust"
PGP public key available upon request
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]