how to make sql query for comparison condition

hye guest..
anybody can help me how to make sql query for comparison condition.
in case,i want to generate report between range two date for example 1/2/2007 until 20/2/2007?

re: how to make sql query for comparison condition

Welcome to The Scripts!

Next time i'll advise you to just read the MySQL manual. You would have found

Ronald :cool:

re: how to make sql query for comparison condition

thank's so much ronverdonk !

actually i develop my database system using mysql phpMyAdmin for my industrial training project.
but, when i use mysql in php environment it's really different with sql right??
there have several different or limitation, for example in php language do not support for nested query.

so,i have problem when make select query from two or more than one table.

this is a new one that i learn in different database language..

re: how to make sql query for comparison condition

All right. I will forgive you