how to write a for loop in mysql and retrive the data

[seshu]

Hi Everybody
well i shall explain the problem first i have designed a small attendance software which is connected to threee tables
1)userdetails
2)attendance
3)absenties
now i am able insert the records of all the candidates
and i am able to generate the absenties list by writing this query

select name from userdetails where  NOT EXISTS (select name from attendance where attendance.name = userdetails.userloginid and attendance.log_date=Respective date)

but the problem here is iam able to write a query which will generate the absenties list for only one day are the day i want but i want to see for from date to to date even and i think this is possible by writing for loop

hope iam clear

[code green]

Not sure what you want but you can expand your query

select name from userdetails where  NOT EXISTS 
(select name from attendance where 
attendance.name = userdetails.userloginid and attendance.log_date=Respective date)

Try changing WHERE condition to

attendance.log_date> minimum_date AND attendance.log_date< maximum_date 

or using

attendance.log_date BETWEEN (minimum_date,maximum_date) 

[ronverdonk]

The format for the MySQL BETWEEN operator is

expression BETWEEN minvalue AND maxvalue 

Ronald :cool: