Re: [PHP] Date Q

2002-05-10 Thread Jason Wong
On Friday 10 May 2002 13:14, Jason Soza wrote: Thanks for the code, but I already have: $result = mysql_query(SELECT * FROM table); select *, min(datefield) as mindate, max(datefield) as maxdate from table; Should work. It's been my general understanding that querying twice in one script

[PHP] Date Q

2002-05-09 Thread Jason Soza
If I have a MySQL field full of dates and other info, and my PHP script displays all this, how would I isolate the min and max in the date field? Like I want to print something like: Information, from 01-03-2001 through 01-03-2002 If someone could give me an example or point me to the manual

Re: [PHP] Date Q

2002-05-09 Thread Jason Wong
On Friday 10 May 2002 13:02, Jason Soza wrote: If I have a MySQL field full of dates and other info, and my PHP script displays all this, how would I isolate the min and max in the date field? Like I want to print something like: Information, from 01-03-2001 through 01-03-2002 If someone

RE: [PHP] Date Q

2002-05-09 Thread Jason Soza
script w/o querying again? -Original Message- From: Jason Wong [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 09, 2002 8:59 PM To: [EMAIL PROTECTED] Subject: Re: [PHP] Date Q On Friday 10 May 2002 13:02, Jason Soza wrote: If I have a MySQL field full of dates and other info, and my PHP

RE: [PHP] Date Q

2002-05-09 Thread Miguel Cruz
On Thu, 9 May 2002, Jason Soza wrote: Thanks for the code, but I already have: $result = mysql_query(SELECT * FROM table); And I use while ($row = mysql_fetch_array($result)) along with extract($row) to get my data. It's been my general understanding that querying twice in one script is

RE: [PHP] Date Q

2002-05-09 Thread Martin Towell
= curr_date ... // other code here } same logic can be used for numbers, strings, etc, etc. -Original Message- From: Miguel Cruz [mailto:[EMAIL PROTECTED]] Sent: Friday, May 10, 2002 3:13 PM To: Jason Soza Cc: [EMAIL PROTECTED] Subject: RE: [PHP] Date Q On Thu, 9 May 2002, Jason Soza