Re: [PHP-DB] configure PHP4 with sybase-ct

2001-05-02 Thread Selvin Sakal

I am on a lan and i would like to know how to use PHP's get_meta_tags 
function though my proxy.

Can someone write me some sample code.

Thanks
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.


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

2001-05-02 Thread CC Zona

In article [EMAIL PROTECTED],
 [EMAIL PROTECTED] (Benny K. Putera) wrote:

 I have 2 systems, local and internet.
 I want my Internet database is updated from local database.
 How can I make this through php script?

See the manual for your DBMS for info on terms like replication, 
backup, mirroring, etc.

-- 
CC

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

2001-05-02 Thread Jennifer Arcino Demeterio

hello all,

did anyone know on how to import data from one database to another using Mysql?

Thanks



Re: [PHP-DB] ora 12154 tns problems

2001-05-02 Thread jarry

Try to make listener.ora file by net8assistant

jarry 

Laurent GARCIA wrote:
 
 ** Top Secret **
 ** High Priority **
 
 i have windows2000 server, iis5.0, oracle client 8.0.5 and php 4.0.3pl1
  i have oci8 and oracle installed
  i can access to oracle by sqlplus and sqlnet
 
  tnsnames.ora is ok
  sqlnet.ora is ok
  when i do phpinfo() , coi8, oracle installed
 
  but i have this error
  Warning: _oci_open_server: ORA-12154: TNS:l'adresse symbolique 
n'a pas
  pu être résolue in includes/php-dbi.inc on line 50
  Error connecting to database:
 
   Unknown error
 
  thanx for your help because i don't know why i may do now?
 
 salutations distinguees
 laurent Garcia
 
 --
 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 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] configure PHP4 with sybase-ct

2001-05-02 Thread Stig Sæther Bakken

[Lester June Cabrera [EMAIL PROTECTED]]
 Hi,
 
 When I run  configure in my Solaris box
   ./configure --with-nsapi=path of iPlanet
   --enable-libgcc
   --with-mysql=path of my MySQL
   --enable-track-vars
   --enable-short-tags
   --enable-asp-tags
   --with-sybase-ct=path of freetds
 
 ... I got the following error:
 
 checking whether the C++ compiler (c++   -R/usr/ucblib -L/usr/ucblib
 -R/usr/local/lib/gcc-lib/sparc-sun-solaris2.7/2.95.2
 -L/usr/local/lib/gcc-lib/sparc-sun-solaris2.7/2.95.2
 -R/usr/local/mysql/lib -L/usr/local/mysql/lib -R/usr/local/freetds/lib
 -L/usr/local/freetds/lib) works... no
 
 configure: error: installation or configuration problem: C++ compiler
 cannot create executables.
 
 
 We have here GNUgcc 2.8.1 installed. Should I install other compiler?

Take a look at the config.log file to see the error message from the
compiler or wherever.  It may be a simple fix.

 - Stig

-- 
  Stig Sæther Bakken [EMAIL PROTECTED]
  Fast Search  Transfer ASA, Trondheim, Norway

-- 
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] PostgreSQL7.1: It's worth to upgrade.

2001-05-02 Thread Anuradha Ratnaweera


You have forgotton to mention new SQL features such as outer joins.
Postgres have been supporting many advanced sql features for a long time
those were not supported by other databases.

Anuradha

On Tue, 24 Apr 2001, Yasuo Ohgaki wrote:

 Hello PostgreSQL users,
 
 I'm testing PostgreSQL 7.1 and PHP4.0.4pl1 on Linux.   It's really worth to
 upgrade.
 
 Besides PostgreSQL 7.1 supports any size of text, WAL, many bug fixes, better
 pg_dump/restore, etc. PostgreSQL 7.1 can provide more backends on the same box.
 A box, which could set to max 70 or less backends, can set upto 3000+ backends.
 The box would not be able to handle 3000 db connections, but it is really nice
 to have more db connections for web applications. 7.1 also seems much faster
 than 7.0.3. Text type with large data can consume a lot of CPU time. BLOB is
 suitable to store really large data.
 
 If you are using Windows, you are better to stay with 7.0. You will see error
 message with pg_errormessage() even if there is no errors. Wait or compile
 php_pgsql.dll with 7.1 libpq. (I don't have environment to compile it. If anyone
 has php_pgsql.dll with 7.1 libpq for PHP4.0.4pl1, could you tell where to get or
 send it to me?)
 
 --
 Yasuo Ohgaki
 
 
 
 
 -- 
 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 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] How to randomly select data in a field. Please help newbie.

2001-05-02 Thread Johannes Janson

Well the only way to do this properly is a cron job.
have a look at
http://forums.devshed.com/showthread.php?threadid=13642forumid=5

hope it helps

MAX [EMAIL PROTECTED] schrieb im Newsbeitrag
002301c0d2c0$b49b3c00$0300a8c0@cv2">news:002301c0d2c0$b49b3c00$0300a8c0@cv2...
 Hi,
 I'm newbie from Indonesia.
 Your query has helped me to create random text using PHP and MySQL.
 Could you please give me an example script for random text, the text
changes
 in every 24 hours/every 7 o'clock in the morning not after
refresh/reload.

 Thanks for your help.

 Max
 Indonesia



 - Original Message -
 From: Johannes Janson [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Monday, April 30, 2001 6:56 PM
 Subject: Re: [PHP-DB] How to randomly select data in a field. Please help
 newbie.


  Hi,
 
  you could do the random selection in MysSQL if you use it
  using a query like this.
  SELECT  FieldWithURL FROM YourTable ORDER BY RAND() LIMIT 0,1;
  This will give you a random field. If you want more fields you have to
  set different values for the limit. Like LIMIT 0,5 for the first 5 row.
  Just if you don't know the syntax of LIMIT: limit 'StartingPoint',
  'NumberOfRows'
 
  hope it helps
  Johannes
 
  Greg K [EMAIL PROTECTED] schrieb im Newsbeitrag
  9cfe9n$ggd$[EMAIL PROTECTED]">news:9cfe9n$ggd$[EMAIL PROTECTED]...
   Can someone explain to me the best way to randomly select data from
 field
   that consist of urls. The fields consist  urls that  are images of
 people.
  I
   believe I have to setup that field as a array and turn it into a
 interger.
   But I have no experience doing this can someone sort of give me a
 example
  on
   how I would do this .
  
   Thank you ..
  
   Your Help would be well appreciate it ..
  
  
  
  
  
   --
   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 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 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 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] mysql-php

2001-05-02 Thread Mikail

hi,
I'm a newbie from Italy
I use php with mysql and I need to find a way to visualize the difference
between two dates.
For ex in a row I have column [A] and column [B]
[A] 2001-05-02 10:00:00
[B] 2001-05-02 10:01:30
If I use
SELECT TIME_FORMAT([B]-[A], '%H:%i:%s') result is 00:01:30
But it's the same if I use SELECT TIME_FORMAT([A]-[B], '%H:%i:%s')
why? I need a - (minus)!
Thanks


-- 
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] creating a downloadable file ...

2001-05-02 Thread Steve Brett

hi,

i have a table that is populated from a database. the only problem with it
is that the table is quite large.

i'd like to give the user to the option to download the file in csv format
... can anybody point me in the right direction ?

Steve Brett 
Internal Development
tel: 4251 
EMIS Ltd. 
Privileged and /or Confidential information may be contained in this
message. If you are not the original addressee indicated in this message (or
responsible for delivery of the message to such person), you may not copy or
deliver this message to anyone. In such case, please delete this message,
and notify us immediately. Opinions, conclusions and other information
expressed in this message are not given or endorsed by my firm or employer
unless otherwise indicated by an authorised representative independently of
this message.
Egton Medical Information Systems Limited. Registered in England. No
2117205. 
Registered Office: Park House Mews, 77 Back Lane, Off Broadway, Horsforth,
Leeds, LS18 4RF



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

2001-05-02 Thread Angie Tollerson

Dave,
What you need to do is make sure that the variable: $topidID is being set to a value 
first (before you register it you must get it from the table.  Once it is set you need 
to register it as you did BUT WITHOUT the $. So it will say:

?
session_start();
session_register(topidID);
?

Make sure that session_start is ALWAYS before any headers in your html page, BUT 
register does NOT have to be.  It can be declared anywhere in the page as long as you 
have set the value in it already.  Also, on every page that will ever access topidID 
you must have session_start() at the top.  But not session_register, as the value has 
already been registered. HINT: if you want to change the value of topidID just set 
it's value and then call a register right after you do that. 

Hope this helps!


 DC [EMAIL PROTECTED] 05/02/01 07:53AM 
Hi All
I have a ? about setting a session.

I have a functions.inc file and at the top have put my session statment that
looks like this.

?
session_start();
session_register($topidID);
?

$topicID comes from my mysql db.

What i am trying to do is set the $topicID of my message board so that when
a sucessful post has been made the visitor can click on a link that show the
right board by topicID.

so the link will look like this...

http://localhost/forums/view.php?topicID=3 

I am banging away trying to make this work

Any help in the meantime is as always appreciated

Thank You In Advance

dave C



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

2001-05-02 Thread DC

Thanks Steve;
I now have this in a session file in my tmp dir

topicID|s:1:8;

Now how do i get the link to read http://localhost/forums/view.php?topicID=8

i think its along the lines of
http://localhost/forums/view.php3?PHPSESSIONID?topicID

I am banging away, the 4 books i have on Php are useless when it comes to
session and there usage.

Thanks for the help

Dave C

Steve Brett [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
 try
 session_register(topidID);

 without the $

 Steve


  -Original Message-
  From: DC [mailto:[EMAIL PROTECTED]]
  Sent: 02 May 2001 13:54
  To: [EMAIL PROTECTED]
  Subject: [PHP-DB] Sessions ???
 
 
  Hi All
  I have a ? about setting a session.
 
  I have a functions.inc file and at the top have put my
  session statment that
  looks like this.
 
  ?
  session_start();
  session_register($topidID);
  ?
 
  $topicID comes from my mysql db.
 
  What i am trying to do is set the $topicID of my message
  board so that when
  a sucessful post has been made the visitor can click on a
  link that show the
  right board by topicID.
 
  so the link will look like this...
 
  http://localhost/forums/view.php?topicID=3
 
  I am banging away trying to make this work
 
  Any help in the meantime is as always appreciated
 
  Thank You In Advance
 
  dave C
 
 
 
  --
  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 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 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] Sessions ???

2001-05-02 Thread John Edward Molano








  Hola.
  
  Quiero saber que debo hacer para poder conectar a Informix a través 
  de php4. De antemano, gracias por la ayuda.
  
  John Molano
  
  ---Original Message---
  
  
  From: Angie Tollerson
  Date: Wednesday, May 
  02, 2001 08:26:28
  To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
  Subject: Re: [PHP-DB] 
  Sessions ???
  Dave,What you need to do is make sure that the 
  variable: $topidID is being set to a value first (before you register it 
  you must get it from the table. Once it is set you need to register it as 
  you did BUT WITHOUT the $. So it will 
  say:?session_start();session_register("topidID");?Make 
  sure that session_start is ALWAYS before any headers in your html page, 
  BUT register does NOT have to be. It can be declared anywhere in the page 
  as long as you have set the value in it already. Also, on every page that 
  will ever access topidID you must have session_start() at the top. But not 
  session_register, as the value has already been registered. HINT: if you 
  want to change the value of topidID just set it's value and then call a 
  register right after you do that. Hope this 
  helps! "DC" 
  [EMAIL PROTECTED] 05/02/01 07:53AM 
  Hi AllI have a ? about setting a session.I 
  have a functions.inc file and at the top have put my session statment 
  thatlooks like 
  this.?session_start();session_register("$topidID");?$topicID 
  comes from my mysql db.What i am trying to do is set the $topicID 
  of my message board so that whena sucessful post has been made the 
  visitor can click on a link that show theright board by 
  topicID.so the link will look like 
  this...http://localhost/forums/view.php?topicID=3 I am 
  banging away trying to make this workAny help in the meantime 
  is as always appreciatedThank You In Advancedave 
  C-- 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 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]







_IncrediMail - Email has finally 
evolved - Click 
Here

Re: [PHP-DB] Sessions ???

2001-05-02 Thread Joe Brown

Doh!
I meant there is NO dire need
Joe Brown [EMAIL PROTECTED] wrote in message
9cp3kv$3hj$[EMAIL PROTECTED]">news:9cp3kv$3hj$[EMAIL PROTECTED]...
 For this operation there is dire need for session management.

 And remember the default variable order EGPCS may cause you trouble if
 you're sending a put variable across with the same name as a session
 variable.  Session vars take presidence in the global scope.

 http://localhost/forums/view.php?topicID=3

 The session var $topicID will override this put variable.

 $topicID=session var value //your 3 may not be here.
 $HTTP_GET_VARS[topicID]=3 //you can still find your 3 here.

 Session variables are good for maintaining information from one page to
the
 next, avoiding the need for the client to keep sending the same
information
 over and over again.

 In either event, I recommend useing a different session variable name than
 the put variable's name, unless you use $HTTP_GET_VARS/$HTTP_SESSION_VARS
 accordingly.

 -Joe

 DC [EMAIL PROTECTED] wrote in message
 9covu3$p6g$[EMAIL PROTECTED]">news:9covu3$p6g$[EMAIL PROTECTED]...
  Hi All
  I have a ? about setting a session.
 
  I have a functions.inc file and at the top have put my session statment
 that
  looks like this.
 
  ?
  session_start();
  session_register($topidID);
  ?
 
  $topicID comes from my mysql db.
 
  What i am trying to do is set the $topicID of my message board so that
 when
  a sucessful post has been made the visitor can click on a link that show
 the
  right board by topicID.
 
  so the link will look like this...
 
  http://localhost/forums/view.php?topicID=3
 
  I am banging away trying to make this work
 
  Any help in the meantime is as always appreciated
 
  Thank You In Advance
 
  dave C
 
 
 
  --
  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 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 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] odbc_tableprivileges help required

2001-05-02 Thread Mark Newnham

Could someone supply simple examples of how this command works. I am trying
to use it like this -

$conn=odbc_connect(poinv,,);
$result=odbc_tableprivileges($conn,pt_mstr,%,%);
odbc_result_all($result); 

but this returns 

Warning: SQL error: , SQL state 0 in SQLTablePrivileges in
/opt/apache/lib/htdocs/poinv/test.php on line 9
Warning: Supplied argument is not a valid ODBC result resource in
/opt/apache/lib/htdocs/poinv/test.php on line 11

So my understanding of this is obviously incorrect

Thanks

Mark

#
Mark Newnham
Application Design Associates, Inc
6021 S.Syracuse Way #302
Englewood, CO 80111, USA

http://www.adacorp.com
#

-- 
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] pgsql 7.1 build

2001-05-02 Thread Ron Patterson

Hi there,

I'm building the new PHP-4.0.5 with support for PostgreSQL 7.1 database and
get the following build error:

gmake[3]: Entering directory `/net/clear1/home/rpatters/php-4.0.5/ext/pgsql'
/bin/sh /net/clear1/home/rpatters/php-4.0.5/libtool --silent --mode=compile
gcc
 -I. -I/net/clear1/home/rpatters/php-4.0.5/ext/pgsql
-I/net/clear1/home/rpatters/php-4.0.5/main
-I/net/clear1/home/rpatters/php-4.0.5 -I/net/clear1/home/rpatters/as3/include
-I/net/clear1/home/rpatters/php-4.0.5/Zend
-I/net/clear1/home/rpatters/php-4.0.5/ext/xml/expat/xmltok
-I/net/clear1/home/rpatters/php-4.0.5/ext/xml/expat/xmlparse
-I/net/clear1/home/rpatters/php-4.0.5/TSRM
-I/net/clear1/home/rpatters/pgsql/include -D_POSIX_PTHREAD_SEMANTICS
-D_POSIX_PTHREAD_SEMANTICS -D_REENTRANT -DSUPPORT_UTF8 -DXML_BYTE_ORDER=21
-I../TSRM -g -O2  -c pgsql.c
pgsql.c: In function `_notice_handler':
pgsql.c:158: warning: passing arg 1 of `php_log_err' discards `const' from
pointer target type
pgsql.c: In function `_rollback_transactions':
pgsql.c:167: `pgsql_globals' undeclared (first use this function)
pgsql.c:167: (Each undeclared identifier is reported only once
pgsql.c:167: for each function it appears in.)
gmake[3]: *** [pgsql.lo] Error 1
gmake[3]: Leaving directory `/net/clear1/home/rpatters/php-4.0.5/ext/pgsql'
gmake[2]: *** [all-recursive] Error 1
gmake[2]: Leaving directory `/net/clear1/home/rpatters/php-4.0.5/ext/pgsql'
gmake[1]: *** [all-recursive] Error 1
gmake[1]: Leaving directory `/net/clear1/home/rpatters/php-4.0.5/ext'
gmake: *** [all-recursive] Error 1

Worked ok with PostgreSQL 7.0.3

Any ideas?

Thanks,
Ron Patterson
USA.NET


Get free email and a permanent address at http://www.netaddress.com/?N=1

--
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] pear db and pgsql

2001-05-02 Thread rob caSSon

i'm having a hell of a time figuring out how to connect to a postgresql
database using the pear db abstraction...here's some code snippets:

with mysql (works fine):

require_once('DB.php');
$db = DB::connect(mysql://username:password@localhost/audio);
if (DB::isError($db)) {
print $db-getMessage();
}
$select_query = SELECT * FROM items;
$result = $db-query($select_query);
while ($row = $result-fetchRow()) {
print $row[1]BR;
}
$db-disconnect();


with pgsql (dies with this error: 
DB Error: unknown error
Fatal error: Call to undefined function: query() in /path/pg_test.php 
on line 8)

require_once('DB.php');
$db = DB::connect(pgsql://username:password@localhost/audio);
if (DB::isError($db)) {
print $db-getMessage();
}
$select_query = SELECT * FROM items;
$result = $db-query($select_query);
while ($row = $result-fetchRow()) {
print $row[1]BR;
}
$db-disconnect();

both databases exist, along with the tables$10 says i'm being dumb, and need to 
put the port # someplace on the postgres connect, but i can't seem to put it in the 
right place.

tia,
r


-- 
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: [PHP] MySQL fulltext indices and phrase search

2001-05-02 Thread Steve Werby

Jens Kisters [EMAIL PROTECTED] wrote:
 Hi there, is there a possibility to use MySQL's MATCH ... AGAINST to
 look for a string like foo bar ?
 
 if i MATCH keyname AGAINST ('foo bar') i get resuts that match foo or
 bar, but not both of them separated by a space.
 
 My guess is that the organization of the index doesn't allow this kind
 of search as it's based on single words , but maybe one of you has a
 better idea than
 to select the rows that contain both and hit those with LIKE '%foo bar%'

Perhaps you should ask on the mysql list.
List-Subscribe: mailto:[EMAIL PROTECTED]

-- 
Steve Werby
President, Befriend Internet Services LLC
http://www.befriend.com/


-- 
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] MySQL fulltext indices and phrase search

2001-05-02 Thread Jens Kisters

Hi there, is there a possibility to use MySQL's MATCH ... AGAINST to
look for a string like foo bar ?

if i MATCH keyname AGAINST ('foo bar') i get resuts that match foo or
bar, but not both of them separated by a space.

My guess is that the organization of the index doesn't allow this kind
of search as it's based on single words , but maybe one of you has a
better idea than
to select the rows that contain both and hit those with LIKE '%foo bar%'

--
Grüße aus dem schönen Kleve
Jens Kisters

rosomm et partner
Agentur für neue Medien GmbH
Dienstleistungszentrum am
Weißen Tor - Eingang B
Gocher Landstrasse 2
47551 Kleve / Bedburg-Hau

Telefon: 02821 - 97856-20
Telefax: 02821 - 97856-77
[EMAIL PROTECTED]
http://www.rosomm-partner.de



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

2001-05-02 Thread Mike Baerwolf

Hi,

I'm working on a event calendar and some events span more than one day. I would like 
to store a date range like 2001-02-05 thru 2001-07-05 so when I do a query for the 
current day the event would appear for all the days in the range.  I hoping someone 
can point me to some documentation or tutorials on this.

Thanks in advance,
Mike



[PHP-DB] updating database on internet server

2001-05-02 Thread Benny

I have 2 systems, local and internet.
I want my Internet database is updated from local database.
How can I make this?

Regards;

Benny.


-- 
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] open foxpro database

2001-05-02 Thread Benny

I used function dbase_xxx to access foxpro database (.dbf) but it's not
work.
Here is my code :
  ?
  if (dbase_open(/home/benny/test/employee.dbf,0)) {
for ($i=1; $i=dbase_numrecords($open); $i++) {
  $rec = dbase_get_record($db, $i);
  $nf  = dbase_numfields($db);
  for ($j=0; $j  $nf; $j++) {
print $rec[$j].br\n;
  }
}
  }
  ?
Everytime I call this page there's a message :
Warning: unable to open database /home/benny/test/employee.dbf in
/home/benny/htdocs/foxpro.php on line 2
I used php 4.0.4 and Visual Fox Pro 5.0.
Before that I have mounted my foxpro dbf file to my linux in the
/home/benny/test directory.
Is there anything wrong?
Anyone could help me?

Regards;

Benny.



-- 
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: [PHP] RE: [PHP-DB] open foxpro database:solved

2001-05-02 Thread Benny

Thank's a lot.
I make the employee.dbf free table. And it's work.

Regards;

Benny.



-Original Message-
From: Scott Bernard [mailto:[EMAIL PROTECTED]]
Sent: 03 Mei 2001 8:44
To: Benny; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: [PHP] RE: [PHP-DB] open foxpro database


Try it again, but make the employee.dbf free table, or just making it
foxplus.

-Mensaje original-
De: Benny [mailto:[EMAIL PROTECTED]]
Enviado el: Miércoles, 02 de Mayo de 2001 07:03 a.m.
Para: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Asunto: [PHP-DB] open foxpro database


I used function dbase_xxx to access foxpro database (.dbf) but it's not
work.
Here is my code :
  ?
  if (dbase_open(/home/benny/test/employee.dbf,0)) {
for ($i=1; $i=dbase_numrecords($open); $i++) {
  $rec = dbase_get_record($db, $i);
  $nf  = dbase_numfields($db);
  for ($j=0; $j  $nf; $j++) {
print $rec[$j].br\n;
  }
}
  }
  ?
Everytime I call this page there's a message :
Warning: unable to open database /home/benny/test/employee.dbf in
/home/benny/htdocs/foxpro.php on line 2
I used php 4.0.4 and Visual Fox Pro 5.0.
Before that I have mounted my foxpro dbf file to my linux in the
/home/benny/test directory.
Is there anything wrong?
Anyone could help me?

Regards;

Benny.



--
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 General 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 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] open foxpro database

2001-05-02 Thread Abdul Kadir

Your problem is caused by  file name writing (because filename is
case-sensitive). PHP can read any FoxPro's Tables (free tables or databases
tables).

Regards,
Abdul Kadir

- Original Message -
From: Benny [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, May 02, 2001 9:12 AM
Subject: [PHP-DB] open foxpro database


 I used function dbase_xxx to access foxpro database (.dbf) but it's not
 work.
 Here is my code :
   ?
   if (dbase_open(/home/benny/test/employee.dbf,0)) {
 for ($i=1; $i=dbase_numrecords($open); $i++) {
   $rec = dbase_get_record($db, $i);
   $nf  = dbase_numfields($db);
   for ($j=0; $j  $nf; $j++) {
 print $rec[$j].br\n;
   }
 }
   }
   ?
 Everytime I call this page there's a message :
 Warning: unable to open database /home/benny/test/employee.dbf in
 /home/benny/htdocs/foxpro.php on line 2
 I used php 4.0.4 and Visual Fox Pro 5.0.
 Before that I have mounted my foxpro dbf file to my linux in the
 /home/benny/test directory.
 Is there anything wrong?
 Anyone could help me?

 Regards;

 Benny.



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

2001-05-02 Thread Pankaj Ahuja

Hi All

I want to upload images to my server and name them as found in my local
machine. I am able  to upload them using the copy function but the name on
the server is not the same on my local machine. How can I go about this

Thanks



-- 
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] pgsql 7.1 build

2001-05-02 Thread Yasuo Ohgaki

I haven't built 4.0.5 with PostgreSQL7.1, but I built CVS source with V7.1.
Last night, it compiles with warning message. It seems working, not tested.

For the time being, how about use latest CVS snapshot?
(And report problems, so that we can get stable postgresql module for 4.0.6?)

Regards,
--
Yasuo Ohgaki


Ron Patterson [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Hi there,

I'm building the new PHP-4.0.5 with support for PostgreSQL 7.1 database and
get the following build error:

gmake[3]: Entering directory `/net/clear1/home/rpatters/php-4.0.5/ext/pgsql'
/bin/sh /net/clear1/home/rpatters/php-4.0.5/libtool --silent --mode=compile
gcc
 -I. -I/net/clear1/home/rpatters/php-4.0.5/ext/pgsql
-I/net/clear1/home/rpatters/php-4.0.5/main
-I/net/clear1/home/rpatters/php-4.0.5 -I/net/clear1/home/rpatters/as3/include
-I/net/clear1/home/rpatters/php-4.0.5/Zend
-I/net/clear1/home/rpatters/php-4.0.5/ext/xml/expat/xmltok
-I/net/clear1/home/rpatters/php-4.0.5/ext/xml/expat/xmlparse
-I/net/clear1/home/rpatters/php-4.0.5/TSRM
-I/net/clear1/home/rpatters/pgsql/include -D_POSIX_PTHREAD_SEMANTICS
-D_POSIX_PTHREAD_SEMANTICS -D_REENTRANT -DSUPPORT_UTF8 -DXML_BYTE_ORDER=21
-I../TSRM -g -O2  -c pgsql.c
pgsql.c: In function `_notice_handler':
pgsql.c:158: warning: passing arg 1 of `php_log_err' discards `const' from
pointer target type
pgsql.c: In function `_rollback_transactions':
pgsql.c:167: `pgsql_globals' undeclared (first use this function)
pgsql.c:167: (Each undeclared identifier is reported only once
pgsql.c:167: for each function it appears in.)
gmake[3]: *** [pgsql.lo] Error 1
gmake[3]: Leaving directory `/net/clear1/home/rpatters/php-4.0.5/ext/pgsql'
gmake[2]: *** [all-recursive] Error 1
gmake[2]: Leaving directory `/net/clear1/home/rpatters/php-4.0.5/ext/pgsql'
gmake[1]: *** [all-recursive] Error 1
gmake[1]: Leaving directory `/net/clear1/home/rpatters/php-4.0.5/ext'
gmake: *** [all-recursive] Error 1

Worked ok with PostgreSQL 7.0.3

Any ideas?

Thanks,
Ron Patterson
USA.NET


Get free email and a permanent address at http://www.netaddress.com/?N=1

--
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 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] Migrating from InterBase 4.0 to 6.0

2001-05-02 Thread Steve Farmer

Hi all,

I need to migrate a database from InterBase 4.0 to 6.0 .  Question is 
has anybody done this and what are the snafus !!

The migration docs for 6.0 only seem to mention migration from 5.0 !!

I would imagine a complete export from 4.0 and import into 6.0 would 
be the way to go.

Any suggestions would be appreciated

Regards
Steve
-- 
---
Minds are like parachutes, they work best when open
Support free speech; visit http://www.efa.org.au/

Heads Together Systems Pty Ltd http://www.hts.com.au
Email: [EMAIL PROTECTED] Tel: 612 9982 6767 Fax: 612 9981 3081 

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

2001-05-02 Thread Selvin Sakal

I am behind a LAN and i would like to know to use PHP's get_meta_tags 
function though a proxy.

Can someone write me the help or write me the code

thanks
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.


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