[PHP-DB] UPDATE table1 FROM table2

In MySQL 3.23, how to update one table using information from another table. update table1 set value1=t2.value2 from table1 as t inner join table2 as t1 using(pk_key) ??? or update table1 as t1 inner join table2 as t2 using(pk_key) set t1.value1=t2.value2 ??? Is it possible at all? Thank you

[PHP-DB] importing BLOBs from MSSQL

Hi, i'm trying to import tables containing TEXT fields from MSSQL 2K, so far tried different ways, one of them DTS, but unsuccessfully. It gives error: Query-based insertion or updating of BLOB values is not supported. Any help will be very much appreciated :) Moshe -- PHP Database Mailing

[PHP-DB] Re: Sessions and Frames

i don't think frames are the problem. check again if you printing anything in same frame before session_start(); Tjaybelt [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I have a site that is successfully using sessions and authentication. However, I am working

[PHP-DB] updating records in ODBC with cursor

is there a way to update records with cursor thru ODBC? thanx -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]