]
Subject: [PHP-DB] MySQL problem..
Date: Mon, 08 Nov 2004 17:02:53 +
Any body met this error?
Warning: mysql_connect(): Client does not support authentication
protocol requested by server; consider upgrading MySQL client in
/usr/local/apache2/html/poems/browse.php on line 15
--
PHP Database Mailing
Any body met this error?
Warning: mysql_connect(): Client does not support authentication
protocol requested by server; consider upgrading MySQL client in
/usr/local/apache2/html/poems/browse.php on line 15
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
-DB] MySQL problem..
Date: Mon, 08 Nov 2004 17:02:53 +
Any body met this error?
Warning: mysql_connect(): Client does not support authentication
protocol requested by server; consider upgrading MySQL client in
/usr/local/apache2/html/poems/browse.php on line 15
--
PHP Database Mailing List (http
ian wrote:
Any body met this error?
Warning: mysql_connect(): Client does not support authentication
protocol requested by server; consider upgrading MySQL client in
/usr/local/apache2/html/poems/browse.php on line 15
http://dev.mysql.com/doc/mysql/en/Old_client.html
--
PHP Database Mailing List
[EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MySQL problem..
Date: Mon, 08 Nov 2004 17:02:53 +
Any body met this error?
Warning: mysql_connect(): Client does not support authentication
protocol requested by server; consider upgrading MySQL client
hi gang
I'm working on optimizing the SQL for my forum system, but have run into a
problem trying to optimize the function for deleting a thread with
accompanying stats data and posts from the database using 1 query.
The current function, that works, looks like this:
// delete all traces of a
If the threadID column is an int, you don't need to wrap the $threadID
variable in quotes.
HTH ~randy
On Tue, 14 Sep 2004 00:05:56 +0200, -{ Rene Brehmer }-
[EMAIL PROTECTED] wrote:
hi gang
I'm working on optimizing the SQL for my forum system, but have run into a
problem trying to optimize
In article [EMAIL PROTECTED], [EMAIL PROTECTED]
says...
Hello Mark,
I have tryed it by splitting the file into pices and then insert it with the
help of phpmyadmin. This woked.
however, I do have some more files to upload, and this seems to be not the
fastest way:-)
I tryed this:
You could use mysqlimport with --fields-terminated-by=;
or you could open it in something like Excel, parse it there (text to
columns), and save it as a CSV
or you could read it line by, line into PHP, explode each line on the
;, then insert the data into MySQL
or you could write a
Hi there,
I have a data file with data seperated by semicolons. It is about 8MB big.
Now I just want to import it into mysql.
I tryed several things. First I took phpmyadmin, which resulted in a white
page without error msg. Then I tryed it by hand with load data. This did not
work as well. No I
Thanks for all the help everyone sent me on this. However, nothing seems to
make any difference whatsoever (except putting the 'localhost' part in
quotes). I am still getting permission denied errors based on the user
credentials.
I have entered a user into the user table with host='localhost',
On Fri, 14 Feb 2003 11:30:03 +0200
[EMAIL PROTECTED] (Evan Morris) wrote:
Thanks for all the help everyone sent me on this. However, nothing
seems to make any difference whatsoever (except putting the
'localhost' part in quotes). I am still getting permission denied
errors based on the user
Hi all
I am new to PHP (just basically started yesterday). I am currently having a
problem connecting to a MySQL database.
My sample code is:
--
?php
mysql_connect(localhost,username,password) or die (Unable to connect to
MySQL server.);
$db =
PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 13 February 2003 13:20
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MySQL problem -- new to PHP
Hi all
I am new to PHP (just basically started yesterday). I am currently having a
problem connecting to a MySQL database.
My sample code
:[EMAIL PROTECTED]]
Sent: 13 February 2003 14:01
To: Clarkson, Nick
Subject: Re: [PHP-DB] MySQL problem -- new to PHP
Well you opened up my question! Do you know where to learn PHPMyAdmin?
Thanks in advance,
Mark
Clarkson, Nick wrote:
Looks like is to do with MySQL permissions. Check your host's
: Thursday, February 13, 2003 7:20 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MySQL problem -- new to PHP
Hi all
I am new to PHP (just basically started yesterday). I am currently having a
problem connecting to a MySQL database.
My sample code is:
--
?php
When changing/adding permissions to the mysql db for specific users,
dont forget to do 'flush privileges'...
my 2 cents
On Thu, 2003-02-13 at 07:19, Evan Morris wrote:
Hi all
I am new to PHP (just basically started yesterday). I am currently having a
problem connecting to a MySQL database.
Hi!
I'm trying to connect to my mysql database using something like
mysql_connect( 'localhost', 'root', 'thepassword' )
or die ( 'Unable to connect to server.' );
But I get the error message:
Fatal error: Call to undefined function: mysql_connect() in
Hello all! I am new to php and I am trying to update a mySQL table using
php v4.2.3 for Windows. I am using the command:
mysql_query(insert into tblquotehits
(qoption,referer,browser,remoteaddr,dt) values
($quotetype,$referer,$browser,$remoteaddress,$currentdtstring),$db);
I have read the
22:56
To: [EMAIL PROTECTED]
Subject: [PHP-DB] mysql problem
Hello all! I am new to php and I am trying to update a mySQL table using
php v4.2.3 for Windows. I am using the command:
mysql_query(insert into tblquotehits
(qoption,referer,browser,remoteaddr,dt) values
($quotetype,$referer,$browser
PROTECTED]
Subject: [PHP-DB] mysql problem
Hello all! I am new to php and I am trying to update a mySQL table
using
php v4.2.3 for Windows. I am using the command:
mysql_query(insert into tblquotehits
(qoption,referer,browser,remoteaddr,dt) values
($quotetype,$referer,$browser,$remoteaddress
Hi,
I have a problem with an MySQL statement that is driving me mad, I'm using php to
connect to the database. this is it : -
SELECT LINE,SUM(IF(MONTH=2,WB.TEU,0)) AS '2' ,SUM(IF(MONTH=3,WB.TEU,0)) AS '3'
,SUM(IF(MONTH=4,WB.TEU,0)) AS '4' ,SUM(IF(MONTH=5,WB.TEU,0)) AS '5'
Maybe I'm missing something - but the MySQL statement looks right ...
How are you displaying the results?
-Original Message-
From: Griffiths, Daniel [mailto:[EMAIL PROTECTED]]
Sent: 21 November 2002 16:37
To: PHP List
Subject: [PHP-DB] MySQL Problem
Hi,
I have a problem with an MySQL
: 21 November 2002 16:41
To: Griffiths, Daniel; PHP List
Subject: RE: [PHP-DB] MySQL Problem
Maybe I'm missing something - but the MySQL statement looks right ...
How are you displaying the results?
-Original Message-
From: Griffiths, Daniel [mailto:[EMAIL PROTECTED]]
Sent: 21 November
Still think we need to see the PHP code before determining that it is an SQL
problem.
Regards,
J
-Original Message-
From: Jason Wong [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 21, 2002 11:55 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] MySQL Problem
On Friday 22 November
the month starts at 1, at the moment I'm just hard coding the month into the statment.
-Original Message-
From: Jason Wong [mailto:[EMAIL PROTECTED]]
Sent: 21 November 2002 16:55
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] MySQL Problem
On Friday 22 November 2002 00:46, Griffiths
Hi People.
I need import some data from a Paradox table, i used the script below, it worked just
fine..but all the data was imported without the ç or á or é , understand???
portuguese words all this changes to some wierd caracter is there a way to fix
this, since my table is
Woo-hoo! Fixing the extensions directory worked. I am now all set with MySQL
support ... Thanks for all the help!
--
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
On Saturday 08 June 2002 05:29, Garrett Nelson wrote:
I now downloaded php-mysql-4.1.2-1a.ppc.rpm from rpmfinder, and again I
get
rpm -ivh php-mysql*
Preparing...###
[100%]
package php-mysql-4.1.2-1a is already installed
(Same error
On Saturday 08 June 2002 23:20, Garrett Nelson wrote:
I have both the lines in httpd.conf. As I said, PHP is working fine, it's
just an issue with MySQL support I believe.
Sorry my mistake. Check in php.ini for this line:
extension=mysql.so
--
Jason Wong - Gremlins Associates -
On Sunday 09 June 2002 01:28, Garrett Nelson wrote:
Well, we're getting closer now, maybe. I added the line extension=mysql.so,
and I still get the same error when trying to run the web-based PHP apps,
but in the command line when I type php I get back,
PHP Warning: Unable to load dynamic
On 6/6/02 4:48 PM, Jason Wong [EMAIL PROTECTED] wrote:
On Friday 07 June 2002 04:36, Garrett Nelson wrote:
I'm a relative newbie to the Linux/web server world, having worked with
Macs most of my life. I recently installed the Server install of Yellow Dog
Linux, with no window managers, CLI
I'm a relative newbie to the Linux/web server world, having worked with Macs
most of my life. I recently installed the Server install of Yellow Dog
Linux, with no window managers, CLI only. Everything is working pretty much
correctly, except PHP interaction with MySQL. When I tried to install
on 6/6/02 4:36 PM, Garrett Nelson at [EMAIL PROTECTED] appended the
following bits to my mbox:
What needs to be configured? I was under the impression that MySQL support
was built into PHP now and that it needs no extension. I downloaded the RPM
of PHP 4.1.2 (the latest PPC RPM available at
Hi, i've a problem with MySQL in my PHP pages. My PHP version is 4.0.1 i think. it's
been installed with Redhat Linux 7.2 with default MySQL support. (I've verified it).
when i want to connect to my sample MySQL database, it give me error :
Call to undifined function
, May 21, 2002 8:49 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MySQL Problem
Hi, i've a problem with MySQL in my PHP pages. My PHP version is 4.0.1 i
think. it's been installed with Redhat Linux 7.2 with default MySQL support.
(I've verified it). when i want to connect to my sample MySQL database
I keep on getting this error statement:
Warning: Supplied argument is not a valid MySQL result resource in
/usr/local/www/data/phone/insert2.php on line 10
2
Can someone tell me what is wrong with the code below, I just cannot figure
it out... Thank you very much in advance. I am using php4.
On Fri, 2002-02-22 at 09:37, Caleb Walker wrote:
I keep on getting this error statement:
Warning: Supplied argument is not a valid MySQL result resource in
/usr/local/www/data/phone/insert2.php on line 10
2
Can someone tell me what is wrong with the code below, I just cannot figure
it
I did change the id fields from TINYINT to INT (that was just a careless
error), and fixed something else. But I still have the same problems. The
new table schemas are below, along with the queries that don't work.
I'd love for someone to reproduce the error. As a possible workaround,
("DocCountry", "INSERT INTO files (idProject, name,
comment) VALUES (0, 'sysmsg9.txt', 'Some file')");
}
else echo("Connection failed");
-Mensagem Original-
De: Chris [EMAIL PROTECTED]
Para: [EMAIL PROTECTED]
Enviada em: tera-feira, 6 de maro de 2001 16:13
Assunto: R
Have you put an echo with mysql_error() after performing each query ?
Jayme.
-Mensagem Original-
De: Chris [EMAIL PROTECTED]
Para: [EMAIL PROTECTED]
Enviada em: segunda-feira, 5 de maro de 2001 05:04
Assunto: [PHP-DB] MySQL - Problem with multiple INSERTs?
Howdy,
I'm getting weird
Howdy,
I'm getting weird problems trying to INSERT to two different tables, in
consecutive mysql_queries. Before, I had 3 queries going, and only 2 would
work at any time. It seemed like it was 'rotating' the bad query - first
the 1st query would fail (the other two were fine), then I'd empty
42 matches
Mail list logo