Hi Philip,
I am getting this in the error log file:
ERROR: Bad boolean external representation
'<font >color=red><b>YES></b></font>'
As someone else pointed out, in boolean, you can have Y/1 (true) or N/0
(false); only these values. So when you try to do a boolean check with
this, it doesn't work because this can't be expressed as 0/1 or Y/N, it's a
text string.
The code that is generating the message is all within the php delimiters
(entire file) and appears several times as follows:
if($r1==0 || $r2==0) {
if($archived=='Y') {
$archived="<font color=red><b>YES</b></font>";
}
There are a couple of ways to fix this.
Use a different variable name for displaying the "<font color=red>" - wild
suggestion - $display_archived - so then the variable $archived isn't
overwritten when it comes time for it to do your SQL query.
Or, just when you display the output of archived, have a little if statement:
if ($archived == 'y') {
echo "<font color=red>YES</font>";
} else {
echo "ARCHIVED IS NO";
}
Hope that helps a bit.
-----------------
Chris Smith
http://www.squiz.net/
