MySQL - select statement - PHPBuilder Forums

MySQL - select statement

I was wondering if anyone knows how to pull this information from my database. I need the select statement (mostly the 'where' part)

I need a list of items that where shipped to a company called 'ALBERCO' during the last month.
select orderdate
from orders
where ( )

and this too

I need to pull the rder due in 3 days every day I run it.

select custID, orderdate
from orders
where ( )

Any help would be appriciated thanks

You have to give the table(s) layout or we can't create a query with unknow tables.

It could be

select * from order where company = 'ALBERCO';

Frag

I gave enough information. I need it to be like
select orderdat
from order
where from_days (to_days (curdate())+3);

first of all don't you think that "order" might not be good name for table 🙂

... so you have to parse time variables that db can understand.

where $from <= $datenow