[SOLVED] taking SELECT results and turning them into an array()

[ballhogjoni]

Does anyone know how take a mysql select statement and have the results placed into an array? I am returning 1+ rows and want to place those rows into an array so I can run a foreach() for each row and then run another foreach() for each column for each row?

 

EDIT: I know about mysql_fetch_array() and it just places 1 row's columns into an array.

[SammyGunnz]

<?php

      $query = "SELECT * FROM `mytable` WHERE `date`='$date'";      
      $q = $db->query($query, $var);

        while($row = $db->fetch_array($q)) {
          
          foreach($row as $r) {
            // Do yo' thang //
          }            
        }

?>

 

Using a while loop and then a foreach isn't an option?

[ballhogjoni]

whats all this -> stuff? I don't know what that means.

[SammyGunnz]

Then ignore it for now...though I do recommend looking into OOP (Object oriented Programming). Especially if you don't want to be repetitive with your code.

<?php

      $query = "SELECT * FROM `mytable` WHERE `date`='$date'";      
      $q = mysql_query($query, $var);

        while($row = mysql_fetch_array($q)) {
          
          foreach($row as $r) {
            // Do yo' thang //
          }            
        }

?>

[ballhogjoni]

thank you. I will look into it.

[ballhogjoni]

Where did you get the $var in the mysql_query()? and what is it used for?