Hi,
get the latest PHP4 and set set php.ini-param mssql.datetimeconvert to Off
the the MSSQL-Module then returns datetime-values in this format:
-MM-DD HH24:MI:SS
bye,
Benjamin Walling wrote:
> I can't seem to find a way to format the field that comes back from my
> DateTime fields in MS
I love how this keeps getting answeredwere is just spelled wrong. it's
so funny that we all miss that though. i did a couple days ago and
responded with my own solution that didn't matter, b/c i still didn't spell
where correctly.
:)
Hi,
I am used to ID fields being numeric. If this is the case in your table,
remove the single quotes from the id value '1' because that will cause
error also.
So:
> SELECT * FROM personen WERE Id != '1' ORDER BY Bijnaam
should be:
SELECT * FROM personen WERE Id != 1 ORDER BY Bijnaam
*IF*
This is how I do it:
date("m/d/Y",strtotime(odbc_result($rs,"ts")))
where $rs is the result set and "ts" is the name of the field containing the datetime.
<>< Ryan
-Original Message-
From: Benjamin Walling [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 14, 2002 2:59 PM
To: [EMAIL PROTEC
I can't seem to find a way to format the field that comes back from my
DateTime fields in MSSQL Server. For example, '2002-05-13' shows in Query
Analyzer as 2002-05-13 00:00:00.000. If I echo it from PHP, I get May 13
2002 12:00AM. date() won't take it. strftime() won't take it. What do I
nee
hi,
i have experienced the same problem with IIS, however upgrading (and it
definitly IS an upgrade) to apache is not possible since i have production
servers running IIS and no person to run apache that can do it in a
production environment - my solution is to use CGI instead of ISAPI - it's
not
SELECT LPAD(column_name, '6', '0') FROM table_name;
Gurhan
-Original Message-
From: Morten Nielsen [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 14, 2002 4:24 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Zeropadding
Hi,
I use MySQL where I have a table. One of the fields is an INT(6), w
Hi,
I use MySQL where I have a table. One of the fields is an INT(6), which I
zeropad. When I try to get the number to a variable it doesn't contain all
the numbers. If I give it a value of 59 I extract 59 and not 59. Is
there a way I can get the hole number?
Regards,
Morten
--
PHP Databa
Apologies for the repeat to those who are in php-general and php-windows.
i'm running PHP4.1.1 as a module through Apache 1.3.22 on W2k Server SP2 --
connecting to a MSSQL server running on the same OS.
I'm having 2 problems with the system.
1. on mssql_query(*SELECT statments*); that return MS
I use PHP 4 with mssql server 7.
When I run the profiler, I see lots of "select @@microsoftversion", called
by PHP.
I didn't find a clear documentation of this variable (SQL Books Online
never cites it).
What is?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http:/
mysql_db_query lets you pick the database,
if you use mysql_query then you need to use mysql_select_db("dbname",connection)
before hand.
http://www.php.net/manual/en/function.mysql-db-query.php - you pick the database for
this
http://www.php.net/manual/en/function.mysql-query.php - uses the
Hi,
I use MySQL and are trying to have 2 open databases. I do like this:
$db1=db_connect($CFG->dbhost, "DB1", $CFG->dbuser, $CFG->dbpass);
$db2=db_connect($CFG->dbhost, "DB2", $CFG->dbuser, $CFG->dbpass);
Then I am trying to run a CREATE TABLE,
$qid = db_query("
CREATE TABLE tmp (
Dato INT(2) )
Hi,
First, thanks and excuseme for my english but I speak and write spanish.
The questions-help:
1. Can I connect to Progress whith php?
galara
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Here is what I use to select the first sentence from my text fields.
$result = mysql_query("SELECT news_id, headline, substring_index(body,
\".\" ,1) AS body FROM news",$db);
Mike
::: Larry French ::: wrote:
> Hello all. I have a MySQL field called 'description' that contains a
> paragraph o
14 matches
Mail list logo
