SQL - Condition with Between

Question

SQL - Condition with Between

Navigation

#1 by (3 votes)

-1

I have a form where the user can search for a date range, so far so good. If it searches only for a date, how can I do this directly in sql or even in php?!

Any suggestions?

php mysql phpmyadmin

asked by anonymous 28.07.2018 / 15:02

1 answer

Form html with PHP code to insert into mysql I'm having this error "Warning: mysqli_query () expects parameter 1 to be mysqli" in php when querying the database [duplicate]

score 3 · Accepted Answer

Simply put:

$data2 = empty($data2) ? $data1 : $data2;
$sql = "SELECT ... BETWEEN $data1 AND $data2;";

If the second date is done, it receives the value of the first date if not the value itself, you can use other values if the second date is empty, for example, "NOW()"