Thomas Deliduka unknowingly asked us:
and then it ran the mysql_select_db which selected the wrong table.
Please re-read, re-phrase. I have an uncomfortable feeling when people
use the wrong function for the wrong purpose.
I'm an idiot, I should have looked for this before.
Think to think more.
Thomas Deliduka unknowingly asked us:
Thank you for the code, when I did that (which I should have done, you're
right) it worked fine. So, now I gotta find out where this is going wrong
and why the same code is working in one place but not the other. While my
connection function is only run once
On 8/18/03 3:18 PM this was written:
> Firstly, you will have to re-read your message before you press the send
> button each time. What you are saying is very unclear to the rest of us.
Sorry
> Nextly, your statement:
>
>> It's as if the PHP mysql_select_db function simply doesn't want to sele
Thomas Deliduka unknowingly asked us:
Right, however, I am following the progression of 1,2,3. My code I pasted
here showed that the connection function did the connect and select in the
same function and in my debugging I did confirm that $db does equal
my_database. I have also manually typed it
Right, however, I am following the progression of 1,2,3. My code I pasted
here showed that the connection function did the connect and select in the
same function and in my debugging I did confirm that $db does equal
my_database. I have also manually typed it in and it still doesn't work.
It's as
Oh, I see now!
When you gave the command mysql ... my_database, at the moment of the MySQL
shell, you have the database "my_database" already selected. So all of your
queries works fine because you are in the right database.
In the PHP or other environment, you need to select the database after
co
the first not-working query.
Add, also, the real names of the MySQL tables used in your lines.
Iulian
- Original Message -
From: "Thomas Deliduka" <[EMAIL PROTECTED]>
To: "m a b" <[EMAIL PROTECTED]>
Sent: Monday, August 18, 2003 5:47 PM
Subject: Re: Server to
Sorry, in an attempt to further clarify my server situation.
I have Three actual servers, physical computers they are setup with:
s1: Apache 1.3.27, PHP 4.3.2, MySQL 4.0.14
s2: Apache 1.3.27, PHP 4.3.2, MySQL 4.0.12
s3: Apache 1.3.27, PHP 4.3.2, MySQL 3.23.54 (I believe 54 is the step value)
Pro
Server = physical machine.
Every query, it doesn't matter what query I send, it tries to use the wrong
database. I thought I put "select * from table_name" but perhaps I didn't.
I have another message just sent with code and perhaps a little additional
information.
On 8/18/03 10:48 AM this was w
At 10:14 -0400 8/18/03, Thomas Deliduka wrote:
I have written this to the PHP-DB list and couldn't get any answers. I have
gone through all the documentation I could find. I have been everywhere and
cannot find an answer to this problem! Perhaps someone on this list can
lend me some insight?!
We
The table is in the SQL statement. "Select * from table_name" If you
really want my code it's very long. I will paste in the stuff that's
relevant. It's at the bottom.
If it's a PHP matter why does the same code connecting to a 3.23 server work
perfectly fine. This same EXACT code works perfect
You have selected my_database as database. What about the table? Put some of
your code to clarify the problem. It's a PHP matter.
Iulian
- Original Message -
From: "Thomas Deliduka" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, August 18, 2003 5:14 PM
Subject: Server to Server
12 matches
Mail list logo
