[PHP-DB] DBM module

2001-10-19 Thread Pierre-Alain Joye
Hello, Currentlu testing the dbm functions (for a wrapper class), stopped with dbm. Configure does not recognize the dbm library (db-3.3.11). gdbm, db3 has been recognized. Wich library do I need to use the dbm function (with or without dba), any link ? thank's pa -- PHP Database Mailing

Re: [PHP-DB] How to write errorhandling??

2001-10-21 Thread Pierre-Alain Joye
Hello,  Warning: Cannot add header information - headers already sent by (output  started at  e:\projects\globosapiens\07_production\actual\account\include\user.php:256)  in e:\projects\globosapiens\07_production\actual\account\include\user.php  on line 260  Where is the problem??? I can't see

Re: [PHP-DB] Ms-Access to Mysql converter

2001-11-01 Thread Pierre-Alain Joye
On Thu, 1 Nov 2001 16:17:38 +0550 [EMAIL PROTECTED] wrote: Most of them availalbe in the downloads section of mysql.com : http://www.mysql.com/downloads/contrib.html Look at the sections clients, converter and using MySql with Other Products hth pa -- PHP Database Mailing List

Re: [PHP-DB] About Berkeley DB2 Databases

2001-11-14 Thread Pierre-Alain Joye
On Wed, 14 Nov 2001 16:27:20 -0400 (VET) Ricardo Núñez [EMAIL PROTECTED] wrote: Mensaje citado por: Gonzalez, Lorenzo [EMAIL PROTECTED]: I thought '--with-db2' meant you'd get a DB2 (IBM) driver... what has DB2 got to do with Berkeley? An I suffering a bit of confusion between IBM's

Re: [PHP-DB] About Berkeley DB2 Databases

2001-11-14 Thread Pierre-Alain Joye
I just put '--with-db2'. I suppose it compiled its Berkeley db2 code. Other thing, I use PHP 4.0.6. me too ;) but php not... every others tools on my station recognizes the db,db2 and db3 support, php not. Which lib do you have ? any link ? (or email :) pa -- PHP Database Mailing List

Re: [PHP-DB] About Berkeley DB2 Databases

2001-11-14 Thread Pierre-Alain Joye
On Wed, 14 Nov 2001 16:56:47 -0400 (VET) Ricardo Núñez [EMAIL PROTECTED] wrote: Mensaje citado por: Pierre-Alain Joye [EMAIL PROTECTED]: I just put '--with-db2'. I suppose it compiled its Berkeley db2 code. Other thing, I use PHP 4.0.6. me too ;) but php not... every others tools

Re: [PHP-DB] Re: [PEAR-DEV] Re: Common DB Abstraction Layer: Re: [PEAR-DEV] Adoption of Metabase

2001-11-21 Thread Pierre-Alain Joye
On Wed, 21 Nov 2001 09:19:44 -0500 (EST) Joao Prado Maia [EMAIL PROTECTED] wrote: On Wed, 21 Nov 2001, Manuel Lemos wrote: If we fixed these problems and more, we could talk about having a unified API. Otherwise for the Oracle OCI_ASSOC, I would prefer not to change it for speed,

[PHP-DB] Re: [PEAR-DEV] Re: Common DB Abstraction Layer: Re: [PEAR-DEV] Adoption of Metabase

2001-11-21 Thread Pierre-Alain Joye
Well I strongly need thoses $15 000 $ so What is the purpose ? As a average php user/developper I don_t really care about the pure cross plateform/database issue but I do care about a standard, clean, secure (my- bugs-free) and easy way to use a database, and PEAR::BD + Thomas V Cox

Re: [PHP-DB] Re: Common DB Abstraction Layer: Re: [PEAR-DEV] Adoption of Metabase

2001-11-21 Thread Pierre-Alain Joye
On Wed, 21 Nov 2001 16:14:04 +0100 (MET) Luc Saint-Elie [EMAIL PROTECTED] wrote: En réponse à Pierre-Alain Joye [EMAIL PROTECTED]: This definition defines more a common interface to connect to a db, execute queries, fetch the result and eventually gives errors reports ;). Somehow

Re: [PHP-DB] Re: [PEAR-DEV] Re: Common DB Abstraction Layer: Re: [PEAR-DEV] Adoption of Metabase

2001-11-21 Thread Pierre-Alain Joye
I probably used a bad choice of words. What I really meant was: What is the objective of PEAR::DB as a database abstraction library ? To abstract as much as possible like Metabase already does, or to provide a unified API to databases and leave the implementation related to database specific

Re: [PHP-DB] RE: [PHP-WIN] Can I rotate a gif with PHP

2001-11-02 Thread Pierre-Alain Joye
that produce a gif and then calling that gif as part of the report. But I need to rotate this gif 90 degrees CW. Can I do that with PHP? Platform - W2K MySQL PHP 4.04 Let me clarify this. The app is written in PHP and I cannot find anything that references rotating an

Re: [PHP-DB] a Count() ?

2002-03-16 Thread Pierre-Alain Joye
On Sat, 16 Mar 2002 10:46:38 - Dave Carrera [EMAIL PROTECTED] wrote: Hi All I am trying to count how many product names in my db have the same category id and then show it ie: Catid 1 Product 1 Catid 1 Product 2 Catid 2 Product 3 Catid 3 Product 4 Catid 3 Product 5 Result

Re: [PHP-DB] a Count() ?

2002-03-16 Thread Pierre-Alain Joye
On Sat, 16 Mar 2002 11:50:11 - DL Neil [EMAIL PROTECTED] wrote: Hi Dave, SELECT * FROM tblNm; SELECT * FROM tblNm GROUP BY Catid1; SELECT Catid1, count(*) FROM tblNm GROUP BY Catid1; As I said 'follow your instincts' and take it one step at a time: Code the simplest query first,

RE: [PHP-DB] Date problem

2002-05-12 Thread Pierre-Alain Joye
i get $postdate from my mysql database,the problem is that i want to increase that date by 6 months?? its stored in mysql as date field http://www.mysql.com/doc/D/a/Date_and_time_functions.html check DATE_ADD :) hth pa -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,

Re: [PHP-DB] foreach

2002-06-03 Thread Pierre-Alain Joye
On Mon, 3 Jun 2002 12:48:47 -0400 James Kupernik [EMAIL PROTECTED] wrote: and I'm getting this: Warning: Invalid argument supplied for foreach() Why is that? are you sure $cart is an array ? pa -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

Re: [PHP-DB] Differences between two mySQL Databases

2002-06-25 Thread Pierre-Alain Joye
On Tue, 25 Jun 2002 14:29:08 -0700 Michael Robbins [EMAIL PROTECTED] wrote: I'm looking for a utility that can compare two database structures and generate a SQL statement that will duplicate the differences. I'm using mySQL and I have both live and development databases. While working

Re: [PHP-DB] PHPed and DBG

2002-06-26 Thread Pierre-Alain Joye
On Wed, 26 Jun 2002 10:41:26 +0200 Dib, Walid (MED, Stagiaire GEMS) [EMAIL PROTECTED] wrote: Hello, I downloaded the application PHPEd and DBG, I need débugger but I cannot bind the two applications is what somebody has an idea. Thank you in advance I did not use DBG on

Re: [PHP-DB] PHPed and DBG

2002-06-26 Thread Pierre-Alain Joye
On Wed, 26 Jun 2002 10:41:26 +0200 Dib, Walid (MED, Stagiaire GEMS) [EMAIL PROTECTED] wrote: Hello, I downloaded the application PHPEd and DBG, I need débugger but I cannot bind the two applications is what somebody has an idea. Thank you in advance the link to the forum :

Re: [PHP-DB] Why do these values not match?

2002-06-26 Thread Pierre-Alain Joye
On Wed, 26 Jun 2002 06:52:14 -0700 (PDT) Manuel [EMAIL PROTECTED] wrote: Any idea why this problem does not manifest itself in Foxpro, Excel or Visual Basic? This problem happens also with VB. But later :), By example if you use decimal type, smallest non-zero number is

Re: [PHP-DB] Re: Unified DB Query function

2002-07-01 Thread Pierre-Alain Joye
On Mon, 01 Jul 2002 14:55:01 -0300 Manuel Lemos [EMAIL PROTECTED] wrote: Hello, On 07/01/2002 06:46 AM, Casey Allen Shobe wrote: I'm trying to write a unified database query function for an application I have which currently accesses data from both DB2 and Microsoft SQL from a Linux

Re: [PHP-DB] blob versus file

2002-07-01 Thread Pierre-Alain Joye
On Mon, 1 Jul 2002 14:17:53 +0200 andy [EMAIL PROTECTED] wrote: Hi there, I am wondering if anybody has experiance in saving images to blob in mysql. I do save images with 1 K and 4 KB to blob fields while I used to save them to file. It seams to me that this is much slower accessing the

Re: [PHP-DB] blob versus file

2002-07-02 Thread Pierre-Alain Joye
On Tue, 2 Jul 2002 05:45:40 +0200 Andy [EMAIL PROTECTED] wrote: is the increase of the network traffic noticable? The query is pretty small just text. Do u really think this might increase the traffic? Try to heavely charge a DB with images inside it. Do the same without DB, that depends if

Re: [PHP-DB] blob versus file

2002-07-02 Thread Pierre-Alain Joye
On Tue, 02 Jul 2002 12:57:56 +0200 Michael Bretterklieber [EMAIL PROTECTED] wrote: Hi, one point that you should keeped in mind is, if you have a cluster of webservers connecting to the same db-server, then you have to mount the filesystems, where you store the images on all webservers.

Re: [PHP-DB] DAO implementations

2002-07-17 Thread Pierre-Alain Joye
On Wed, 17 Jul 2002 10:06:11 +0200 Ulf Wendel [EMAIL PROTECTED] wrote: Hi, are there some DAO pattern implementations available for PHP to query MySQL, Postgres and/or DB2? Which one do you preferr? What mean DAO ? It can be confused (dao, ado, ...). Did you try PEAR::DB_DataObject

Re: [PHP-DB] DAO implementations

2002-07-17 Thread Pierre-Alain Joye
Update your vacation message, we are the 17th :) pa -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: PicoSQL!

2002-07-24 Thread Pierre-Alain Joye
On Thu, 25 Jul 2002 09:27:04 +0200 Pentothal [EMAIL PROTECTED] wrote: Last but not least: it distributed under GPL ! AFAIK, that may causes problems. We cannot link GPL with non GPLized codes. pa -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

Re: [PHP-DB] Fw: Date Add

2002-08-04 Thread Pierre-Alain Joye
On Sun, 4 Aug 2002 17:30:31 +0200 John Fishworld [EMAIL PROTECTED] wrote: Why not simply does the where clause like : for a whole month, here is july: WHERE YEAR(t_event_date)='2002' AND MONTH(t_event_date)='7' For a specific day, here the current day WHERE t_event_date=NOW() That means you

Re: [PHP-DB] Fw: Date Add

2002-08-04 Thread Pierre-Alain Joye
On Sun, 4 Aug 2002 17:42:17 +0200 Pierre-Alain Joye [EMAIL PROTECTED] wrote: On Sun, 4 Aug 2002 17:30:31 +0200 John Fishworld [EMAIL PROTECTED] wrote: For a specific day, here the current day WHERE DAYOFMONTH(t_event_date)=DAYOFMONTH(NOW()) AND MONTH(t_event_date)=MONTH(NOW()) if you store

Re: [PHP-DB] form validation question - regex not working

2002-08-21 Thread Pierre-Alain Joye
On Thu, 22 Aug 2002 03:10:02 +0800 Jason Wong [EMAIL PROTECTED] wrote: On Thursday 22 August 2002 02:54, [EMAIL PROTECTED] wrote: As you can see, the list address ([EMAIL PROTECTED]), and my address ([EMAIL PROTECTED]) would be treated as invalid. Not very clever is it? Well, anyway there

Re: [PHP-DB] how to display tree structure from database???

2002-08-27 Thread Pierre-Alain Joye
Hello, http://membres.lycos.fr/sqlpro/Tree/SQL_tree.htm provides a good way to store trees in a DB, docs are in french, nut sqlimages are universal. hth pa -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] form variables not beeing passed to next page

2002-08-30 Thread Pierre-Alain Joye
On Fri, 30 Aug 2002 12:09:22 +0200 simon [EMAIL PROTECTED] wrote: Worked fine in 4.06? Have I missed something? REGISTER_GLOBAL is set to OFF from 4.2.x, code should be: if(isset($_POST['sumbit'])) pa -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

Re: [PHP-DB] Indepth Tutorial... need help.

2002-09-03 Thread Pierre-Alain Joye
On Tue, 03 Sep 2002 08:56:43 -0400 Matt Zur [EMAIL PROTECTED] wrote: Can someone point me in the direction of an online tutorial for php mysql that covers the following: http://www.phpbuilder.com http://www.devshed.com http://www.devarticles.com Well, if you do not find something here :-)

Re: [PHP-DB] Using a variable as a variable name

2002-09-04 Thread Pierre-Alain Joye
hello, You can find syntax description in the documentation (variable variables section) $myvar1 = MYVAR1 CONTENT; $myvar2 = MYVAR2 CONTENT; $i = 0; $myvar = 'myvar'.++$i; echo \n; echo $$myvar; echo \n; $myvar = 'myvar'.++$i; echo \n; echo $$myvar; echo \n; can do it hth pa -- PHP

Re: [PHP-DB] Need help urgent!!

2002-09-26 Thread Pierre-Alain Joye
On Thu, 26 Sep 2002 19:48:31 +0300 Thomas \omega\ Henning [EMAIL PROTECTED] wrote: I'm using PHP4.2.2 Win with MySQL 3.2.52 Win and PHP doesn't pass vars from 1 php to the other how i fix it? Read the documentation, register_globals is SET to off by default.

Re: [PHP-DB] Valid IP

2002-09-26 Thread Pierre-Alain Joye
On Thu, 26 Sep 2002 11:39:40 -0500 Wilmar Perez [EMAIL PROTECTED] wrote: Hello guys I know this should be asked in another list but don't want to subcribe just for a simple question. I apologise in advance if that bothers anyone. I'm trying to check valid IPs that come from a form

Re: [PHP-DB] Getting POSTed values

2002-10-04 Thread Pierre-Alain Joye
On Fri, 04 Oct 2002 20:13:57 -0700 Shoulder to Shoulder Farm [EMAIL PROTECTED] wrote: Hi all, Sorry, but I REALLY don't want to subscribe to the PHP general list, it's so high volume, so here goes. --T How can I get values that were posted from a form to a PHP document turned into

Re: [PHP-DB] Variable won't be passed from HTTP address bar

2002-10-18 Thread Pierre-Alain Joye
On Fri, 18 Oct 2002 13:26:20 +0200 Michel Bakkenes - bakkenes.net [EMAIL PROTECTED] wrote: Ok.. I'm not a newbie I thought.. I do have experience with PHP, but I never suffered from this error. I used on my own redhat 8.0 server the following test-script: if($action==test){ echo Test;}

Re: [PHP-DB] Warning message

2002-11-07 Thread Pierre-Alain Joye
On Thu, 7 Nov 2002 13:37:49 -0500 Anderson, Jerrad [EMAIL PROTECTED] wrote: I'm using PHP on apache that's sitting on a Windows 2k server. When I don't define a variable i'm getting a warning message on the screen.. anyway to suppress these errors? Warning: Undefined variable:

Re: [PHP-DB] php oop books

2003-01-12 Thread Pierre-Alain Joye
On Sun, 12 Jan 2003 14:58:36 -0500 Michael Scappa [EMAIL PROTECTED] wrote: I know this is a bit off topic, can anyone recommend a good php / oop book? I've been through php.net's library and nothing really on there. Thanks I do Not a good book about OOphp, but a good site:

Re: [PHP-DB] Concatenate two strings

2003-01-15 Thread Pierre-Alain Joye
On Wed, 15 Jan 2003 14:47:59 - Bruno Pereira [EMAIL PROTECTED] wrote: How can i join two strings. My code is something like: $valor1=bruno; $valor2=Pereira; $valor=$valor1 + + $valor2 $valor=$valor1 . . $valor2; See http://www.php.net/manual/pt_BR/language.operators.string.php

Re: [PHP-DB] Re: Images-weird!!

2003-02-02 Thread Pierre-Alain Joye
On Sun, 02 Feb 2003 14:36:38 -0800 (PST) Mihail Bota [EMAIL PROTECTED] wrote: No, this is not the problem. I did not test your code but a color channel start at 0 and finished at 255, corresponding to 256 possibilities. pierre -- PHP Database Mailing List (http://www.php.net/) To

Re: [PHP-DB] Re: Images-weird!!

2003-02-02 Thread Pierre-Alain Joye
On Sun, 02 Feb 2003 14:36:38 -0800 (PST) Mihail Bota [EMAIL PROTECTED] wrote: No, this is not the problem. $i and $j start from 0, anyway. The real problem, as I see it, is the following: I have a big loop, to create something like a checkerboard, but with 13 or so colors. If the loop

Re: [PHP-DB] Re: Images-weird!!

2003-02-02 Thread Pierre-Alain Joye
On Sun, 02 Feb 2003 15:29:44 -0800 (PST) Mihail Bota [EMAIL PROTECTED] wrote: Yeah, I had the idea with truecolor, but I do not have GD2 installed. I have to install it, first. Still, I do not understand! I only have 13 colors, why is allocating only 255? I am not using the indexes in the

Re: [PHP-DB] efficient next/prev page generation

2003-02-14 Thread Pierre-Alain Joye
Hello, See http://www.pearfr.org/docs/dbpager.php?lang=en, a tutorial about PEAR::DB_Pager, which paging datas, from a DB result or a simple array. It can help you to find a good method. hth pierre -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

Re: [PHP-DB] PHP Paging

2003-06-12 Thread Pierre-Alain Joye
On 12 Jun 2003 16:01:01 -0500 Cory Hicks [EMAIL PROTECTED] wrote: FAW, I would look at PEAR and then run, don't walkand get the DB_Pager It smokes anything else I have tried... little tutorial on: http://www.pearfr.org/index.php/en/article/db_pager hth pierre -- PHP

Re: [PHP-DB] PHP Paging

2003-06-12 Thread Pierre-Alain Joye
On Thu, 12 Jun 2003 16:45:00 -0500 Sallee, Helen [EMAIL PROTECTED] wrote: If you are on UNIX, you could just use a cgi script and use sendmail command. paging datas (Page 1 fo 3 1 2 3 ), not send a msg to a pager :) pierre -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,

Re: [PHP-DB] MySQL editor

2003-06-19 Thread Pierre-Alain Joye
Hello, Not really the same purpose, but so powerfull :) http://www.fabforce.net/dbdesigner4/ pierre -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Page Use

2003-06-23 Thread Pierre-Alain Joye
Hello, something really good: http://www.phpopentracker.de/ hth pierre -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Page Use

2003-06-23 Thread Pierre-Alain Joye
On Mon, 23 Jun 2003 10:33:59 -0300 Tim Winters [EMAIL PROTECTED] wrote: Interesting Pierre, Is this something you have ever used? I have tested it for a few weeks ago (and starting to translate the doc to fr ;). I use it in a current project. However be sure this is really something good and

Re: [PHP-DB] PDF Implementation

2003-07-17 Thread Pierre-Alain Joye
On Thu, 17 Jul 2003 09:01:53 -0500 [EMAIL PROTECTED] wrote: Good Morning All , Has anyone successfully implemented PDF functionality within their PHP / MySQL projects? My needs are very basic, so I'd like to use something like ezPDF creation to avoid buying a license. But I haven't