Does anyone have an idea what may probably be the cause of this error:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource
in /var/www/ng/mailsender2.php on line 17
-
A passion till tomorrow,
www.opeyemi.tk
Yup, we're mind readers, I can figure out your entire script and
database structure from the error message.
On Thu, 30 Sep 2004 13:30:25 -0700 (PDT), Yemi Obembe
[EMAIL PROTECTED] wrote:
Does anyone have an idea what may probably be the cause of this error:
Warning: mysql_fetch_array():
2:30 PM
To: [EMAIL PROTECTED]
Subject: *** Detected as Spam ***[PHP-DB] Mysql_fetch_array
Does anyone have an idea what may probably be the cause of this error:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL
result resource in /var/www/ng/mailsender2.php on line 17
I am getting the following error when attempting to pull data out of a mysql
DB
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result
resource in /home/pffl/public_html/pffl/webpage/html/dataentry.php on line
125
I can take this same code to a different web server and it is
]
net cc:
Subject: [PHP-DB] mysql_fetch_array
issues
As far as I know, that error means that the query that was supposed to
produce $result did not run because of errors in the SQL (or the
database).
Suggest you check your query in myPHPAdmin or MySQLfront or whatever to be
sure that it has no errors.
Terry
--Original Message-
]To:
[EMAIL PROTECTED]
net cc:
Subject: [PHP-DB]
mysql_fetch_array issues.
07/09/2003 12:04
PM
I am getting the following error when attempting to pull
Query is correct appears to be a problem connecting to the db -- I can
comment out the mysql_select line and I get no change.
Terry Riley [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
As far as I know, that error means that the query that was supposed to
produce $result did not run
. UNIX Administrator
Ingram Entertainment
(615) 287-4876
Pay It Forward
mailto:[EMAIL PROTECTED]
http://accessingram.com
-Original Message-
From: Greg Hetrick [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 09, 2003 12:31 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] mysql_fetch_array
-Original Message-
From: Greg Hetrick [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 09, 2003 12:31 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] mysql_fetch_array issues.
I do not have the die statment -- the DB is the same except
the name and I
have double checked that I
://accessingram.com
-Original Message-
From: Greg Hetrick [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 09, 2003 12:31 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] mysql_fetch_array issues.
I do not have the die statment -- the DB is the same except
the name and I
have
Hi,
Here is my code:
?
require(util.php);
$sql= new MySQL_class;
$sql-Setup(user,user,localhost);
$sql-connexion(materiel);
$sql-Query(select nom from personne);
$cpt=0;
while($row=mysql_fetch_array($sql-result))
{
I'm having a problem when I use mysql_fetch_array and extract() following a
left select query. As an example...
$query = SELECT id,LEFT(fluff,80) FROM sometable;
$result = mysql_query($query) or die('message');
while ($row = mysql_fetch_array($result){
extract($row);
echo P . $id . : . $fluff .
Try SELECT id,LEFT(fluff,80) as fluffy FROM sometable
Then extract() will have a value for fluffy
--- Baumgartner Jeffrey [EMAIL PROTECTED] wrote:
I'm having a problem when I use mysql_fetch_array and extract()
following a
left select query. As an example...
$query = SELECT
On Tuesday 05 November 2002 05:47, Graeme McLaren wrote:
Hi, Anyone know how I can use two mysql_fetch_array() functions similar
to the code below? I've tried a few different ways but I keep getting
Resource ID #4. I need to do this to retrieve an email address from one
table and retrieve
-Original Message-
From: Jason Wong [mailto:phplist;gremlins.com.hk]
Sent: Wednesday, November 06, 2002 5:24 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] mysql_fetch_array() question
On Tuesday 05 November 2002 05:47, Graeme McLaren wrote:
Hi, Anyone know how I can use two
: RE: [PHP-DB] mysql_fetch_array() question
I concur with Jason, but if restructuring is out of the question, just
rearrange your queries like this:
$query = SELECT Name, Address FROM users;
$result = mysql_query($query);
while($details = mysql_fetch_array($result)){
echo Name: $details
: Graeme McLaren [mailto:mickel;ntlworld.com]
Sent: Wednesday, November 06, 2002 12:17 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] mysql_fetch_array() question
Josh, Thank you for reply. Thank you to everyone else who replied to my
email also. I solved the problem shortly after posting my question
);
echo brhr;
print_r($row2);
---John Holmes...
- Original Message -
From: Josh Johnson [EMAIL PROTECTED]
To: 'Graeme McLaren' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, November 06, 2002 1:02 PM
Subject: RE: [PHP-DB] mysql_fetch_array() question
In my experience, (I haven't
[mailto:holmes072000;charter.net]
Sent: Wednesday, November 06, 2002 1:21 PM
To: Josh Johnson; 'Graeme McLaren'; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] mysql_fetch_array() question
That's not true. You can assign them to different variables and it works
fine.
$r1 = mysql_query(select * from main limit 1
]
Sent: Wednesday, November 06, 2002 7:24 PM
Subject: RE: [PHP-DB] mysql_fetch_array() question
:) see why I love mailing lists! :)
It must have been their logic then, I respectfully retract everything I
said, sorry Graeme! Why do I have to work, I could spend my days
researching this stuff
'; 'Graeme McLaren';
[EMAIL PROTECTED]
Subject: Re: [PHP-DB] mysql_fetch_array() question
John is right. In fact one routinely calls two different $result(s) when
coding nested loops:
while( $details = mysql_fetch_array( $result ) ) {
while ( $Email = mysql_fetch_array( $result2
Hi, Anyone know how I can use two mysql_fetch_array() functions similar
to the code below? I've tried a few different ways but I keep getting
Resource ID #4. I need to do this to retrieve an email address from one
table and retrieve details from another.
Cheers for any tips - I'm stumped with
I'm running MySQL 3.23.47 and PHP 4.1.2 on Mac OS X 10.1.5.
In my table, I've got two fields: Name VARCHAR(35) and txtSWDesc1 TEXT.
According to the manual, TEXT will give me a maximum space of 65,536
bytes per field. I've entered text in this field in the amount of
approximately
500 characters.
Worthington [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, July 30, 2002 5:34 PM
Subject: [PHP-DB] mysql_fetch_array limit? - more details
I'm running MySQL 3.23.47 and PHP 4.1.2 on Mac OS X 10.1.5.
In my table, I've got two fields: Name VARCHAR(35) and txtSWDesc1 TEXT.
According
rsistent connections,
running you will have 20 connections used to the mysql.
Regards,
Andrey
- Original Message -
From: Paul Worthington [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, July 30, 2002 5:34 PM
Subject: [PHP-DB] mysql_fetch_array limit? - more details
I'm runni
Do you have PhpMyAdmin installed? If you have try with it to see the
results. It uses native mysql functions.
Andrey
- Original Message -
From: Paul Worthington [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, July 30, 2002 7:53 PM
Subject: Re: [PHP-DB] mysql_fetch_array limit
have try with it to see the
results. It uses native mysql functions.
Andrey
- Original Message -
From: Paul Worthington [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, July 30, 2002 7:53 PM
Subject: Re: [PHP-DB] mysql_fetch_array limit? - more details
Thank you for that idea.
connections used to the mysql.
Regards,
Andrey
- Original Message -
From: Paul Worthington [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, July 30, 2002 5:34 PM
Subject: [PHP-DB] mysql_fetch_array limit? - more details
I'm running MySQL 3.23.47 and PHP 4.1.2 on Mac OS X
the
default of 100.
[/snip]
Andrey
- Original Message -
From: Rasmus Lerdorf [EMAIL PROTECTED]
To: Andrey Hristov [EMAIL PROTECTED]
Cc: Paul Worthington [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, July 30, 2002 7:59 PM
Subject: Re: [PHP-DB] mysql_fetch_array limit? - more details
:59 PM
Subject: Re: [PHP-DB] mysql_fetch_array limit? - more details
What do you mean it uses 2? It does not.
On Tue, 30 Jul 2002, Andrey Hristov wrote:
Maybe it will help you but I've read that when using persistent
connections
PHP uses 2 on every request.
So if in one moment
Yeaah!
I am a fool. My biggest excuses.
Sorry Rasmus and everyone else.
Andrey
- Original Message -
From: Rasmus Lerdorf [EMAIL PROTECTED]
To: Andrey Hristov [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, July 30, 2002 8:11 PM
Subject: Re: [PHP-DB] mysql_fetch_array limit
-Original Message-
From: Paul Worthington [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 30, 2002 9:34 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] mysql_fetch_array limit? - more details
What happens is I'm only getting the first 256 characters of
txtSWDesc1 displayed in my
t to see the
results. It uses native mysql functions.
Andrey
- Original Message -
From: Paul Worthington [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, July 30, 2002 7:53 PM
Subject: Re: [PHP-DB] mysql_fetch_array limit? - more details
Thank you for that idea.
you been nagged for something stupid like forgetting the
; at the end of a query or PHP statement?
Just a thought.
-Original Message-
From: Paul Worthington [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 30, 2002 10:34 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] mysql_fetch_array limit
on 7/30/02 10:34 AM, Paul Worthington at [EMAIL PROTECTED] appended the
following bits to my mbox:
I'm using this PHP code, very simple and straightforward, to select two
columns into an array and then display the results in an HTML table:
.
Paul
Mark A. Roedel [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
-Original Message-
From: Paul Worthington [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 30, 2002 9:34 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] mysql_fetch_array limit? - more
results. It uses native mysql functions.
Andrey
- Original Message -
From: Paul Worthington [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, July 30, 2002 7:53 PM
Subject: Re: [PHP-DB] mysql_fetch_array limit? - more details
Thank you for that idea. I do
10:34 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] mysql_fetch_array limit? - more details
I'm running MySQL 3.23.47 and PHP 4.1.2 on Mac OS X 10.1.5.
In my table, I've got two fields: Name VARCHAR(35) and txtSWDesc1 TEXT.
According to the manual, TEXT will give me a maximum space of 65,536
b
Thanks for all your helpful suggestions. It turns out I was limiting the
array myself by setting a temporary table column definition to varchar(255).
I have been overlooking it all this time. I feel so stupid. Thanks again for
trying to help me.
Paul
Paul Burney [EMAIL PROTECTED] wrote in
echo a href='$PHP_SELF?offset=$i*$step' target='_top'
Missing end quote and semicolon on this line may be the reason...
Try properly indenting and formatting your code. Also take advantage of
going in and out of php mode to seperate your code from your display of
content...
Ex:
instead of
()); //note the die() clause
-Original Message-
From: Web user [mailto:[EMAIL PROTECTED]]
Sent: 27 September 2001 05:48
To: [EMAIL PROTECTED]
Subject: [PHP-DB] mysql_fetch_array() doesn't work
System: PHP4.06 + Mysql3.23.41 Win32 + Apache 1.3.20 Win32 + Win98
When PHP is running
System: PHP4.06 + Mysql3.23.41 Win32 + Apache 1.3.20 Win32 + Win98
When PHP is running at the line: $arr=mysql_fetch_array($res);
The IE always show info as below:
Parse error: parse error, expecting `T_STRING' or `T_VARIABLE' or
`T_NUM_STRING' in c:\program files\apache
that's not a mysql_fetch_array() error it's a coding error
-Original Message-
From: Web user [mailto:[EMAIL PROTECTED]]
Sent: 27 September 2001 05:48
To: [EMAIL PROTECTED]
Subject: [PHP-DB] mysql_fetch_array() doesn't work
System: PHP4.06 + Mysql3.23.41 Win32 + Apache 1.3.20 Win32
System: PHP4.06 + Mysql3.23.41 Win32 + Apache 1.3.20 Win32 + Win98
?
..
..
$res=mysql_query($query);
$num=mysql_num_rows($res);
for($i=0; $i$num; $i++){
$arr=mysql_fetch_array($res);
...
}
...
When PHP is running at the line: $arr=mysql_fetch_array($res);
The IE always show info as
Hi,
I have this code to display records from a table by reading them into an
array:
while ($previews = mysql_fetch_array($result) {
code to display record here...
}
For some reason it refuses to display the very first record in the table.
Why is this and how can I get round it?
Thanks.
on 8/7/01 1:41 PM, Jamie ([EMAIL PROTECTED]) wrote:
while ($previews = mysql_fetch_array($result) {
code to display record here...
}
For some reason it refuses to display the very first record in the table.
Why is this and how can I get round it?
Are you calling mysql_fetch_array
At 9:41 PM +0100 8/7/01, Jamie wrote:
Hi,
I have this code to display records from a table by reading them into an
array:
while ($previews = mysql_fetch_array($result) {
code to display record here...
}
For some reason it refuses to display the very first record in the table.
The first
This was indeed the problem, I was calling the mysql_fetch_array earlier in
the code.
Once removed it worked fine.
Thanks.
Jamie
Paul Burney [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
on 8/7/01 1:41 PM, Jamie ([EMAIL PROTECTED]) wrote:
while ($previews
Greetings,
I'm experiencing the strangest problem and I was wondering if anyone
else has had the same problem.
I have a fairly simple script setup that queries a mySQL database and
displays the records in a HTML table. Everything works fine except it
keeps omitting the first record. Running the
I was having the same problem for a while... although, I
was using this:
for($i=0;$imysql_num_rows($result);$i++)
doStuffTo(mysql_result($result, $i, foo);
If I remember correctly... it has to do with zero-based
indexing versus 1-based indexing. Now... I think I
fixed it by using =
I want to run a query to my db, fetching different fields from three
different tables.
In order to recognise the individual fields I give them names:
select portal.portal as portal, portal.portalid as id... etc etc
How can I refer to one specific row in this query..?
What I mean is, how can i
How can I refer to one specific row in this query..?
What I mean is, how can i refer to result row number 4...?
If I only selected rows from one table I could do something like this:
$i = mysql_fetch_array($sql) ;
echo "$i[4]" ;
Actually, no. mysql_fetch_array return the _current row_
TH.
Jayme.
-Mensagem Original-
De: Trond Erling Hundal [EMAIL PROTECTED]
Para: PHP-DB-LIST [EMAIL PROTECTED]
Enviada em: segunda-feira, 5 de maro de 2001 09:56
Assunto: [PHP-DB] mysql_fetch_array problem...!
I want to run a query to my db, fetching different fields from three
different ta
54 matches
Mail list logo