I have been trying to get PHP to retrieve any results that have the date stamp that is the same as in the column 'date'.
It then loops round and prints out all the data retrieved.
The actual retrieval works fine, its just my condition!
Code:
$currentdate = date('Y/m/d');
$echo . $currentdate;
$query = "SELECT * FROM `pupils` WHERE `$currentdate` = date";//Grab the data
$result = mysqli_query($con, $query);
Any help greatly appreciated!
proper use of the WHERE clause looks like this.
SELECT column_name,column_name
FROM table_name
WHERE column_name operator value;
your value is date. what is date? I'll assume that date is a column name here. Something that would work would like this.
$query = "SELECT * FROM `pupils` WHERE `date` = $currentdate";
You're using magic quotes around the date value where you ought to be using single quotes. Magic quotes cause MySQL to intrepret the date value (being passed in as Y/m/d as an identifier (like a column name). See revised code below with comments.
$currentdate = date('Y/m/d');
$echo . $currentdate;
// Magic quotes (`) are used to denote identifier names in MySQL
$query = "SELECT * FROM `pupils` WHERE '$currentdate' = date";
$result = mysqli_query($con, $query);
You could offload the whole process to the query itself, MySQL offers a CURRENT_TIMESTAMP function that will give you the current server time, you can further manipulate it to get the specificity that you would like.
replace the backtics arround $currentdate with single qoutes and add the backticks around date, because date is a reserved word in mysql.
$query = "SELECT * FROM `pupils` WHERE '$currentdate' = `date`";//
$echoerrrr, that's justecho;-)echo $currentdate;and no dot required.