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 select
>> the right table.
>
> Note, that PHP's mysql_select_db DOES NOT select a table. It selects a DB.
You're right. I mis-typed and didn't re-read.
> The first thing to do to your script is this:
>
> 1. Strip ALL @ symbols before functions. Its a wreckless havoc.
My application works locally when going off of the same machine that the
server is working on. The @ symbols are there because the application is an
in-production application that has been used for over a year. I make sure
my clients (about 6 right now) don't get error messages when they're using
the site. Instead, I get e-mails when there are errors trapped. Yes, for
debugging it's good to remove them and I did.
> 2. Secondly, do not put blame on PHP's mysql_select_db function as there
> about 5000 people using that function successfully.
I'm not completely blaming it. However, it is working fine when the database
and the web server is on the same server but the SAME EXACT CODE is not
working when the web server is another server separate from the database.
Mysql_select_db is telling me it's choosing the proper database but in the
end the query is run and that database isn't the one chosen. I need to find
out why.
> 3. Thirdly, _completely) clear up your file, and start fresh, with just
> necessary lines of code. Remove all unnecessary IF conditions, for the
> time being. Something like this:
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 (due to my debug code I know this)
however somewhere the mysql_select_db function is being called again so I
just gotta find out where.
I won't bother you all again. If anyone wants to know how I fix this when I
eventually do, write me personally. Thanks for your help and patience.
--
Thomas Deliduka
IT Manager
-------------------------
Xenocast
Street Smart Media Solutions
http://www.xenocast.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
