parse error?

[lukeurtnowski]

Here is the php scrippt im using to connect to a mysql daabase, whenever it is called, I get a parse error on line 17, I'm looking and I cant find this error, maybe more experienced eyes can. Thanks

<?

  $dbhost="localhost";
  $user="dimecafe_admin";
  $password="dimecafepw";
  $db="dimecafe_gallery";

function db_connect()
{
         global $link_id,$db,$dbhost,$user,$password;
         $link_id = mysql_connect($dbhost,$user,$password);
         if(!$link_id)
         {
             $MYSQL_ERRNO = 0;
             $MY_SQL_ERROR = 'Connection Failed';
         }
         else if(empty($dbhost)&amp;amp;amp;amp;amp;&amp;amp;amp;amp;amp; !mysql_select_db($db))
         {
             $MYSQL_ERRNO = mysql_errno();
             $MY_SQL_ERROR = mysql_error();
         }
         else
         {
          @mysql_select_db($db);
          return $link_id;
         }
}

function error()
{
         echo "ERROR " . mysql_errno() . " : " . mysql_error();
}
?>
[/php}

[tekky]

my guess is something here....

else if(empty($dbhost)&& !mysql_select_db($db))

would be easier to see if you closed your [/code] tag with a ] and not a } to see the hiliting though 😉

[lukeurtnowski]

Here is the php scrippt im using to connect to a mysql daabase, whenever it is called, I get a parse error on line 17, I'm looking and I cant find this error, maybe more experienced eyes can. Thanks

<?

$dbhost="localhost";
$user="dimecafe_admin";
$password="dimecafepw";
$db="dimecafe_gallery";

function db_connect()
{
global $link_id,$db,$dbhost,$user,$password;
$link_id = mysql_connect($dbhost,$user,$password);
if(!$link_id)
{
$MYSQL_ERRNO = 0;
$MY_SQL_ERROR = 'Connection Failed';
}
else if(empty($dbhost)&amp;amp;amp;amp;&amp;amp;amp;amp; !mysql_select_db($db))
{
$MYSQL_ERRNO = mysql_errno();
$MY_SQL_ERROR = mysql_error();
}
else
{
@mysql_select_db($db);
return $link_id;
}
}

function error()
{
echo "ERROR " . mysql_errno() . " : " . mysql_error();
}
?>

[leatherback]

Hi,

Must agree with tekky here.The expression doesn't seem like a valide statement.
Why not just use:

else if(empty($dbhost))

But eh.. No clue what you want to reach with:

&& !mysql_select_db($db)

What is it for?

J.

[laserlight]

My guess is that lukeurtnowski took the code from some site that apparently didnt handle special characters well for use in code (probably applied the equivalent of htmlspecialchar() to text that already had this applied to, perhaps in an edit)

& => & => &

&&
becomes
&&
which becomes
&&

So it should be:
empty($dbhost) && !mysql_select_db($db)

[lukeurtnowski]

OK, just trying to figure out some bodys code, but I think you hit the nail on the head. Thanks for your help.