[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
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
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
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
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
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
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
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
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
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
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
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
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
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.
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.
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
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
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
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:
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
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
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
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,
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.
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
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
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
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é
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
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
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
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
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
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
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
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
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
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
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 ?
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
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
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
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
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
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
45 matches
Mail list logo
