MYSQL: Making each row an array

i3x171um

tekky

I dunno if this is something you wrote... but it looks overly complex for something that should be fairly simple... (maybe I'm missing someting...) (besides the 'h' in something... :rolleyes: )

while($row = mysql_fetch_assoc($result))
{
    foreach($row as $key => $val)
    {
        $$key[] = $val;
    }
}

DB looks like...
name age type
Bob 12 A
Joe 3 B
Jane 31 C

SELECT * FROM table WHERE 1
produces...
$name[0] = Bob
$name[1] = Joe
$name[2] = Jane
$age[0] = 12
$age[1] = 3
$age[2] = 31
$type[0] = A
$type[1] = B
$type[2] = C

i3x171um

OH! wait.. thats a foreach loop.. sorry, i didnt see the code..

I think thats the answer I want.. hold on, let me test...

i3x171um

nemonoman

Re: Your concern with:

if (mysql_fetch_assoc($request)) 
{ 
   //The first row was removed in the check, you're one short! 
   while ($row = mysql_fetch_assoc($request)) 
   { 
       echo 'In WHILE loop'; 
   } 
}

You don't need the if statement. Start with the while test.

   while ($row = mysql_fetch_assoc($request)) 
   { 
       echo 'In WHILE loop'; 
   }

If no rows were returned by the query, the while loop won't execute.