[PHP-DB] odbc_connect() parameters help please

2004-12-15 Thread Greg Jackson
Hi I'm new to this group, but not to PHP :-) Does anybody know why odbc_connect() requires a username and password to be supplied as well as the DSN name? This feature is preventing me from accessing a database that can easily be accessed from asp with the following example code: <% set conn=S

Re: [PHP-DB] date conversions

2004-12-15 Thread neil
Thank you for all your help. Among all the variations I found this to be the clearest: list($d,$m,$y) = explode("/",$testdate); $mysqldate = date("Y-m-d", mktime(0,0,0,$m,$d,$y)); But I also thought the use of split instead of explode so you could nominate multiple delimiters was good. eg. list

Re: [PHP-DB] date conversions

2004-12-15 Thread Jason Wong
On Thursday 16 December 2004 14:00, neil wrote: > I am needing to convert a d/m/y date such as 30/11/2004 into the format > that mysql can use ie. 2004-11-20 > > If I try the following: > > $testdate="30/11/2004"; > echo date("Y-m-d", strtotime($testdate)); > > the result is - 2006-06-11 > > I can

Re: [PHP-DB] date conversions

2004-12-15 Thread tg-php
Yeah, this is my problem with relyinig on strtotime(). If you don't give it a format that it knows, it's going to give you random results (well, not random, but "undesireable"). Seems like more of a crutch that leaves too much chance of error for my taste. I prefer to be a little more explici

[PHP-DB] date conversions

2004-12-15 Thread neil
Hi I am needing to convert a d/m/y date such as 30/11/2004 into the format that mysql can use ie. 2004-11-20 If I try the following: $testdate="30/11/2004"; echo date("Y-m-d", strtotime($testdate)); the result is - 2006-06-11 I can't find any other function apart from strtotime to do this. An

RE: [PHP-DB] MYSQL Maximum Time Exceeded

2004-12-15 Thread Bastien Koert
no, mysql will work fine with iis, use it at work and use it at home that way, though have recently switched to apache what web server are you running? try $conexion = mysql_connect( "localhost", "root", "" ) or die ("can't connect".mysql_error); to give more info about the connection From

RE: [PHP-DB] MYSQL Maximum Time Exceeded

2004-12-15 Thread Jason Walker
This not be what you need, but I think there are some squiggle brackets missing. $conexion = mysql_connect("servername","username","password"); Again, I don't think this is the root of the problem but it's the first thing that popped out to me without knowing much more about your system. Hav

[PHP-DB] Re: Databases, PHP and SOAP

2004-12-15 Thread Joel Haasnoot
Hi, I am planning / developing a php-based real-time meeting package and was wondering the following: Which is more efficient: using a SOAP message to send data from a database to the client or connecting directly to the database through the client PHP page? Thanks, Joel -- PHP Database Mailing

[PHP-DB] MYSQL Maximum Time Exceeded

2004-12-15 Thread PHPDiscuss - PHP Newsgroups and mailing lists
Hi. I am running MySQL 4.0 and PHP 4.3.9 (MySQL Client Version 3.9.23) in Windows XP. I get this error when I try to connect to mysql: Fatal error: Maximum execution time of 60 seconds exceeded in c:\inetpub\wwwroot\index.php on line 4 My PHP script is: I also tried installing newer PHP

Re: [PHP-DB] Dates prior to Dec 31, 1969

2004-12-15 Thread Frank Marousek
Ramil and Jochem, Having mySQL format the date is the best solution... thanks! Frank -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] test ... ignore me

2004-12-15 Thread Tatang Widyanto
test :) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Printing with print functions under windows

2004-12-15 Thread antonio bernabei
Hi, I need to use the printer functions. I have some problems to have the output formatted as I want as to right justify numbers of variable size the starting position varies with the type of character chosen.Could anyone help me? Best regards Antonio Benrabei -- PHP Database Mailing List (http:/

[PHP-DB] Dynamic where problem

2004-12-15 Thread Stuart Felenstein
I'm running a dynamic query and noticed I was not getting the results expected. Explanation: Here I make the declaration for the query array: $aWHERE = array(); Then test what variables came back from input: if(!empty($aWHERE)) { $query_rsCS .= ' WHERE '.implode(' AND ',$aWHERE); Here is the