Re: [PHP-DB] date function

2003-11-02 Thread Martin Marques
1) Why do you send this to a DB list? 2) Try seeing the Date class of PEAR (PEAR::Date). El Dom 02 Nov 2003 19:13, OpenSource escribió: > Hi guys, > > This might not be the best place for this but here goes. > > I want to create a dropdown list with a date range of >

Re: [PHP-DB] date function

2003-11-02 Thread Ignatius Reilly
have a look at the PEAR date package. http://pear.php.net/package/Date _ - Original Message - From: "OpenSource" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, November 02, 2003 11:13 PM Subject: [PHP-DB] date function Hi guys,

Re: [PHP-DB] date function

2003-11-02 Thread Larry E . Ullman
This might not be the best place for this but here goes. You are correct. At the very least, you should probably be using the general PHP list, not the database one. I want to create a dropdown list with a date range of Not to be obstinate, but it looks like you already have. But, assuming t

[PHP-DB] date function

2003-11-02 Thread OpenSource
Hi guys, This might not be the best place for this but here goes. I want to create a dropdown list with a date range of -- Today Yesterday Fri 10/31 Thu 10/30 Wed 10/29 Tue 10/28 Mon 10/27 Sun 10/26 Sat 10/25 Fri 1

Re: [PHP-DB] date function

2003-09-05 Thread Jason Wong
On Saturday 06 September 2003 06:01, Darryl wrote: > I have some php code that pulls from the mysql database. Here it is: > > mysql_connect("wildcat.osborneindustries.com", "webuser", > "webpass"); >$mymonth = date('n'); >$cyear = date('Y'); > $query = "SELECT name,hdat

[PHP-DB] date function

2003-09-05 Thread Darryl
Greetings, I have some php code that pulls from the mysql database. Here it is: "; while ($r = mysql_fetch_array($result)) { $name = $r["name"]; $hyear = date('Y',$r["hdate"]); $timein = $cyear - $hyear; if ($timein > 0) { echo "$name$timein

[PHP-DB] Date function

2002-01-28 Thread Sridhar Moparthy
Hi All, Is there any function in PHP4.X or in Oracle8i to calculate number of Business days ( excluding Saturday and Sunday) between two given dates? Thanks in advance. Sridhar. -Original Message- From: qartis [mailto:[EMAIL PROTECTED]] Sent: Monday, January 28, 2002 1:38 PM To: [EMAIL

Re: [PHP-DB] Date function.

2001-01-19 Thread Marcelo Gulin
Hi Sharif! try... $date1 = "2001-07-01"; $date2 = "2001-07-31"; $query = "SELECT * FROM table WHERE birthdays BETWEEN $date1 AND $date2"; regards Marcelo Gulin Sharif Islam escribió: > > This is a simple mysql question i am having problme with. > I have a table with name and birth d

RE: [PHP-DB] Date function.

2001-01-19 Thread Dave Fudge
select * from BIRTHDAYS where substr(Date,5,2) = '07'; -Original Message- From: Sharif Islam [mailto:[EMAIL PROTECTED]] Sent: Friday, January 19, 2001 11:56 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Date function. This is a simple mysql question i am having problme with.

[PHP-DB] Date function.

2001-01-19 Thread Sharif Islam
This is a simple mysql question i am having problme with. I have a table with name and birth date; Joe | 1964-07-21 Mary | 1978-05-22 -- I want to get the name with birthdays in the month of July. thanks -- PHP Database Mailing List (http://www.php.net/) To u