RE: Mysql, ODBC and PHP

2002-11-13 Thread Ing. Mauricio Angulo Sillas 
Hi

It's not a MySQL issue, it's a web server configuration problem. Check
you php.ini file and unquote in the section:

;Windows Extensions


the line accordingly with the DB connexion you're using. MySQL is set by
default.

Also try the function odbc_fetch_into()


-Mensaje original-
De: Tokunboh Oladejo [mailto:tokunboh.oladejo;homeownersdream.com] 
Enviado el: miércoles, 13 de noviembre de 2002 14:11
Para: '[EMAIL PROTECTED]'
Asunto: Mysql, ODBC and PHP

I have a windows 2000 adv server that is running mysql and php in other
to
interact with couple of other Microsoft Access database.
 
However, I have a challenge with the function odbc_fetch_array( )
which is
returning a endefined function error when used with the ODBC
connection.
 
I have used mysql_fetch_array( ) with Mysql connection and it works
fine.
 
I have checked the php site for documentation on this function but there
is
none. Can anybody help.
 
 
Thanx
 
 
Toks

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: getting the number of years between two dates

2002-11-07 Thread Ing. Mauricio Angulo Sillas 
Well, actually I always use the Unix date format because is easier to
use with PHP... and makes easier to do this kind of calculations... ;)

-Mensaje original-
De: John Meyer [mailto:johnmeyer_1978;yahoo.com] 
Enviado el: jueves, 07 de noviembre de 2002 15:20
Para: Michael T. Babcock
CC: [EMAIL PROTECTED]
Asunto: RE: getting the number of years between two dates

Actually figured out one of my own:

FLOOR(PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM NOW()),EXTRACT(YEAR_MONTH FROM
UserDOB))/ 12) as Age

It's amazing what you can think of as soon as you ask the question.

-Original Message-
From: Michael T. Babcock [mailto:mbabcock;fibrespeed.net]
Sent: Thursday, November 07, 2002 1:58 PM
To: John Meyer
Cc: [EMAIL PROTECTED]
Subject: Re: getting the number of years between two dates


John Meyer wrote:

sql,query

How do I do that?  The contaxt is that I want to get somebody's age
based
upon the current date.



There are several examples in the mailing list archives; but try
subtracting the UNIX_TIMESTAMP of each date (which is the time in
seconds) and then divide by the number of seconds in a year (~365*86400)
...

--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php