[PHP-DB] Is Temporary table right approach

[Manoj Singh]

Hi All,

I have a query which returns the large number of ids which i am using in
other queries. I am doing this in PHP. Now the first query can return
unlimited number of ids which might create problem in PHP. I want to store
this ids in MYSQL through temporary table so that i can access that ids in
other queries directly.

Do you think the approach is right or there is any other good approach?

Please suggest.

Regards,
Manoj

[PHP-DB] Which ORM tool for Windows with Microsoft SQL Server 7/2000/2005.

[Richard Quadling]

Hi.

I'm trying to find an ORM tool to allow me to talk to Microsoft SQL
servers (V7, 2000 and 2005) for Windows.

For those that use ORM, what do you use?

I've looked at Doctrine (requires php_pdo_mssql which isn't part of
the VC9 win32 builds; for the VC6 builds, it requires ntwdblib.dll
which is oh so dead).

I'm looking into Propel next. This now seems to be using PDO and
PDO_MSSQL, so it seems I've got the same problems.

Ideally, using the nice shiny Microsoft SQL Server 2005 Driver for PHP
from Microsoft (http://www.codeplex.com/SQL2K5PHP) would be nice. But
this isn't PDO.

Is there anyone capable of getting the Microsoft driver PDO aware?

Any help/suggestions would be appreciated.

Regards,

Richard Quadling.

-- 
-
Richard Quadling
Zend Certified Engineer : http://zend.com/zce.php?c=ZEND002498&r=213474731
"Standing on the shoulders of some very clever giants!"

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