On 29/06/06, Chris <dmagick@xxxxxxxxx> wrote:
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.
Try it the same as the php manual page:
$conn = mysql_connect('....');
if (!$conn) {
die("Could not connect: " . mysql_error());
}
You may be logging the errors. Tty echoing the value of the resource
($conn) - it should be an integer.
--
http://www.web-buddha.co.uk
http://www.projectkarma.co.uk
