Re: mysql results, arrays, and for loops

"Philip Thompson" <prthomp@uark.edu> wrote in message news:539DCBEC-BBB2-11D8-8631-000393C795C4@uark.edu... > Hi all! > > I am using a select statement to obtain all the dates whenever someone > submitted a problem in a database. Well, I want to get the result > (which could be multiple dates) and then print that in a table format > with some other information on a webpage. So I want to use a FOR loops > and go through each of the dates and dynamically create a table. > > My question is: how do I store the results of the select query? Would I > want to store them in an array, and then just parse through each > element of the array, and what is the syntax for that? Or is there a > better way? You can loop through your query results in this way: $result = mysql_query('SELECT * FROM table'); while ($row = mysql_fetch_assoc($result)) { // row is now the current record set as an associative array, keys represent the field names // do what you want with row, e.g. print a field value from column date echo $row['date']; } Is this what you are looking for? Regards, Torsten Roehr