chack if date is in database

Question

hii i have database with 5 colums id name lastname date order i want tath the user can make one order in a day how can i do it ?

Barak Kadosh · Answer

i tray it bat i get error can you writh the query hear ?

Bikesh Srivastava · Answer

I think you can check column value.

Barak Kadosh · Answer

But how can i do it can you send example please

Chetan Ranpariya · Answer

You can query in the database to check if there is a record in the database which matches the userId and order date is between yesterday's date and Tomorrow's date. If no record exist then you insert a new record. If record exist that means already ordered for today so do not insert the record and display error message.