TECTED]
Sent: Thursday, September 30, 2004 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
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_arr
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
> >
> >
> > Gary Every
> > Sr. UNIX Administrator
> > Ingram Entertainment
> > (615) 287-4876
> > "Pay It Forward"
> > mailto:[EMAIL PROTECTED]
> > http://accessingram.com
> >
> >
> > > -Original Message-
> &
ram 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: [E
ne. 99% of the time, this error
> means your query
> > failed. if it works on another serverare the fields
> the same, the
> > dbname, the tablename?
> >
> > hth
> > jeff
> >
> >
> >
> > "Greg He
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
h
> jeff
>
>
>
> "Greg Hetrick"
> <[EMAIL PROTECTED]To:
[EMAIL PROTECTED]
> 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-
[EMAIL PROTECTED]
net> cc:
Subject: [PHP-DB]
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
Hi,
Here is my code:
Setup("user","user","localhost");
$sql->connexion("materiel");
$sql->Query("select nom from personne");
$cpt=0;
while($row=mysql_fetch_array($sql->result))
{
print($cpt);
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 id,LE
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 "" . $id . ": " . $flu
olmes'; '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_f
PROTECTED]>; "'Graeme McLaren'"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
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 respect
[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
etch_array($r2);
print_r($row1);
echo "";
print_r($row2);
---John Holmes...
- Original Message -
From: "Josh Johnson" <[EMAIL PROTECTED]>
To: "'Graeme McLaren'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, November 06, 2
riginal Message-
From: 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
ent: Wednesday, November 06, 2002 12:29 PM
Subject: 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
itely recommend restructuring your talbes as Jason suggested.
-- Josh
-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:4
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
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 th
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 me
> From: Paul Worthington [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, July 30, 2002 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
in message
> > > > 01cd01c237e8$7e1438b0$1601a8c0@nik">news:01cd01c237e8$7e1438b0$1601a8c0@nik...
> > > > > Maybe it will help you but I've read that when using persistent
> > > > connections
> > > > > PHP uses 2 on every request.
&
lp me.
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]
> Subje
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:
> ...
many times have 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_fe
01a8c0@nik...
> > 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]>
> >
> -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 characte
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
S
: "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?
onnections parameter from 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]>
Sen
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
Admin 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
>
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
o if in one moment you have 10 scripts,that use persistent connections,
> running you will have 20 connections used to the mysql.
>
> Regards,
> Andrey
> - Original Message -
> From: "Paul Worthington" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]&g
"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 10.1.5.
>
> In my table, I've got two fields: Nam
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.
contents of $query
$res=mysql_query($query) or die(mysql_error()); //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 W
echo "
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 this:
$sContent"); ?>
Try this:
Or even this:
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 + Apac
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
group\apache\htdocs\web\
System: PHP4.06 + Mysql3.23.41 Win32 + Apache 1.3.20 Win32 + Win98
http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
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 ($pr
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.
Th
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
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.
Ja
mysql_fetch_array places 2 records for each one returned (example)
Array
(
[0] => 56
[location_id] => 56
)
Is there any way to delimate that and have the key present only once?
here is my code :
/*
*
*
* Start code
*
*
*/
while ($aRow = mysql_fetch_array($sResult) ) {
I was having the same problem for a while... although, I
was using this:
for($i=0;$i
Good luck,
Ben
Quoting BrianSander <[EMAIL PROTECTED]>:
> Greetings,
>
> I'm experiencing the strangest problem and I was
> wondering if anyone
> else has had the same problem.
>
> I have a fairly simple scr
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
s.
HTH.
Jayme.
-Mensagem Original-
De: Trond Erling Hundal <[EMAIL PROTECTED]>
Para: PHP-DB-LIST <[EMAIL PROTECTED]>
Enviada em: segunda-feira, 5 de março de 2001 09:56
Assunto: [PHP-DB] mysql_fetch_array problem...!
> I want to run a query to my db, fetching diffe
> 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 r
elism
eBusiness Infrastructure Technology
http://www.openlinksw.com
> -Original Message-
> From: Trond Erling Hundal [mailto:[EMAIL PROTECTED]]
> Sent: Monday, March 05, 2001 7:56 AM
> To: PHP-DB-LIST
> Subject: [PHP-DB] mysql_fetch_array problem...!
>
>
> I want to r
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 r
56 matches
Mail list logo
