DB Connection info via INCLUDES

[agentsmith]

Why won't my script connect to DB if I include the DBCONN info within an INCLUDE???

<?php include("http://www.xxx.com/xxx/db.php"); ?>

<?php

// URL format = crewoptions.php?tool=VALUE&jobID=VALUE

// tool options: view, edit and delete

// db connection info

IF I COMMENT THE FOLLOWING TWO LINES OUT...CONNECTION TO DATABASE WONT OCCUR

THE ABOVE FILE PATH IS CORRECT AND THE INFO WITHIN IT IS EXACTLY THE FOLLOWING TWO LINES

WHY CANT I GET A CONNECTION VIA INCLUDE????

$db = mysql_connect("localhost", "xxxx", "xxxx");
mysql_select_db("xxxx",$db);

Please help.

[tomhath]

Try checking mysql_error() after the connect and db select. It should tell you the problem.

[agentsmith]

error is "NO DATABASE SELECTED"

[agentsmith]

i figured it out.

because the path in the include was with the URL it didn't convert variables or anything. it would only show the ECHO I put in it to see if it was showing up.

but when I did a relative path it works fine.:

DIDN"T WORK:

<?php include("http://www.XXX.com/000/include.php") ?>

WORKS :

<?php include("../include.php") ?>

Any Ideas Why?