Really I am a PHP beginner, I am working on this code and I need help, kinda stuck.
I have a database with 3 fields(id, date and venue). This is simply what I want to do;
I want my script to go into the database fetch the date and compare it with a declared date(todays date) and if both days are equal, it should echo out the venue that corresponds to the date taken from Mysql.
Jump to Post
First you must have a valid date field in your table structure.
SELECT venue FROM tablename WHERE date_column = curdate()
All 11 Replies
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.