Re: [PHP-DB] mysql date select statement

2003-08-17 Thread Shahmat Dahlan
hav u tried using dashes to denote which portion is the year, month, or day ? e.g. instead of 20030101, you'd probably want to use 2003-01-01. Wendell Frohwein wrote: Hello all, I have this page where I search and add up commissions in a mysql database. I want to select commissions between a cer

Re: [PHP-DB] mysql date select statement

2003-08-17 Thread John W. Holmes
Wendell Frohwein wrote: Hello all, I have this page where I search and add up commissions in a mysql database. I want to select commissions between a certain date range. This is what im currently using but it does not seem to work. $from="20030101"; $to="20031230"; $search=mysql_query("SELEC