~Philip
On Jun 11, 2004, at 9:30 AM, Torsten Roehr wrote:
"Philip Thompson" <prthomp@xxxxxxxx> wrote in message news:539DCBEC-BBB2-11D8-8631-000393C795C4@xxxxxxxxxxxHi 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
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
