Thankx a million Tom,
I used .mysql_error() and i found it right away.
Actualy i have a config.php file with the mysql user information and i was
forgeting to do a include("config.php"); before i used mysql.
Really stupid error.
Thankx again.
Miguel Angelo
> Hi,
>
> Sunday, March 23, 2003, 1:26:04 PM, you wrote:
> MA> Hi everyone,
>
> MA> FIRST THANKX FOR ANY HELP !!
> MA> and THANKX FOR READING :)
>
> MA> I'm a reall newbie on PHP and i'm build a php app to connect
> into a mysql MA> database.. but i cannot select the database
>
> MA> i have build the database, and created a user
> MA> with :
>
> MA> create database mydatabase;
> MA> use mydatabase;
> MA> create tb_users ( userid varchar(20), userpassword varchar(20 );
>
> MA> grant select, update, insert, delete on mydatabase.* to [EMAIL PROTECTED]
> MA> IDENTIFIED BY "mypassword";
>
> MA> then flush priveliges...
> MA> I tested the user on mysql and it work correcly for my the
> pretended database
>
> MA> NOTES:
> MA> O.S. Linux
> MA> Mysql : compiled the most recent stable 4.0.12
> MA> Php was compiled by SuSe on SuSe 8.0
> MA> Php is connected into mysql via socks (configured on /etc/php.ini)
>
> MA> to test the set up i have used the php.net manual example to
> connect into the MA> mysql database i manage to connect into mysql
> but i cannot select the database MA> can this be my mistake or can
> it be a software problem ?
>
> MA> here is the php programa
>
> MA> <?php
> MA> $DB_HOST = "localhost";
> MA> $DB_USER = "myuser";
> MA> $DB_PASSWORD = "mypassword";
> MA> $DB_NAME = "mydatabase";
>
> MA> /* Connecting, selecting database */
> MA> $link = mysql_connect("$DB_HOST", "$DB_USER", "$DB_PASSWORD")
> or MA> die("Could not connect<br>"); MA> print "Connected
successfully<br>";
> MA> mysql_select_db("$DB_NAME", $link) or die("Could not select
> MA> database<br>");
>
> MA> /* Performing SQL query */
> MA> $query = "SELECT * FROM tb_users";
> MA> $result = mysql_query($query) or die("Query failed<br>");
>
> MA> /* Printing results in HTML */
> MA> print "<table>\n";
> MA> while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
> MA> print "\t<tr>\n";
> MA> foreach ($line as $col_value) {
> MA> print "\t\t<td>$col_value</td>\n";
> MA> }
> MA> print "\t</tr>\n";
> MA> }
> MA> print "</table>\n";
>
> MA> /* Free resultset */
> MA> mysql_free_result($result);
>
> MA> /* Closing connection */
> MA> mysql_close($link);
> ?>>
>
> MA> Stay Happy
> MA> Miguel Angelo
> MA> ------- End of Forwarded Message -------
>
> Add a call to mysql_error() to find out what mysql does not like.
>
> mysql_select_db("$DB_NAME", $link) or die("Could not select
> database: ".mysql_error()."<br>");
>
> --
> regards,
> Tom
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
