[PHP-DB] Re: example of making Next 10 entries - previous ..

2001-08-29 Thread Alexandre Santos

Andrius Jakutis wrote:
 
 Hello,
 
 I need example of making simple thing: to list only 10 entries per page, and
 next 10 is shown after next page button is clicked.
 
 Thanks
Look in www.phpbuider.com for a article about previous/next buttons.

Alex

-- 
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]




[PHP-DB] Re: Troubles in ODBC Land

2001-08-27 Thread Alexandre Santos

What DB are you trying to use?
Alex

Jonathan Hilgeman wrote:
 
 I'm on a FreeBSD 4.2 box running Apache 1.3.14+OpenSSL with mod_php4
 (4.0.3). I am attempting to set up ODBC for this box, and it's giving me
 problems.
 
 First, I installed unixODBC (www.unixodbc.org), which went fairly smooth.
 Second, I installed myODBC for UNIX via the ports directory, which also
 seemed to install fine.
 Third, I modified the mod_php4 Makefile to include --with-unixODBC and
 compiled it. Everything seemed to go through fine, and Apache restarted at
 the end.
 
 When I went to test the function, I got a Page Cannot be Displayed error
 (IE 5.5). If I try removing the line that uses odbc_connect(...), it will
 print out the request variables. Only when odbc_connect is present in the
 code, will it break.
 
 $conn_id=odbc_connect();
 
 I have tried this with a DSN name and a username and password, but it does
 not work. Any ideas, anyone?
 
 - Jonathan

-- 
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]




[PHP-DB] Re: help me with DBA

2001-08-26 Thread Alexandre Santos

Donald Fei wrote:
 
 When i execute the following codes:
?php
 $db=dba_open(database.db,c,db2);
 ?
 an error occurs:
 Warning: no such handler: db2 in D:\Inetpub\WebSite/dba_test.php on line 2
Have you compiled PHP with support for that? I don't think so...

Alex

-- 
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]




Re: [PHP-DB] Access tables to PostgreSQL

2001-08-24 Thread Alexandre Santos

Grant wrote:
 
 On Wed, 22 Aug 2001, Tim O'Brien wrote:
 
  What is the best method to move data from access tables to postgreSQL?
 
  Are there are php functions that are available?
 
 Unfortunately, only Access reads Access very well, but you can use ODBC
 and linked tables in Access to copy it to PostgreSQL.
I copied tables from Access to Postgres using this method:
1. Install the ODBC Driver in your Windows Box.
2. Export the tables to Postgres.
If the second pass doesn't work, create the tables in POstgres and then
link them in Access and build a append query that copies all the
information from the acess tables to the postgres tables.

Alex

-- 
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]




[PHP-DB] Re: Extensions on SuSE

2001-08-24 Thread Alexandre Santos

Ridai Govinda Pombo wrote:
 
 Does anyone know how to get the _binary_ extensions for PHP installed with
 SuSE 7.2 ?
 
 I think it needs to recompile... But I wanted a easier way to solve it...
 
 Thanks,
 
 Ridai Govinda

Do you mean doing in Linux the same as in Windows? Only doing some
comment in php.ini and another extension installed?
I installed the SAPDB extension recompiling the source code...

Alex

-- 
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]




[PHP-DB] SAPDB

2001-08-24 Thread Alexandre Santos

Hi all,
I've been using SAPDB and PHP, but it doesn't have functions of it own.
It uses the Unified ODBC.
Is it something bad? MySql, Postgres, Oracle and others have functions
for that particular DB. Will it be slower?

Alex

-- 
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]




[PHP-DB] Re: phpMyAdmin (well mySQL) and listing DB's

2001-08-19 Thread Alexandre Santos

Tom Carter wrote:
 
 Hi All,
 
 I was trying to set up phpMyAdmin for a client on my machine, and I've
 created a mysql account for him such that he can only use his database, yet
 when I use phpMyAdmin (with the correct setting) he can see all the
 databases. The security is still there, it just looks messy + reveals all
 the dbs.
 
 Anyone have any advice?
 
 TIA, Tom
 Tom Carter
 Web Architect
 roundcorners ltd.
See how it works in phpPgAdmin. The loop that creates the left menu as
an if clause that only lists the DB's the user owns.

Alexandre Santos

-- 
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]




[PHP-DB] PostgreSQL or SAPDB

2001-08-17 Thread Alexandre Santos

I'm starting a project and I have this doubt: Postgres or SAPDB? I have
some experience in Oracle, but I need a free DB.
Any idea?
Alex

-- 
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]