[PHP-DB] how connect a remote data base MSAccess with PHP in Linux system

2002-04-10 Thread Silvia Mahiques
Hi friend! I have a question... I have a remote database in Microsoft Access on a WinNT System, and a Apache and PHP on Linux System. How can I connect this? There is one function in PHP for make this: odbc_connect(DSN,user,password) The question is: what is DSN in my case? How I can to

RE: [PHP-DB] how connect a remote data base MSAccess with PHP in

2002-04-10 Thread Ruprecht Helms
Hi Silvia Mahiques, I have a question... I have a remote database in Microsoft Access on a WinNT System, and a Apache and PHP on Linux System. How can I connect this? There is one function in PHP for make this: odbc_connect(DSN,user,password) DSN (Data Source Name) in local host is

[PHP-DB] RE: Mysql and memory issue

2002-04-10 Thread Trond Erling Hundal
Thanks Yasuo Ohgaki and Gurhan Ozen. My system has 256mb of DDR ram, it's a Intel PIII 900Mhz processor. Ps -aux | grep mysql shows that about all of the mysql connections uses about 15mb of memory. Is that too much? My query fetches 15 records from two tables. Here is the query: SELECT

[PHP-DB] Copy data from one table to another. How to? Subselects not supported as far as I know.

2002-04-10 Thread andy
Hi there, I have a table containing data already. Now there is another table with data I would like to add to the other one. As far as I know mysql does not support subselects. So how could I add this data to the old table? Thanx, Andy -- PHP Database Mailing List (http://www.php.net/) To

[PHP-DB] Grrr quotes

2002-04-10 Thread Marij Bellen
Hello, i have a little problem with quotes: - first a have a textarea in a form - second i'm gonna check this textarea - if all checks sussesfull I process the data, so no straings thing get in my database or whatever (function see below) Problem: if I get the data out of the database I

Re: [PHP-DB] help! i don't know anything!

2002-04-10 Thread Jason Wong
On Wednesday 10 April 2002 21:35, Christopher L. White wrote: well, next to nothing. i'm a scripting programmer, but i'm quite unfamiliar with the PHP syntax. trying to find some good examples of displaying field values from tables in a database, in such a way to display a page. in other

[PHP-DB] Re: htaccess quick ?

2002-04-10 Thread Michael Andersson
Dont know how to do it, but you could always try some apache newsgroup http://groups.google.com/groups?hl=svgroup=alt.apache.configuration Dave Carrera [EMAIL PROTECTED] skrev i meddelandet 001301c1ded0$498373c0$d95527d9@phpdevdc001">news:001301c1ded0$498373c0$d95527d9@phpdevdc001... Hi All

Re: [PHP-DB] Not displaying all records

2002-04-10 Thread Marius Ursache
$row returns an array, and you display only the first element Jennifer Downey a écrit : Hi all, I had to re-write this so it would at least show something on the page. $query = SELECT id, name, image, quantity FROM {$config[prefix]}_my_items WHERE uid={$session[uid]} ORDER BY id;