[PHP-DB] Mysql_fetch_array

2004-09-30 Thread Yemi Obembe
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

Re: [PHP-DB] Mysql_fetch_array

2004-09-30 Thread Brian
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():

RE: [PHP-DB] Mysql_fetch_array

2004-09-30 Thread Ryan Jameson \(USA\)
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

[PHP-DB] mysql_fetch_array issues.

2003-07-09 Thread Greg Hetrick
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

Re: [PHP-DB] mysql_fetch_array issues.

2003-07-09 Thread jeffrey_n_Dyke
] net cc: Subject: [PHP-DB] mysql_fetch_array issues

Re: [PHP-DB] mysql_fetch_array issues.

2003-07-09 Thread Terry Riley
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-

Re: [PHP-DB] mysql_fetch_array issues.

2003-07-09 Thread Greg Hetrick
]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

Re: [PHP-DB] mysql_fetch_array issues.

2003-07-09 Thread Greg Hetrick
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

RE: [PHP-DB] mysql_fetch_array issues.

2003-07-09 Thread Gary . Every
. 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

Re: [PHP-DB] mysql_fetch_array issues.

2003-07-09 Thread Greg Hetrick
-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

Re: [PHP-DB] mysql_fetch_array issues.

2003-07-09 Thread Kieu D. Trang
://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

[PHP-DB] mysql_fetch_array

2003-02-25 Thread f.collineau
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)) {

[PHP-DB] mysql_fetch_array and extract() with LEFT SELECT

2003-02-19 Thread Baumgartner Jeffrey
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 .

Re: [PHP-DB] mysql_fetch_array and extract() with LEFT SELECT

2003-02-19 Thread Mark
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

Re: [PHP-DB] mysql_fetch_array() question

2002-11-06 Thread Jason Wong
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

RE: [PHP-DB] mysql_fetch_array() question

2002-11-06 Thread Josh Johnson
-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

2002-11-06 Thread Graeme McLaren
: 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

RE: [PHP-DB] mysql_fetch_array() question

2002-11-06 Thread Josh Johnson
: 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

Re: [PHP-DB] mysql_fetch_array() question

2002-11-06 Thread 1LT John W. Holmes
); 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

RE: [PHP-DB] mysql_fetch_array() question

2002-11-06 Thread Josh Johnson
[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

Re: [PHP-DB] mysql_fetch_array() question

2002-11-06 Thread Ignatius Reilly
] 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

RE: [PHP-DB] mysql_fetch_array() question

2002-11-06 Thread Josh Johnson
'; '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

[PHP-DB] mysql_fetch_array() question

2002-11-04 Thread Graeme McLaren
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

[PHP-DB] mysql_fetch_array limit? - more details

2002-07-30 Thread Paul Worthington
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.

Re: [PHP-DB] mysql_fetch_array limit? - more details

2002-07-30 Thread Andrey Hristov
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

Re: [PHP-DB] mysql_fetch_array limit? - more details

2002-07-30 Thread Paul Worthington
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

Re: [PHP-DB] mysql_fetch_array limit? - more details

2002-07-30 Thread Andrey Hristov
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

Re: [PHP-DB] mysql_fetch_array limit? - more details

2002-07-30 Thread Paul Worthington
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.

Re: [PHP-DB] mysql_fetch_array limit? - more details

2002-07-30 Thread Rasmus Lerdorf
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

Re: [PHP-DB] mysql_fetch_array limit? - more details

2002-07-30 Thread Andrey Hristov
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

Re: [PHP-DB] mysql_fetch_array limit? - more details

2002-07-30 Thread Rasmus Lerdorf
: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

Re: [PHP-DB] mysql_fetch_array limit? - more details

2002-07-30 Thread Andrey Hristov
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

RE: [PHP-DB] mysql_fetch_array limit? - more details

2002-07-30 Thread Roedel, Mark A.
-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

Re: [PHP-DB] mysql_fetch_array limit? - more details

2002-07-30 Thread Kodrik
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.

RE: [PHP-DB] mysql_fetch_array limit? - more details

2002-07-30 Thread Hutchins, Richard
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

Re: [PHP-DB] mysql_fetch_array limit? - more details

2002-07-30 Thread Paul Burney
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:

Re: [PHP-DB] mysql_fetch_array limit? - more details

2002-07-30 Thread Paul Worthington
. 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

Re: [PHP-DB] mysql_fetch_array limit? - more details

2002-07-30 Thread Paul Worthington
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

Re: [PHP-DB] mysql_fetch_array limit? - more details

2002-07-30 Thread Paul Worthington
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

Re: [PHP-DB] mysql_fetch_array limit? - more details

2002-07-30 Thread Paul Worthington
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

Re: [PHP-DB] mysql_fetch_array() doesn't work

2001-09-27 Thread Jason G.
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

RE: [PHP-DB] mysql_fetch_array() doesn't work

2001-09-27 Thread Rick Emery
()); //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

[PHP-DB] mysql_fetch_array() doesn't work

2001-09-26 Thread Web user
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

RE: [PHP-DB] mysql_fetch_array() doesn't work

2001-09-26 Thread Dave Watkinson
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

[PHP-DB] mysql_fetch_array() doesn't work

2001-09-25 Thread Web user
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

[PHP-DB] mysql_fetch_array missing first record

2001-08-07 Thread Jamie
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.

Re: [PHP-DB] mysql_fetch_array missing first record

2001-08-07 Thread Paul Burney
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

Re: [PHP-DB] mysql_fetch_array missing first record

2001-08-07 Thread Paul DuBois
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

Re: [PHP-DB] mysql_fetch_array missing first record

2001-08-07 Thread Jamie Saunders
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

[PHP-DB] mysql_fetch_array problem

2001-07-09 Thread BrianSander
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

Re: [PHP-DB] mysql_fetch_array problem

2001-07-09 Thread bleythbe
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 =

[PHP-DB] mysql_fetch_array problem...!

2001-03-05 Thread Trond Erling Hundal
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

Re: [PHP-DB] mysql_fetch_array problem...!

2001-03-05 Thread Darryl Friesen
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_

Re: [PHP-DB] mysql_fetch_array problem...!

2001-03-05 Thread JJeffman
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