On Wed, June 28, 2006 6:58 pm, Russbucket wrote:
> I took an example of a script from the PHP documentation and try to
> connect
> to my database. If I leave in the or die part of line 3, I get
> nothing, if
> I comment out that part I get the echo message on line 4.
>
> <?php
> // Connecting and selecting the database
> $conn = mysql_connect ('localhost', 'finemanruss', 'XXXXXXXl') or die
> ('Could
> not connect : ' . mysql_error());
> echo 'Connected successfully';
> mysql_select_db ("Lions", $conn);
>
> // Preform SQL query
> $query = 'SELECT * FROM Moses_Lake_Lions';
> $result = mysql_query ($query) or die ( 'Query failed; ' .
> mysql_error());
> ?>
>
> I know line three works without the or die part since I have a 2nd
> script that
> is almost the same (no or die) and it retrieves info from my DB.
>
> Can anyone point me to some tips or solutions to the or die problem?
> This
> script is located in the mysql ref section of the php manual. I'm
> using php5
> on SUSE Linux 10.0 with a mysql database.
Odds are REALLY GOOD that the "or die" is fine...
Try this: Change line 4 to be:
echo 'Successfully connected: ', $conn;
If $conn shows something like "Resource #4" then you know you have a
good connection. If it shows "false" or nothing, then you know the
connection is not working, and or die() is doing the right thing.
--
Like Music?
http://l-i-e.com/artists.htm
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
