need to add DISTINCT to SQL?!

need to add: DISTINCT $tableName.booking_date

to my following SQL line below:

"SELECT COUNT(*) as num FROM $tableName WHERE booking_date BETWEEN '$from' AND '$to'"

please help

can anyone help here?

I'm sorry, the question doesn't make sense, to me.

Are you saying you want a COUNT for each distinct booking_date??

In that case, you don't want DISTINCT, you want GROUP BY:

$sql = "SELECT booking_date, COUNT(*) as num "
. " FROM $tableName "
. " WHERE booking_date BETWEEN '$from' AND '$to' "
. " GROUP BY booking_date "
. " ORDER BY booking_date';