Problems connecting to an Access database

[jennyflower]

Hi,

I seem to having some problems when I want to do something like to an Access database:

$sql = "SELECT [Field Name] FROM table WHERE [Field Name] > " . $_GET['greaternumber'] . "";

I have tried putting single quotes around the php variable with no effect and I think its something to do with the fact that the where field has a space in it.

Can anyone help me? I am using an ADO connection to do this btw

Thanks

 

[jpadie]

what error are you getting?

 

[jennyflower]

Its ok, I think Ive sorted it, Don't really know how but I just write a query in Access then viewed the sql for it and copied it into my code. For some reason I haven't managed to write one without doing this, I must be making slight errors in my code, but thanks it all good