Yes, thanks to all that assisted. I got it working like a charm!
~Philip
On Jun 11, 2004, at 9:30 AM, Torsten Roehr wrote:
"Philip Thompson" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
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
--
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