ODBC strange result

[markfc]

Hi There, I'm trying to query an access database using an odbc source through php 4.23

If i issue the command

$sql= "select FROM [Projects Main Table] WHERE ([Project Title] Like '$search') or (List Like '$search*');" ;

i dont get any results, but if i copy and paste that statement into access and run it from there it works fine.

Also if i remove the where clause altogether it also work fine but of course i don't want all the records. Am I missing something?

Thanks

Mark

[markfc]

sorry the access help said to use $query if i use %$query% it's okay...

wierd...why is that then?

[barand]

If you run queries from within access itself then the wildcard is '*'.

From outside, the sql standard is '%'.

Just another instance of Microshaft going its own way.

hth