Can't connect to database!

[stryker115]

For some reason, I cannot connect to my mySQL database, which is part of my hosting company's server. My connection function is (off the top of my head):

function db_connect{
$result = my_sql_pconnect("dbserver", "username, "pass");
if (!$result)
return false;
return $result;
}

However, if I try to echo $result's value, I get no output. When I select the database and table for a query, nothing happens. What am I doing wrong?

[bastien]

function db_connect{ 
  $result = my_sql_pconnect("dbserver", "username, "pass"); 
  if (!$result){ //missing bracket here
    echo "Can't connect"; 
  } 
}

[stryker115]

I added a bracket, and nothing changed. I'm not sure how that bracket missing would affect anything, as it is. Here is the full code:

<?php
include ("connect.inc.php");
include ("heading.php");

$conn = db_connect();
mysql_select_db (db87686133, $conn);

echo $conn;
echo "Test";

$news_sql = "select * from news order by id";
$news_results = mysql_db_query($news_sql, $conn);
$num_rows = mysql_num_rows($news_results);
echo $num_rows;
echo "Test2";

for($i=$num_rows; $i>0; $i--)
{
	$row = mysql_fetch_array($news_results);
	echo "<strong>".$row[title]."</strong>";
	echo "                          ".$row[date];
	echo "<p>".$row[entry];
	echo "<br>";
	echo $i;
}
include ("bottom.php");
?>

And this is my connect.inc.php:

<?php

function db_connect()
{
	$result = mysql_connect (db21.perfora.net, dbo87686133, dAxHzdvB);
	echo $result;
	if (!$result)
	{
		return false;
	}
	return $result;
}

?>

In the main script, the only echos I see on the screen are the Test and Test2, the other echos for $conn or $num_rows do not produce anything. What am I doing wrong

[bastien]

I tend to abstract my $conn into another file and include it in the sql execution as:

include("conn.php");

$result = mysql_query($sql,$conn);

the file

<?php


    //check the password from the DB and get the access level = type


    $username = "someName";
    $pwd ="*********";
    $host = "localhost";
    $dbname = "myDB";

    //connect to db
    if (!($conn=mysql_connect($host, $username, $pwd)))  {
        printf("error connecting to DB by user = $username and pwd=$pwd");
        exit;
    }
   $db=mysql_select_db($dbname,$conn) or die("Unable to connect to database1");

?>

hth