Hiya.
I'm writing an application which needs to make SQL queries, and I'd like
to give it support for multiple database servers, starting with MySQL
and PostgreSQL. I see that other folks have done this with a variety of
methods, and I can't see a clear winner.
Option 1 - Drop in a set of db-rel
On Sun, 2005-01-30 at 14:42 -0500, Paul Chvostek wrote:
> I'm writing an application which needs to make SQL queries, and I'd like
> to give it support for multiple database servers, starting with MySQL
> and PostgreSQL.
Take a look here http://www.php.net/dbx and here
http://pear.php.
also look a this class...adodb.php
a good article on it is here
http://www.databasejournal.com/features/php/article.php/10898_651_1
bastien
From: Josip Dzolonga <[EMAIL PROTECTED]>
To: php-db@lists.php.net
Subject: Re: [PHP-DB] supporting multiple databases...
Date: Sun, 30 Jan 2005 20:49:48 +0
Anyone that can help me with this one? I want this SQL-statement to
retrive only distinct values from the original table column named (not
the AS stuff)
(
SELECT * , namn_2 AS sec_namn, namn_1 AS one
FROM sortiment
WHERE namn_1 LIKE 'H%'
)
UNION (
SELECT * , UPPER( namn_2 ) AS sec_namn, namn_2 A
use DISTINCT?
On Sunday 30 January 2005 12:51 pm, Bobo Wieland wrote:
> Anyone that can help me with this one? I want this SQL-statement to
> retrive only distinct values from the original table column named (not
> the AS stuff)
>
> (
> SELECT * , namn_2 AS sec_namn, namn_1 AS one
> FROM sortimen
thanks
I tried strtotime also but getting 1970-01-01 not 2005-01-28. my
problem is that the date is given to me in string format i.e.Fri Jan 28
19:53:09 2005. Any other help will be appreciated.
with best wishes
balwant
On Sat, 2005-01-29 at 22:45, Bastien Koert wrote:
> try
>
> $date = date
what about something like this?
$strdate = "Fri Jan 28 19:53:09 2005"; // place your date string here
$newstr = substr_replace($strdate, '', 11, -5); // removes the time from
your date string, bringing it inline with format required by strtotime()
$tmstmp = strtotime($newstr);
$date = date("Y-m