Re: [PHP-DB] Does PHP strip out the seconds from a SQL Server datetime field?

2005-12-06 Thread Fen Lu
Try these for a test, I haven't check it~ $mytime=strtotime($stime) date('Y-m-d H:i:s',$mytime); -- >From : Fen lu

Re: [PHP-DB] Does PHP strip out the seconds from a SQL Server datetime field?

2005-12-06 Thread Fen Lu
I think there's nothing to your 'mssql_pconnect()' ~ As far as I known, in Oracle, the 'datetime' is stored as a 13 integer, it's a Unix timestamp so you won't lose any microsecond while save the 'datetime' but I didn't found how to do with your problem~

RE: [PHP-DB] Web calendar and online Dairy

2005-12-06 Thread Bastien Koert
why do't you try a. googling for them b. one of the cms projects that are out there (i know mamboserver has that for sure since i am developing a site with mambo and am using those compenents bastien From: Vikram Kumar <[EMAIL PROTECTED]> To: php-db@lists.php.net Subject: [PHP-DB] Web calen

[PHP-DB] Web calendar and online Dairy - 2

2005-12-06 Thread Vikram Kumar
Hi, Ofcourse, I will pay for your help. thank you! Vikram!

[PHP-DB] Web calendar and online Dairy

2005-12-06 Thread Vikram Kumar
Hi! I need a web calendar and online diary application. Can some one develop those applications for me. You may use open source applications, or already developed applications in your previous projects, I need simplest calendar and online diary applications. thank you! Vikram

[PHP-DB] XML-RPC Library for PHP help needed

2005-12-06 Thread Chris Payne
HI there everyone, I have to be able to receive data sent in XML-RPC format and I'm totally new to this. Basically I have to grab the DATA from the feed that is sent to my server and extract the data to be stored in a MySQL DB with PHP, does anyone know anything about how to set up a simple cl

RE: [PHP-DB] getting rows by an ID field or by another field in a table

2005-12-06 Thread Bastien Koert
Adding an ID field allows you to quickly point back to any particular record if you manage to have duplicate data... Bastien From: "Eternity Records Webmaster" <[EMAIL PROTECTED]> To: Subject: [PHP-DB] getting rows by an ID field or by another field in a table Date: Tue, 6 Dec 2005 14:42:3

Re: [PHP-DB] getting rows by an ID field or by another field in a table

2005-12-06 Thread Joseph Crawford
i would do something like SELECT id, date, subject FROM journal LIMIT 20 ofcourse this would mean you have to add an id column to your table and i would make that a primary key and auto_increment, this way when you do the select you could do something like this $res = mysql_query("SELECT id, da

[PHP-DB] getting rows by an ID field or by another field in a table

2005-12-06 Thread Eternity Records Webmaster
I have a table with the fields: CREATE TABLE `journal` ( `Date` date NOT NULL, `subject` varchar(100) NOT NULL, `entry` longtext NOT NULL ) TYPE=MyISAM COMMENT='Journal table'; I was wondering if I should get the rows out by an ID field of some kind or maybe do a select on the subject? what

RE: [PHP-DB] problem of retrieving urls from mysql

2005-12-06 Thread Bastien Koert
$url = str_replace("www.mydomain.com","",$url) bastien From: Mohamed Yusuf <[EMAIL PROTECTED]> To: php-db@lists.php.net Subject: [PHP-DB] problem of retrieving urls from mysql Date: Tue, 6 Dec 2005 09:51:18 -0800 I would like to store and retrieve urls, but I have problem which is I get my ur

Re: [PHP-DB] Does PHP strip out the seconds from a SQL Server datetime field? SOLVED

2005-12-06 Thread Alex Gemmell
Thanks Martin, it's definitely what is coming back from the database (I use Zend Studio to debug and can watch it happening). Actually it appears there is a default setting for the mssql extension that I was unaware of. I have to set the following in my php.ini to force the extension to keep

[PHP-DB] problem of retrieving urls from mysql

2005-12-06 Thread Mohamed Yusuf
I would like to store and retrieve urls, but I have problem which is I get my url + the other url, Instead I should get another url only $temp = linkurl; echo "$temp"; the echo prints something like this http://www.mydomain.com/www.otherlink.com so I wan get rid off my url and get only other lin

RE: [PHP-DB] Does PHP strip out the seconds from a SQL Server datetime field?. .

2005-12-06 Thread Norland, Martin
How are you printing/extracting this information? I find it very unlikely that it's returning that string - it would eliminate any localization opportunities as well as time conversion / math operations. Use print_r() to print the contents returned from SQL Server directly, if you're using date

[PHP-DB] Does PHP strip out the seconds from a SQL Server datetime field?

2005-12-06 Thread Alex Gemmell
Hello! I'm using PHP 4.4.1 and pulling out records from a SQL Server database. I use the mssql extension in PHP to connect to SQL Server. My website works fine for the most part but I have noticed something odd with the dates returned from SQL Server. In my SQL Server table I have many dat