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 if the PHP mysql_select_db function simply doesn't want to select
the right table. However it does fine when connecting to the Mysql 3.23
server.
On 8/18/03 12:03 PM this was written:
> 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
> connecting and before query.So follow the order:
> 1. connection with $conn = @mysql_connect($dh,$du,$dp);
> 2. selecting the database with mysql_select_db("my_database",$conn);
> 3. performing query $result=db_query($sql);
>
> If you get an error in this step, it's not a PHP/Web matter.
>
> If all works fine, you can use :
>
> mysql_select_db($db,$conn);
>
> in place of
>
> mysql_select_db("my_database",$conn);
>
>
>
> If you get an error in the last step, the value of $db is wrong, so check
> the webpage which sends the value to $db.
--
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]
