> if(!($rs = mysql_query($q))) // querying
>   { echo "Query failed". mysql_error(); exit; }
> 
> 
>    $n = 0;
>   while ($line = mysql_fetch_assoc($rs)) { //dumping into an array
>     foreach ($line as $field => $value) {
>       $data[$field][$n] = $value;
>     }
>     $n++;
>   }
> 
> and this is how i use the arrays values (blah is the field name):
> $blah1=$data['blah'][0];
> $blah2=$data['blah'][1];
> $blah3=$data['blah'][2];

This should work.  Try it and see.
    $n = 0;
   while ($line = mysql_fetch_assoc($rs)) { //dumping into an array
     foreach ($line as $field => $value) {
        $tmp = $field.$n;
        $$tmp = $value;
        }
     $n++;
   }

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to