[PHP] looping through database results

2001-09-30 Thread Karl Nelson
I'm working on a basic calendar app in PHP, but I've hit a snag. The events are stored in a MySQL database, and the goal is to have the events displayed on the correct day on the calendar. The calendar is generated through a couple of while() statements that loop through the weeks and days. I'm

RE: [PHP] looping through database results

2001-09-30 Thread Jack Dempsey
many times as you want..think about making the result add the results to an array, and then use it where you need it -jack -Original Message- From: Karl Nelson [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 30, 2001 5:46 PM To: [EMAIL PROTECTED] Subject: [PHP] looping through dat

Re: [PHP] looping through database results

2001-09-30 Thread elists
On Sunday, September 30, 2001, at 02:45 PM, Karl Nelson wrote: > while ($event_row = mysql_fetch_array($events)) >{ >$event_day = $event_row["event_day"]; >if ($event_day == $day) > { > $event_name = $event_row["event_name"]; > print "$event_name\n"; > } >} > S

Re: [PHP] looping through database results

2001-09-30 Thread Karl Nelson
Thanks for your help, Andrew, but it didn't seem to work. As I read the manual (http://www.php.net/manual/en/function.mysql-fetch-array.php), mysql_fetch_array is much like mysql_fetch_row, except that it uses the field names instead of numbers as the array key. Somebody correct me if I'm wrong

RE: [PHP] looping through database results

2001-09-30 Thread Jack Dempsey
] Subject: Re: [PHP] looping through database results Thanks for your help, Andrew, but it didn't seem to work. As I read the manual (http://www.php.net/manual/en/function.mysql-fetch-array.php), mysql_fetch_array is much like mysql_fetch_row, except that it uses the field names inste