Re: Include files....

On 5/18/07, Jason Pruim <japruim@raoset.com> wrote:

Okay, Very Newbie-ish question coming! I can't figure out why my include won't work... Here's the text: index.php: <?PHP include 'defaults.php'; $link = mysql_connect($server, $username, $password) or die('Could not connect: ' . mysql_error()); echo 'Connected successfully <BR>'; mysql_select_db($database) or die('Could not select database: ' . mysql_error()); echo 'DB selected <BR>'; $result = mysql_query($query) or die(mysql_error()); $num=mysql_numrows($result); $i= 0; while($i < $num) {

       $FName = mysql_result($result, $i,"FName");
       $LName = mysql_result($result,$i,"LName");
       $Add1 = mysql_result($result, $i,"Add1");
       $Add2 = mysql_result($result, $i,"Add2");
       $City = mysql_result($result, $i,"City");
       $State = mysql_result($result, $i,"State");
       $Zip = mysql_result($result, $i,"Zip");
       $Date = date("m-d-y h:i:s",mysql_result($result, $i, "Date"));
       $Record = mysql_result($result, $i, "Record");
       $subName = mysql_result($result, $i,"subName");
       $subEmail = mysql_result($result, $i,"subEmail");
       $subPhone = mysql_result($result, $i,"subPhone");
       $chkMember = unserialize(mysql_result($result, $i,"chkMember"));
       $chkAdd = unserialize(mysql_result($result, $i,"chkAdd"));
       $chkDel = unserialize(mysql_result($result, $i, "chkDel"));

       $i++;

       //echo "<P>$Record $FName, $LName,</P> <P>$Add1,<BR> $Add2,<BR></P>

<P>$City, $State, $Zip,</P> $Date,<BR> $subName, $subEmail, $subPhone, $chkMember[$row], $chkAdd[$row], $chkDel[$row]<BR>";

       echo "<H3>Name Address</H3>";
       echo "<P id ='test'> $FName $LName $Add1 $Add2 $Date</P>";

}; ?> * defaults.php: $server = 'localhost'; $username = 'USERNAME'; $password = 'PASSWORD'; $database = 'DATABASE'; $query = 'SELECT * FROM current'; Yes I changed the values of username, password, and database. But when I use the same info inside the index.php file it all works just fine. Here is the error that it gives me: [Fri May 18 15:32:07 2007] [error] PHP Notice: Undefined variable: server in /Volumes/RAIDer/webserver/Documents/tests/legion/index.php on line 5 [Fri May 18 15:32:07 2007] [error] PHP Notice: Undefined variable: username in /Volumes/RAIDer/webserver/Documents/tests/legion/ index.php on line 5 [Fri May 18 15:32:07 2007] [error] PHP Notice: Undefined variable: password in /Volumes/RAIDer/webserver/Documents/tests/legion/ index.php on line 5 [Fri May 18 15:32:07 2007] [error] PHP Warning: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Access denied for user 'USERNAME'@'localhost' (using password: NO) in / Volumes/RAIDer/webserver/Documents/tests/legion/index.php on line 5 Thanks in advance for helping me through my obvious friday afternoon brain fart... I guess you forget that defaults.php is a php file and needs to start

with <?php and end with ?> Tijnema