Umm, he is putting them into an array, I quote:
while ($row = mysql_fetch_array($result)) {
$row['Books.Title'];
$row['Books.Author'];
$row['Books.ISBN'];
$row['BookList.dbase'];
$row['BookList.dbase_user'];
$row['BoxSet.BoxSet'];
But what do all those $row['fieldname'} rows do? Call me ignorant
(you wouldn't be the first), but a statement that simply has a
variable name doesn't DO anything. Should these have echos in front
of them?
--- Adam Voigt [EMAIL PROTECTED] wrote:
Umm, he is putting them into an array, I quote:
They don't do anything, but my point was, he said that what he pulled
from the DB needed to be put into an array, and I was pointing out, it
already was.
On Wed, 2002-11-27 at 12:23, Mark wrote:
But what do all those $row['fieldname'} rows do? Call me ignorant
(you wouldn't be the first), but a
Hello.
I am using MySQL as a database for a departmental library. I have written
a quick search script, but keep getting resource id #2 as a result to my
search. I have read the online documentation for the
mysql_fetch_array() function and must say, I don't see that I'm missing
anything.
Add: print_r($row)
In your while loop, that will show you everything that is being returned
with both it's numeric and text based position.
On Tue, 2002-11-26 at 13:09, The Cossins Fam wrote:
Hello.
I am using MySQL as a database for a departmental library. I have written
a quick search
-
From: The Cossins Fam [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 26, 2002 1:10 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Resource id #2
Hello.
I am using MySQL as a database for a departmental library. I have written a
quick search script, but keep getting resource id #2
On Wednesday 27 November 2002 02:09, The Cossins Fam wrote:
Hello.
I am using MySQL as a database for a departmental library. I have written
a quick search script, but keep getting resource id #2 as a result to my
search. I have read the online documentation for the
mysql_fetch_array()
Not sure how to over come this, the result of a database query keeps giving
me this:
?php
/* Get Ip address, where they came from, and stamp the time */
if (getenv(HTTP_X_FORWARDED_FOR)){
$ipaddy = getenv(HTTP_X_FORWARDED_FOR);
} else {
$ipaddy = getenv(REMOTE_ADDR); }
$referrer =
started with select sex...)
-Natalie
-Original Message-
From: Jas [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 12, 2002 1:42 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] resource id#2 -
Not sure how to over come this, the result of a database query keeps giving
me this: ?php
/* Get
At 11:42 -0600 6/12/02, Jas wrote:
Not sure how to over come this, the result of a database query keeps giving
me this:
?php
/* Get Ip address, where they came from, and stamp the time */
if (getenv(HTTP_X_FORWARDED_FOR)){
$ipaddy = getenv(HTTP_X_FORWARDED_FOR);
} else {
$ipaddy =
; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] resource id#2 -
At 11:42 -0600 6/12/02, Jas wrote:
Not sure how to over come this, the result of a database query keeps
giving me this: ?php
/* Get Ip address, where they came from, and stamp the time */
if (getenv(HTTP_X_FORWARDED_FOR)){
$ipaddy
Thanks a ton, I was really looking right past that variable.
Jas
Paul Dubois [EMAIL PROTECTED] wrote in message
news:p05111763b92d3addd3b4@[192.168.0.33]...
At 11:42 -0600 6/12/02, Jas wrote:
Not sure how to over come this, the result of a database query keeps
giving
me this:
?php
/* Get
Ok here is my problem, I set this up so a user selects a name form a select
box and that name or $user_id is then passed to this page so the user can
edit the contact info etc. However it does not pull the selected $user_id
and place each field into my form boxes, all I get is a Resource ID #2.
On Thursday 30 May 2002 00:17, Jas wrote:
Ok here is my problem, I set this up so a user selects a name form a select
box and that name or $user_id is then passed to this page so the user can
edit the contact info etc. However it does not pull the selected $user_id
and place each field into
If you look at the previously posted code at the bottom of the form there is
a echo for the sql select statement that is echoing Resource id #2 on the
page. Now that error is the correct field id number in the database, I am
just not sure how to itemize the data from that table, at least I
://www.php.net/manual/en/function.mysql-query.php
-Natalie
-Original Message-
From: Jas [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 29, 2002 12:18 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Resource ID#2
Ok here is my problem, I set this up so a user selects a name form a select
box
On Thursday 30 May 2002 00:41, Jas wrote:
If you look at the previously posted code at the bottom of the form there
is a echo for the sql select statement that is echoing Resource id #2 on
the page. Now that error is the correct field id number in the database, I
am just not sure how to
-Natalie
-Original Message-
From: Jas [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 29, 2002 12:18 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Resource ID#2
Ok here is my problem, I set this up so a user selects a name form a
select
box and that name or $user_id is then passed to t
: [EMAIL PROTECTED]
Sent: Wednesday, January 23, 2002 12:21 PM
Subject: Re: [PHP-DB] Resource Id #2
Use something like this...
...
...
...
$rows = mysql_num_rows($result);
for ($y = 0; $y $rows; $y++){
$data = mysql_fetch_object($result);
echo $data-Field_Name
AHAHAHHAHA
AHHAHAHAH
Dan
On Wednesday, January 23, 2002, at 02:19 PM,
[EMAIL PROTECTED] wrote:
Dan,
Good, I'm glad it worked!!!
I see a lot of people using mysql_fetch_array().
Which is fine...But I'm more into Object Oriented programming...and
that's why I always use
I run this query $countreq = mysql_query(SELECT COUNT(*) FROM catalogs
WHERE PROCESSED IS NULL); then try to echo $countreq but end up getting
Resource id #2 instead of the count total. What would cause this?
Thanks for any advise!
James
--
PHP Database Mailing List (http://www.php.net/)
To
I've come across yet another problem.
I have a table set up that houses four things, a person's real name,
username, pass, and id. The id is used to join another table which houses
that persons contacts. I've been validating the user and pass by comparing
the number of rows that the sql
On Thursday 29 November 2001 01:29, Kevin Ruiz wrote:
I've come across yet another problem.
[snip]
$ci = select contactid from users where username='$username' and
password='$password';
$cir = mysql_query($ci)
or die(Couldn't execute);
$query = select
I am trying to select a message from a table in a database. the message will will be
in column 'msg' and will be in same row as id='0'.
I need that msg put to the screen. With the code below I get the error: Resource id #2
Can someone please explain how I can fix this..
Thankyou in advance.
?
I am trying to select a message from a table in a database. the message will will be
in column 'msg' and will be
in same row as id='0'.
I need that msg put to the screen. With the code below I get the error: Resource id #2
Can someone please explain how I can fix this..
Thankyou in advance.
?
25 matches
Mail list logo
