i get the error:
Warning: mysql_pconnect() [function.mysql-pconnect]: Lost connection to MySQL
server during query in /home/www/broadwaysecure.biz.nf/Index.php on line 9
Could not connect : Lost connection to MySQL server during query
I have done everything to connect to my database but its
I have this SQL
SELECT e1.*, l1.* FROM e1
INNER JOIN l1 WHERE e1.entre_active = 'Y' AND l1.entreID = e1.entre_id
The above query works but i want to add the one below
SELECT SUM(a1.adp_amount) as amount FROM a1 WHERE a1.adp_loanID = e1.loanID;
the last part of the query is to SUM the part
on
(l1.entreID = e1.entre_ID)
WHERE e1.entre_active = 'Y'
hth,
Yves
- Original Message -
From: Abah Joseph joefa...@gmail.com
To: php-db@lists.php.net
Sent: Tuesday, January 13, 2009 6:46 AM
Subject: [PHP-DB] help me JOIN 3 tables.
I have this SQL
SELECT e1.*, l1.* FROM e1
INNER JOIN
hth,
Yves
- Original Message -
From: Yves Sucaet yves.suc...@usa.net
To: php-db@lists.php.net
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
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é
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
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
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
Can anyone here help me how to connect to an ODBC data?
Here is my code: $odbc = odbc_connect(Ta Fara,,);
And this is the result: Warning: odbc_connect(): SQL error:
[Microsoft][ODBC Driver Manager] Data source name not found and no
default driver specified, SQL state IM002 in SQLConnect in
Hi to every one, i have the next problem:
I'm trying to connect to Microsoft SQL Server 6.5 with PHP and Internet
Information Server in Microsoft Windows 2000 Professional, and everything is
ok when i do it via ODBC but i want to include specific functions of SQL
Server that come included with
dear all,
I'm a new user for PHP programing,I'm confused with syntax in those
script.So
I want all of you can help me.friend i need 1.Example of PHP (guest
book,e-commerce,db with PHP,etc)
Thank's all
akhi wahyu
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
[EMAIL PROTECTED]To: [EMAIL PROTECTED]
il.com cc:
Subject: [PHP-DB] help me
i can't use start_secsion(); in php4, it say:
error : can't ofen(\tmp/4363jghsfjkhshga.. like this...
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
: [PHP-DB] help me
10/01/2003
00:07
]
Subject: [PHP-DB] help me
i can't use start_secsion(); in php4, it say:
error : can't ofen(\tmp/4363jghsfjkhshga.. like this...
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi,
Im trying to install PHP 4.1.2 under Windows 2000 Server and IIS 4.0
* If I configure PHP as a MODULE, all run but SESSIONS DON'T WORK
* If I configure PHP as a CGI, SESSIONS WORK but ORACLE MODULE for PHP not
load
Any ideas?
Anybody can help me?
Advanced thanks,
Berli
--
PHP Database
Hi everyone,
Could anyone help me giving a php code that
calculates time required to download a url
(including downloading of images in that particular url).
if you could tell me the site also it would be great helpful
to you people.
Thank You
E.chidmbaram
Hi,
I've to store in a BD some alimentary product, and
there are lot of informations like chemical, physical,
nutritional characteristics , ...
I don't know how to store this info.
So I've a lot of product with a lot of corresponding
characteristics.
I've thought about to create a table where to
Message-
From: Carlo Loiudice [mailto:[EMAIL PROTECTED]]
Sent: 16 November 2001 10:48
To: PHP DB
Subject: [PHP-DB] help me on projecting some tables
Hi,
I've to store in a BD some alimentary product, and
there are lot of informations like chemical, physical,
nutritional characteristics , ...
I don't
,LAST_INSERT_ID() );
-Original Message-
From: matt stewart [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 16, 2001 5:55 AM
To: 'Carlo Loiudice'; PHP DB
Subject: RE: [PHP-DB] help me on projecting some tables
not really sure how to do this, other than planning for as much as you can
in your
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
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. Will LAST_INSERT_ID() work reliably
When i execute the following codes:
?php
$db=dba_open(database.db,c,db2);
?
an error occurs:
Warning: no such handler: db2 in D:\Inetpub\WebSite/dba_test.php on line 2
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands,
Hi Netlanders
I have just undertaken a web site construction project. It is a devshed like
site that serves articles on various topics. I am using LAMP -
Linux/Apache/MySQL/PHP 4. I have a table that contains info about each
article. I think I have three options...(or do I have more that I
25 matches
Mail list logo