Thread: BUG #6550: Querry failed while using throung php program.
The following bug has been logged on the website: Bug reference: 6550 Logged by: M K Krishnan Email address: mkkrish@hotmail.com PostgreSQL version: 9.0.4 Operating system: Windows 7 Description:=20=20=20=20=20=20=20=20 11Variety One Warning: pg_query(): Query failed: ERROR: syntax error at or near "and" LINE 1: select * from variety_dir where crop_cd=3D and variety_c= d=3D1 ^ in C:\Program Files (x86)\PostgreSQL\EnterpriseDB-ApachePhp\apache\www\agrimetnew\variety_upd.p= hp on line 32 Warning: pg_num_rows() expects parameter 1 to be resource, boolean given in C:\Program Files (x86)\PostgreSQL\EnterpriseDB-ApachePhp\apache\www\agrimetnew\variety_upd.p= hp on line 33 No Record Found . Query works from SQL Screen. When uses through php it fails.
On Thu, Mar 22, 2012 at 08:00, <mkkrish@hotmail.com> wrote: > LINE 1: select * from variety_dir where crop_cd= and variety_cd=1 You're missing a value for the crop_cd= clause. This error is supposed to occur. > Query works from SQL Screen. When uses through php it fails. You probably executed a different query from there. Regards, Marti