[PHP-DB] Re: Connecting to MS Access Database using PHP via ODBC.

2007-03-17 Thread Haydar TUNA 
Hello,
 Mr Frank is right. This is permission problem. I faced same problem 
to run Oracle and MS Access in Windows 2003. Microsoft has changed user 
privileges in Windows 2003. For example, I run a PHP program connect to 
oracle in Windows XP but it isn't run in Windows 2003. When I changed oracle 
installation directory's user privileges in Windows 2003, I was running php 
and oracle together. :)

-- 
Haydar TUNA
Republic Of Turkey - Ministry of National Education
Education Technology Department Ankara / TURKEY
Web: http://www.haydartuna.net

""ABCOM Support"" <[EMAIL PROTECTED]>, haber iletisinde þunlarý 
yazdý:[EMAIL PROTECTED]
> Hello,
>
> Im using PHP to connect to a Microsoft Access database which is not stored 
> on the machine where IIS is installed. It's located on a different file 
> server on the network.
>
> I have mapped a network drive to where the database is stored and have 
> used it when creating the System DSN.
>
> The problem is the the php script cannot connect. If I move a copy of the 
> database over to the server where IIS is installed and update the System 
> DSN to point to that it all works fine.
>
> I was made aware that you could have the database on a different machine 
> and it would work, but this doesnt seem to be the case.
>
> Can anyone shed some light on this?
>
> Many thanks. 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Values in a date field

2007-03-17 Thread tg-php 
Assuming you're using MySQL, try MONTH().  As in:

SELECT MONTH(SomeDateField) FROM SomeTable

http://dev.mysql.com/doc/refman/4.1/en/date-and-time-functions.html



If this isn't a database question, but a general PHP question, try this:

// For numeric month without leading zero, use "n"
echo date("n", strtotime($subscription_begins));

http://us3.php.net/manual/en/function.date.php

-TG

= = = Original message = = =

I have a $subscription_begins variable.  It the date type.  -MM-DD

How may I find out the month value (1 to 12) of this variable?

Ron


___
Sent by ePrompter, the premier email notification software.
Free download at http://www.ePrompter.com.

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] dst

2007-03-17 Thread Ron Croonenberg 
Actually I did and that worked,

someone suggested that earlier in the thread

thanks for responding, I appreciate it

Ron


Micah Stevens wrote:
> Did you restart MySQL?
> 
> On 03/16/2007 02:22 PM, Ron Croonenberg wrote:
>> Hi quick question (off topic a bit)
>>
>> MySQL seems to be not running on DST while the machine it is on is.
>> any ideas ?
>>
>> if I use a mysql_query("select now()", connection);  it looks like it is
>> an hour earlier then the system time.
>>
>> Ron
>>
>>   
> 

-- 
=
 It's is not, it isn't ain't, and it's it's, not its, if you mean
 it is. If you don't, it's its. Then too, it's hers. It isn't
 her's. It isn't our's either. It's ours, and likewise yours and
 theirs.
  -- Oxford Uni Press
=
 Ron Croonenberg   |
   | Phone: 1 765 658 4761
 Lab Instructor &  | Fax:   1 765 658 4732
 Technology Coordinator|
   |
 Department of Computer Science| e-mail: [EMAIL PROTECTED]
 DePauw University |
 275 Julian Science & Math Center  |
 602 South College Ave.|
 Greencastle, IN  46135|
=
 http://www.csc.depauw.edu/RonCroonenberg.html
=

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] dst

2007-03-17 Thread Micah Stevens 

Did you restart MySQL?

On 03/16/2007 02:22 PM, Ron Croonenberg wrote:

Hi quick question (off topic a bit)

MySQL seems to be not running on DST while the machine it is on is.
any ideas ?

if I use a mysql_query("select now()", connection);  it looks like it is
an hour earlier then the system time.

Ron

  


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Values in a date field

2007-03-17 Thread Bastien Koert 

select date_format(datefield,'%M') as theDate from table [where clause]

Bastien





From: Ron Piggott <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: PHP DB 
Subject: [PHP-DB] Values in a date field
Date: Sat, 17 Mar 2007 09:44:43 -0400


I have a $subscription_begins variable.  It the date type.  -MM-DD

How may I find out the month value (1 to 12) of this variable?

Ron



_
Don’t waste time standing in line—try shopping online. Visit Sympatico / MSN 
Shopping today! http://shopping.sympatico.msn.ca


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

答复: [PHP-DB] Values in a date field

2007-03-17 Thread Jacob 

$date=Getdate($subsciption_begins);
$month=$date[mon]
-邮件原件-
发件人: Ron Piggott [mailto:[EMAIL PROTECTED] 
发送时间: 2007年3月17日 21:45
收件人: PHP DB
主题: [PHP-DB] Values in a date field


I have a $subscription_begins variable.  It the date type.  -MM-DD

How may I find out the month value (1 to 12) of this variable?

Ron

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Values in a date field

2007-03-17 Thread Ron Piggott 

I have a $subscription_begins variable.  It the date type.  -MM-DD

How may I find out the month value (1 to 12) of this variable?

Ron