TalkPHP - View Single Post

Salathe · 10-01-2007, 11:36 PM

At line 10, change:

PHP Code:


			
AND pm_notify = '0'||'1'

To:

PHP Code:


			
AND pm_notify = 0 OR pm_notify = 1

Presumably the pm_notify column is BOOLEAN meaning that it can only have a value of 0 or 1, in which case there's no point checking if it is set to either 0 or 1. Because of that I don't see why you need to check the pm_notify value in the WHERE clause at all.

10-01-2007, 11:36 PM	#2 (permalink)
Salathe Moderateur Join Date: Apr 2007 Posts: 1,393 Thanks: 5	At line 10, change: PHP Code: `AND pm_notify = '0'\|\|'1'` To: PHP Code: `AND pm_notify = 0 OR pm_notify = 1` Presumably the `pm_notify` column is BOOLEAN meaning that it can only have a value of 0 or 1, in which case there's no point checking if it is set to either 0 or 1. Because of that I don't see why you need to check the pm_notify value in the WHERE clause at all.