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 scr
n_date = 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,
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 sc
ur code into my 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 othe
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 som
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 sec
6 matches
Mail list logo