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 say
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() a
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
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 qui
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
--wi
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,
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 y
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 15:28, Dennis Cole escribió:
> I think that it has more to do with the type of fields he is putting it
> into:
>
> --
> I am trying to build a web site for our inventory. I have a mysql DB
> that I Connect to. The following code is what I use. The array products
> wont go p-past
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
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
> b
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 f
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 Interfac
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
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 la
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(
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 co
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 implic
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 case-sens
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
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 ea
On Tue, 13 Jul 2004, Peter Westergaard wrote:
> I'm developing a site where I anticipate the need to make several updates to
> several forms, and I'll want to "commit" them all at once (i.e. if there's a
> failure with any of the transactions, I'd like to be able to back out to
> before I started)
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
> *** ob
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 i
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 bette
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 cr
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, b
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 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 u
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)
>
> CR
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 fun
El Sáb 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 m
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 PostgreS
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 Mié 24 Sep 2003 07:24, nabil escribió:
> Dear all;
>
> I have been using Mysql for a long time, but I have a benchmark Q.
>
> Is pgsql , better ? faster ? more reliable than mysql ?
Maybe not faster in FTS, but surely MORE reliable!!!
> any comment ?
> Some people say that php is not for a ver
El Mié 24 Sep 2003 17:27, [EMAIL PROTECTED] escribió:
> > El Mié 24 Sep 2003 07:24, nabil escribió:
> > > Dear all;
> > >
> > > I have been using Mysql for a long time, but I have a benchmark Q.
> > >
> > > Is pgsql , better ? faster ? more reliable than mysql ?
> >
> > Maybe not faster in FTS, but
El Mié 24 Sep 2003 18:15, Ignatius Reilly escribió:
> Yeah, banking is too serious a business in Argentina, as everybody knows,
> to entrust to MySQL.
Uhmmm. Are you a bond holder? You should have stated it as an irony, if that
was the case.
Else, it's very unclear what you are trying to express.
El Jue 25 Sep 2003 13:08, Dave [Hawk-Systems] escribió:
> we have a number of csv dumps that occasionally have to be used to update
> tables in a postgres database...
>
> normally this is done by uploading the file and whomever running a php
> based parser which opens the file into an array, does 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 som
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
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
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
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é us
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 (
>
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
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
>
[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 contac
51 matches
Mail list logo
