[Phpgroupware-developers] connect to and query other databases

[Pim Snel]

Hello all,

Can somebody tell me how I can use functions from the phpgwapi to connect to 
another database
and do queries on it? At the moment I use direct mysql_query and connect 
functions. I know
this is a bad thing to do.

Maybe you can give me a phpgw equal to the following:

   $conn=mysql_pconnect($localhost,$user,$database);
   mysql_select_db($database, $conn);

   $SQL='SELECT * FROM '. $table . ' WHERE';
   $result=mysql_query($SQL,$connection);

I'm working on a multiuser/multisite contentmanagement system in phpGW which 
works with a
single database per site. It's kind of a phpMyAdmin with specified 
contentmanagement tasks
an capabilities like uploading images and containing relations between tables.

I'll give you all a preview when it's more stable.

Thanks

Pim Snel



-- 
Lingewoud B.V.            Tel. +31 418 663963
Maasdijk 4                Fax. +31 418 663053
5328 BG Rossum Gld        address@hidden
The Netherlands           http://www.lingewoud.nl