parse error

Anon

Can someone have a check and see what I cant?
This is the only php on the page, but it is returning a parse error at the end of the page.

<?php

holds initial connection and changing to working database

  require ("abe_include.php");

declare global $connection

  global $connection;

verify record added

   if (!mysql_query($sql_addclient,$connection)) {
$problem = "Cannot access database.  Please hit the back button and try again before reporting this fault.";
require ("head_errorpage.php");
exit;

} else {

echo "$client record created. Choose from a link below to continue.";

}
?>

mega_hurtz

it's happening b/c you can't use require() in a conditional statement: require() will ALWAYS execute the code that is inside whether your conditional statement allows it or not.

you should use the include() or include_once() in order to conditionally load a php file. as for your parse error, something is probably wrong syntax-wise in your error page.

Anon

Sorry, but I don't think that is correct. I use require statements in conditional statements all the time and they work fine for me. You might want to look in actual files you are trying to include. Try and parse those files by themself and see if they trow an error.

Anon

after looking over your code more, it might be the exit; statement. Try exit(); instead.

mega_hurtz

my choice of words were off. Brian's right, the require()'d file may not execute, but the file is always evaluated when you use the require() construct. so if your file has syntax errors even though it doesn't execute, it will still throw a parse error.

cldeans

Thanks for everyone's help.

After much debugging and simplifying (Thanks to Joe Stump aka Miester for his time) this is what we come up with ...

<?php

require ('abe_include.php');

$sql_addclient = "INSERT INTO client_login (client, username, password)
values
('$client', '$username', '$password')"
or die(mysql_error());

verify record added

$result = mysql_db_query ($connect_db, $sql_addclient, $connection);

if (!result) {
echo "<font face='Verdana' size='3' color='#FFCC00'>Cannot access database. Please hit the back button and try again before reporting this fault.</font>";
die(mysql_error());

} else {

echo "<font face='Verdana' size='2' color='#FFCC00'>$client record created. Choose from a link below to continue.</font>";
}
?>

Which doesnt generate any errors ... but doesnt insert anything either.

Suggestions? Thanks all...