Re: [PHP-DB] INFORMIX PROBLEM

2003-08-27 Thread Martin Marques
El Mié 27 Ago 2003 16:01, Luigi Vellucci escribió: Hi I'm trying to compile php 4.1.2 from the source RPM in RedHat 7.3 but I wasn't succesfully. Please does anybody know what it means the following error: *** Warning: Linking the shared library libphp4.la against the non-libtool *** objects

Re: [PHP-DB] MySQL, PHP or ghost?

2003-08-28 Thread Martin Marques
El Mié 27 Ago 2003 11:34, Ignatius Reilly escribió: Hmmm... You have a point; the doc is not quite clear. Illegal YEAR values are converted to My understanding is that any illegal value will be first converted into '', then into the corresponding year inside the 1901-2155

Re: [PHP-DB] MySQL, PHP or ghost?

2003-08-28 Thread Martin Marques
El Jue 28 Ago 2003 11:25, Ignatius Reilly escribió: Well, it IS logical provided one is aware of the rules of the game, meaning, as you rightly point out, that MySQL does not reject SQL statements for incorrect values, but attempts at converting them at any price. I have no clue whether it is

Re: [PHP-DB] MySQL, PHP or ghost?

2003-08-28 Thread Martin Marques
El Jue 28 Ago 2003 17:20, Ignatius Reilly escribió: Well, you're certainly right (except I didn't get the meaning of 'FS' - anything obscene?). However: File System. 1. The job of this ML is to help people get things done 2. For criticisms concerning the design of MySQL, you may get better

Re: [PHP-DB] Beta 2 of plPHP released.

2003-08-29 Thread Martin Marques
El Vie 29 Ago 2003 06:15, Ford, Mike [LSS] escribió: On 29 August 2003 05:27, Joshua D. Drake wrote: Hello, Beta 2 of plPHP has been released. This version contains many bug fixes. For example, if you write bad plphp code and try to execute it, the code will no longer crash

Re: [PHP-DB] Failure Notices When Posting to List

2003-08-29 Thread Martin Marques
El Vie 29 Ago 2003 11:51, Hutchins, Richard escribió: Is anybody else getting returned mail notices from the qmail-send program at pb1.pair.com? I seem to get one with each post I send to the list and I don't know what's happening with my posts. Not that they're pure gold or anything, but

Re: [PHP-DB] PHP, MySQL and Apache 2 ?

2003-09-02 Thread Martin Marques
El Mar 02 Sep 2003 16:11, David Haines escribió: This is maybe a bit Off-topic, and yet I could think of no better place to ask: How many of you are using PHP with MySQL and Apache 2 ? I know there _were_ some problems, but do the current (stable) PHP and MySQL work fine with Apache 2 ?

Re: [PHP-DB] Set autocommit to off/on from PHP

2003-09-03 Thread Martin Marques
El Mar 02 Sep 2003 08:05, Joanna Owczarzak escribió: PHP 4.1.2, postgreSQL 7.1.3. How to change autcommit property of postgreSQL database from php script? $db = DB::Connect($dbn); $db-autocommit(false); Saludos... :-) P.D.: They should document this. -- 18:26:01 up 12 days, 10:16, 4

Re: [PHP-DB] How to exclude the result of union of two tables from the result of union of other two tables

2003-09-05 Thread Martin Marques
This can be done in one query using subselects. El Vie 05 Sep 2003 15:49, John W. Holmes escribi: Oz wrote: I have a php page where I would like to list a numer of companies as below: 1- retrieve all distinct company names from TableA (SELECT company_name FROM TableA) CREATE

Re: [PHP-DB] Connect to Oracle DB

2003-09-12 Thread Martin Marques
El Vie 12 Sep 2003 15:52, Frederico Madeia escribi: Dear friends, How i connect one server running PHP(linux) to other server running Oracle(linux) ?? when i tryed to connect with ora_logon, the server return me: Call to undefined function: ora_logon(). In php.net describe some functions

Re: [PHP-DB] Connect to Oracle DB

2003-09-13 Thread Martin Marques
El Sb 13 Sep 2003 03:56, Jack van Zanen escribi: Hi I don't know how this shared library works, but to the best of my knowledge you'll always need oracle client software (SQL*Net) installed on the php server to connect to an oracle database . Please correct me if I'm wrong and point me to

Re: [PHP-DB] Connect to Oracle DB

2003-09-14 Thread Martin Marques
El Vie 12 Sep 2003 18:36, Frederico Madeia escribi: Martin, In some doc that i've read when i compile the php i must put yhe $ORACEL_HOME path, so if oracle isn't instaled on same machine ??? Lets see. I don't use, or ever used Oracle, but I guess my experience with Informix and PostgreSQL

Re: [PHP-DB] Need to Run a PHP script using CRON or ?

2003-09-16 Thread Martin Marques
El Lun 15 Sep 2003 17:47, Jonathan Villa escribió: I believe this would need php to installed as a cgi, which I prefer not to do... If you don't want to because of security resons, please install it and don't leave it in the hands of the web server. If you don't want to go through the problem

Re: [PHP-DB] numeric in plpgsql function

2003-10-02 Thread Martin Marques
El Mié 01 Oct 2003 22:45, Gezeala 'Eyah' Bacuño II escribió: Saw this in the Postgresql manual : Chapter 8. Data Types Some of the operators and functions (e.g., addition and multiplication) do not perform run-time error-checking in the interests of improving execution speed. On some

Re: [PHP-DB] php and MySQL and PostgresSQL at the same time

2003-10-02 Thread Martin Marques
El Jue 02 Oct 2003 08:22, Morten Gulbrandsen escribió: Is it possible to use PHP under one Apache WEB application in order to access MySQL and at the same time PostgreSQL? different databases ? Depends on how the question was made. Yes you can access diferent database engines from the

Re: [PHP-DB] Confused

2003-10-05 Thread Martin Marques
El Dom 05 Oct 2003 12:44, Robin Kopetzky escribió: I need to setup a user, 'commerce' with a password, that can be accessed from any web server in our farm 'blackmesa-isp.net'. What GRANT statement do I need to make this work? I've tried a bunch of the examples in the manual and can't get it

Re: [PHP-DB] Confused

2003-10-05 Thread Martin Marques
El Dom 05 Oct 2003 13:07, Jason Wong escribió: On Sunday 05 October 2003 23:44, Robin Kopetzky wrote: I need to setup a user, 'commerce' with a password, that can be accessed from any web server in our farm 'blackmesa-isp.net'. What GRANT statement do I need to make this work? I've tried a

Re: [PHP-DB] SQL File Insert???

2003-10-12 Thread Martin Marques
El Dom 12 Oct 2003 17:36, John Ryan escribió: Ive a file on my server with SQL instructions to create a table and insert stuff. How do I get this to be run on the database? Once againg, somebody that doesn't specify which database server he is using Pleas, be more specific! -- Porqué

Re: [PHP-DB] PostgreSQL, Triggers

2003-10-19 Thread Martin Marques
El Dom 19 Oct 2003 13:54, Ling escribió: Hello there. Can anybody help me with Postgresql triggers? what I need is a trigger which inrements value in field total_rows.rows if I insert new row in table zzz... CAREATE TABLE zzz ( ... ... ); CREATE TABLE total_rows ( table_name

Re: [PHP-DB] pg_connect() problem with postgresql 7.3.4

2003-10-29 Thread Martin Marques
El Mié 29 Oct 2003 07:14, S.P.Vimala escribió: Hi, I have installed posgresql(serve/libs)-7.3.4 on my linux machine. It has httpd-2.0.40-8 php-4.2.2-8.0.8 php-pgsql-4.2.2-8.0.8 Now pg_connect on my code gives me an error undefined function call. I tried to

Re: [PHP-DB] date function

2003-11-02 Thread Martin Marques
1) Why do you send this to a DB list? 2) Try seeing the Date class of PEAR (PEAR::Date). El Dom 02 Nov 2003 19:13, OpenSource escribió: Hi guys, This might not be the best place for this but here goes. I want to create a dropdown list with a date range of

Re: [PHP-DB] RE: select inside a while loop

2003-11-29 Thread Martin Marques
Sorry, just say the message. Your code looks well. But is the variable $db the name of your database or your link-identifier. When it is the name of your database i'm not really surpised your code wouldn't work. mysql_query requires as second argument a link identifier. Read what Rolf says.

Re: [PHP-DB] Re: Very complex query

2003-12-11 Thread Martin Marques
El Jue 11 Dic 2003 05:00, Muhammed Mamedov escribió: You can also DISTINCT command instead. UNIQUE command isnot supported by mySQL (at least at MySQL 3.23.41- I am using) UNIQUE is for table creation or index creation. It is relevent for insertion, not selects. DISTINCT and DISTINCT ON() are

Re: [PHP-DB] Re: Very complex query

2003-12-11 Thread Martin Marques
El Jue 11 Dic 2003 05:17, Mike U. Petrov escribió: No, DISTINCT isn't match my purpose cause of it rerurns unique rows but I need ONE user_id per one object_id. GROUP BY is your answer. -- 15:51:02 up 15 days, 22:07, 3 users, load average: 0.90, 0.75, 0.61

Re: [PHP-DB] Re: Very complex query

2003-12-11 Thread Martin Marques
El Jue 11 Dic 2003 05:30, Mike U. Petrov escribió: I tried to use GROUP BY and it worked almost right but i need to return user_id and mysql generated an error that notes.user_id isn't used in GROUP BY... Add it to the GROUP BY. -- 16:33:02 up 15 days, 22:49, 4 users, load average: 0.03,

Re: [PHP-DB] pg_result_error()

2003-12-12 Thread Martin Marques
El Vie 12 Dic 2003 00:09, Gerard Samuel escribió: What good is this function? A quick example of the wall Im running into - $sql = 'INSERT INTO .'; $result = pg_query($conn_id, $sql); if ($result === false) { var_dump( pg_result_error( $result ) ); I would use here this:

Re: [PHP-DB] pg_result_error()

2003-12-12 Thread Martin Marques
El Vie 12 Dic 2003 11:19, Gerard Samuel escribió: Im going to CC this to the PostgreSQL list also. On Friday 12 December 2003 06:44 am, Martin Marques wrote: El Vie 12 Dic 2003 00:09, Gerard Samuel escribió: What good is this function? A quick example of the wall Im running

Re: [PHP-DB] Informix - help!

2003-12-15 Thread Martin Marques
El Dom 14 Dic 2003 19:00, Daniel Crespo escribió: I have red hat linux with Apache web server and PHP. I want to connect, using PHP, to an Informix Database remotely. What is all I have to do on my side? Thanks a lot Install informix client libraries where php will go and compile using

Re: [PHP-DB] Something ease... I guess

2003-12-16 Thread Martin Marques
El Mar 16 Dic 2003 10:44, Nikos Gatsis escribió: Hello list I have 4 variables, $check1, $check2, $check3, $check4 How can i use a for loop to echo each one. (lets say echo $check($i)...) foreach(list($check1, $check2,...) AS $c){ echo $c; } -- 15:20:02 up 16 days, 21:36, 3

Re: [PHP-DB] Skipping a row

2003-12-18 Thread Martin Marques
El Jue 18 Dic 2003 18:27, John Greco escribió: I have a select statement that goes to my mySQL db and selects some data from there. I thought it was working great BUT it is skipping the first row. Any ideas? I know it has to be somehting simple I am missing. Depends on how you are fetching

Re: [PHP-DB] EMERGENCY!!

2003-12-31 Thread Martin Marques
You throw code to the list with no information about what errors or warnings you got. Why do you say it doesn't work? What happens when you run the script? El Mié 31 Dic 2003 12:46, John Greco escribió: I am trying to build a web site for our inventory. I have a mysql DB that i connect to.

Re: [PHP-DB] EMERGENCY!!

2003-12-31 Thread Martin Marques
El Mié 31 Dic 2003 16:25, escribió: He surelly has problems with his DB server. Does the script die? I am outputting mysql_error() nothing is showing up. Hows the mysql logs? I don't know where these are. is there some kind of high load on the DB server? I am the only one on it right now.

Re: [PHP-DB] Database abstraction

2004-01-13 Thread Martin Marques
Mensaje citado por Malte Starostik [EMAIL PROTECTED]: Hi, I've read several posts touching this subject, but I didn't find one that asks a simple question I've been wondering about since I first used PHP and that is also one of the two really really bad things about PHP (the other being

Re: [PHP-DB] Database abstraction

2004-01-13 Thread Martin Marques
Mensaje citado por Jason Wong [EMAIL PROTECTED]: Whilst there isn't a builtin database abstraction layer in PHP itself there are a number of projects which fills the gap. There's the semi-official PEAR-DB, also ADODB and Metabase. Why is it you say it's semi-official? I have always felt

Re: [PHP-DB] Solaris apache 2.0.47 + php 4.3.4 + oracle 9i ( oci8 support in php as shared module )

2004-01-15 Thread Martin Marques
Mensaje citado por Daniel Sand [EMAIL PROTECTED]: Hi Folks, I have an generic question. first of all. The stuff runs fine. But ( the question ? ) If i make any DB connections from any Virtual Server that i configured in apache, PHP always takes the Main Ethernet Interface. Not The

Re: [PHP-DB] Re: Subselect ?

2004-01-16 Thread Martin Marques
Mensaje citado por Christine Clerc [EMAIL PROTECTED]: Well, I had tried this : SELECT DISTINCT id_script FROM readme WHERE id_language = $languageorignin; But then I have to do this with the selection : SELECT DISTINCT id_script FROM readme WHERE id_language != $languagetarget; but it cannot

Re: [PHP-DB] multi-language site

2004-01-16 Thread Martin Marques
Mensaje citado por Muhammed Mamedov [EMAIL PROTECTED]: Thank you for your comments Ignatius. (just to note) : I do not agree that all projects SHOULD require CLEAR sepeartion of code and appearance. Let me disagree with you! :-) I a multi-tiered design yuo have a client layer, a server layer

Re: [PHP-DB] Fw: informix problem

2004-01-17 Thread Martin Marques
Mensaje citado por stefan bogdan [EMAIL PROTECTED]: i have winnt 4.0 servicepack 6 + apache 2.0.47 + php 430 + informix client for nt ilogin demo works fine sql editor works fine but when i try to connect to informix via php i'get an error like Warning: ifx_connect(): E

Re: [PHP-DB] multi-language site

2004-01-18 Thread Martin Marques
Mensaje citado por Muhammed Mamedov [EMAIL PROTECTED]: Thank you for your help Martin, I am aware of the seperation stuff you are talking. There is a much more professional term for that 'Design Patterns' use in JAVA (I tell you as a JAVA professional).. I am also aware of need for code and

Re: [PHP-DB] Anybody using PostgreSQL?

2004-04-14 Thread Martin Marques
El Mié 14 Abr 2004 07:39, Tumurbaatar S. escribió: In PHP5 manual, it says that when using large objects functions of PostgreSQL, a program should manually begin/end transaction. But what about other query/exec functions? Do I need to control transactions or every function call implicitly

Re: [PHP-DB] From MySQL to PostgreSQL

2004-05-08 Thread Martin Marques
El Vie 07 May 2004 22:49, Marcjon Louwersheimer escribió: Hi. I developed a forum using php5 and mysql. Right now I'm hosting it on my computer, for version for myself and another for a school I volunteer at. I would like to move the forums to the school's server. Apperently they don't have

Re: [PHP-DB] PostgreSQL lib and character case

2004-04-28 Thread Martin Marques
El Wednesday 28 April 2004 03:21, Tumurbaatar S. escribió: I use pg_fetch_array() to get a record content. But it seems that to access elements of the returned associative array, I should use lowercase field names. Is there any way to use case-insensitive field names? No. PHP is

Re: [PHP-DB] Informix and PHP

2004-05-22 Thread Martin Marques
El Vie 21 May 2004 14:48, D. Sandmann escribió: Any help would be appreciated on this. I have already asked this question on the regular PHP and Informix news groups and have not had any luck. Maybe one of you can resolve my problem. I have had this problem in the past on another machine and

Re: [PHP-DB] fetch row DISTINCT

2004-07-13 Thread Martin Marques
On Fri, 9 Jul 2004, Peter Westergaard wrote: One idea that occurs to me, and it's a tradeoff from Torsten's idea (which is to read the whole database, and parse out the unique rows), is to first execute your SELECT DISTINCT distinct_col FROM table, and then walk through that, and for each one

[PHP-DB] Re: [PHP] the opposite of a join?

2007-10-03 Thread Martin Marques
[EMAIL PROTECTED] wrote: I have a company table and a contacts table. In the contacts table, there is a field called companyID which is a link to a row in the company table. What is the easiest way to query the company table for all the company rows whose ID is NOT linked to in the contact