Looping through the Database

[lexxsc2]

Hi,guys
So I'm trying to make a script that loops through my Database and checks if a value that I've defined is equal to one from the database and then does something.
Example:
if I define
$myDate = date("d/m/Y");
and I have a column in my database that is called date.I want to check if $myDate = date and then do something(like sending an e-mail). After that the script should check the next row and so to the end of the mySQL database.
Thanks in advance for the answers.

[freshnet]

You'll want to fetch your query results into a variable and then use a foreach on that variable, e.g.

Code: Select all

$sql = mysqli_query($mysqli,"SELECT x FROM y");
$sql_result = mysqli_fetch_array($sql);

foreach ($sql_result as $value)
{
if ($value == $something_else)
{some code}
else
{some more code}
}