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.
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 mysql_connec
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
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'
,SUM(IF(MONTH=6,WB.T
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 doc
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: http://www.php.n
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
, 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 MyS
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
Sent: 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: 2
On Friday 22 November 2002 00:46, Griffiths, Daniel wrote:
> the statement runs without errors, its just the output thats wrong (see the
> two tables) I'm displaying the results by doing a simple dump of the query,
> through my own code and have also tried through phpMyAdmin.
Not sure if this coul
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, Grif
l Arbuckle, Jr. [mailto:[EMAIL PROTECTED]]
Sent: 28 November 2002 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
(q
:56 PM
> 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,remot
ubject: [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 Mailin
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 (h
; Bastien
>
> >From: ian <[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(): Cli
ED]>
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 in
/usr/local/apache2/ht
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
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
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
/home/daniel/public_html/index.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:
--
---
This throws the following error:
---
Warning: My
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:
mysql> LOAD DATA INFILE 'Hotel_Description.txt'INTO TABLE
test.hot
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
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 script tha
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
Invi
Addressed to: Chris <[EMAIL PROTECTED]>
[EMAIL PROTECTED]
** Reply to note from Chris <[EMAIL PROTECTED]> Mon, 05 Mar 2001 02:04:28 -0600
The first thing that jumps out is using tinyint for keys. Are you sure
there will never be more than 127 entries in the table?
I usually use b
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 março de 2001 05:04
Assunto: [PHP-DB] MySQL - Problem with multiple INSERTs?
>
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,
everyth
;
mysql_db_query("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]>
En
--
From: [EMAIL 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
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:
--
---
This throws the foll
k Loewenberg [mailto:[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 permiss
TED]]
Sent: 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 samp
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 databa
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', us
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 use
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
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 only. Everything is working pretty much
> correctly, exc
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 manag
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
>
> (
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.
On 6/8/02 2:24 AM, "Jason Wong" <[EMAIL PROTECTED]> wrote:
> On Saturday 08 June 2002 05:29, Garrett Nelson wrote:
>> I now downloaded "php-mysql-4.1.2-1a.ppc.rpm" from rpmfinde
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 -> www.greml
On 6/8/02 12:07 PM, "Jason Wong" <[EMAIL PROTECTED]> wrote:
> 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:
>
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 d
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
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 th
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 opt
49 matches
Mail list logo