mysql select checking for null characters

[tolkienarda]

hi all
i dynamicaly generate a select statement and there seems to be a problem with it.
below is an example of one that is generated

SELECT TITLE, FNMI, SALUTATION, COMPANY, E_MAIL FROM DBASE WHERE BOARD IS NOT NULL, OR CBM IS NOT NULL, OR LEGIS IS NOT NULL
 

when i paste it into the sql part of phpmyadmin i get the following error

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' OR CBM IS NOT NULL , OR LEGIS IS NOT NULL  LIMIT 0, 30' at line 1 
 

all of the capital letters are because someone made this database in microsoft access, and she apparently likes caps. I have never used 'OR' or IS NOT NULL in my select statements before and maybe there is somthing wrong with that syntax

i would love some help

eric

[ScarletPimpernal]

Hi,

The Syntax for the query is wrong:

Use the Below query,

SELECT TITLE, FNMI, SALUTATION, COMPANY, E_MAIL FROM DBASE WHERE BOARD IS NOT NULL OR CBM IS NOT NULL OR LEGIS IS NOT NULL;

There can't be Comma seperator in the query, i mean in the where clause of the query.

Thanks,
Scarlet

hi all
i dynamicaly generate a select statement and there seems to be a problem with it.
below is an example of one that is generated

SELECT TITLE, FNMI, SALUTATION, COMPANY, E_MAIL FROM DBASE WHERE BOARD IS NOT NULL, OR CBM IS NOT NULL, OR LEGIS IS NOT NULL
 

when i paste it into the sql part of phpmyadmin i get the following error

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' OR CBM IS NOT NULL , OR LEGIS IS NOT NULL  LIMIT 0, 30' at line 1 
 

all of the capital letters are because someone made this database in microsoft access, and she apparently likes caps. I have never used 'OR' or IS NOT NULL in my select statements before and maybe there is somthing wrong with that syntax

i would love some help

eric

[tolkienarda]

perfect thanks a million

eric