An include jumps back into HTML "mode" so you need:
<?php
$server = "";
$username = "";
.
.
.
?>
On Fri, May 18, 2007 3:05 pm, Jason Pruim 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...
>
>
>
>
> --
>
> Jason Pruim
> Raoset Inc.
> Technology Manager
> MQC Specialist
> 3251 132nd ave
> Holland, MI, 49424
> www.raoset.com
> japruim@xxxxxxxxxx
>
>
>
--
Some people have a "gift" link here.
Know what I want?
I want you to buy a CD from some indie artist.
http://cdbaby.com/browse/from/lynch
Yeah, I get a buck. So?
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
