l1.field3
hth,
Yves
- Original Message -
From: "Yves Sucaet"
To:
Sent: Tuesday, January 13, 2009 7:49 AM
Subject: Re: [PHP-DB] help me JOIN 3 tables.
Hi Joseph,
With the sum() aggregate function you'll need to use a GROUP BY clause and
specify which field
Hi Joseph,
With the sum() aggregate function you'll need to use a GROUP BY clause and
specify which fields you want from e1 and l1. Something like this:
SELECT e1.field1, e1.field2, l1.field3, SUM(a1.adp_amount) as amount
FROM a1 inner join e1 on (a1.loanID = a1.adp_loanID) inner join l1 on
(
Bastien Koert wrote:
have you created a dsn for this connection?
Bastien
From: Petrus Ali Saputra <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Help me please
Date: Mon, 08 Nov 2004 10:55:45 +0700
Can anyone here help me how to connect to an ODBC data?
Here is my code: $odbc = odbc_co
Arné klopper wrote:
Have you set up a ODBC connection ?
You must set up a ODBC connection in the ODBC Sources that is usually in you Control Panel or Administrator Tools.
You must put it as a System DNS and set up the connection, so your local system know where to find the database.
I already
have you created a dsn for this connection?
Bastien
From: Petrus Ali Saputra <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Help me please
Date: Mon, 08 Nov 2004 10:55:45 +0700
Can anyone here help me how to connect to an ODBC data?
Here is my code: $odbc = odbc_connect("Ta Fara","",""
Have you set up a ODBC connection ?
You must set up a ODBC connection in the ODBC Sources that is usually in you
Control Panel or Administrator Tools.
You must put it as a System DNS and set up the connection, so your local system
know where to find the database.
Kind Regards
Arné K
there are a million sample php script in links...
http://www.php.net
"muhammad_wahyu"
when using start_session
the code tries to write a file to the tmp dir...
think you are working under windows
so make in c: a \tmp dir !!!
then it should work
-Original Message-
From: khac duy [mailto:[EMAIL PROTECTED]]
Sent: vrijdag 10 januari 2003 1:08
To: [EMAIL PROTECTED]
Subjec
Are you running on windows or Linux???
This looks like a Windows problem - you have to set your
"SESSION_SAVE_PATH" in php.ini AND make sure the folder you specify exists
and is accessible to PHP.
HTH,
Richy
==
Richard Black
Senior Developer, DataVisibil
Hello khac,
hmm what platform are you running on? what are PHP settings for
writing sessions? Check out permissions for /tmp directory, check out
free space on disk.
--
Best regards,
Martin mail [EMAIL PROTECTED]
mobile +421.907.30
ginal Message-
From: Tim Foster [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 16, 2001 9:42 AM
To: PHP DB
Subject: RE: [PHP-DB] help me on projecting some tables
A couple of questions:
> INSERT INTO traits VALUES("Added Chemicals",LAST_INSERT_ID(),"Sugar");
1
A couple of questions:
> INSERT INTO traits VALUES("Added Chemicals",LAST_INSERT_ID(),"Sugar");
1. Will LAST_INSERT_ID() work reliably in a multi-user environment? What happens if
you're
in the middle of inserting a dozen records and someone else inserts a record? Does
MySQL
keep the LAST_INS
yep, that first example was roughly what i was getting at, don't think i
explained it anywhere near as well as Rick though.
-Original Message-
From: Rick Emery [mailto:[EMAIL PROTECTED]]
Sent: 16 November 2001 14:17
To: PHP DB
Subject: RE: [PHP-DB] help me on projecting some t
S(NULL,"Bread",1,"each",1.49);
INSERT INTO styles VALUES( "White",LAST_INSERT_ID() );
INSERT INTO styles VALUES( "Black",LAST_INSERT_ID() );
INSERT INTO styles VALUES( "Wheat",LAST_INSERT_ID() );
INSERT INTO styles VALUES( "Hawaiian",LAST_INS
not really sure how to do this, other than planning for as much as you can
in your original tables, then have a spare table with four columns - Row_ID,
Characteristic_Name, Characteristic_Value, and Product_Refer_ID.
so then if you get a new characteristic (eg colour) then you could have
values 1,
> -Original Message-
> From: SOHH.com Webmaster [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 19, 2001 4:45 PM
> To: Mark Roedel
> Cc: [EMAIL PROTECTED]
> Subject: RE: [PHP-DB] Help Me Fix My User Defined Funtion
>
>
> However, since posting my question
t the lenght of it (just an example).
Steven
-Original Message-
From: Mark Roedel [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 19, 2001 11:21 AM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Help Me Fix My User Defined Funtion
> -Original Message-
> From: SOHH.com Webmas
Hello, "Sridhar Ranganathan"!
You wrote:
> What should I do?
>
See the strip_tags() function.
--
Piloteers do it on the road
--
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 a
the way i have attacked a similar situation in the past was to create my
own formatting system - kind of a pseudo-html set-up, which made use of
conventions like;
**bold**
%%italic%%
__underline__
!!titlefont!!
etc etc
then you can save the article directly into the DB, as a text or whatever,
uot;Beau Lebens" <[EMAIL PROTECTED]>
To: "Sridhar Ranganathan" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Thursday, February 01, 2001 5:46 PM
Subject: Re: [PHP-DB] Help Me!
> the way i have attacked a similar situation in the past was to create my
> own f
20 matches
Mail list logo