Selectie van eerste record BY datum? (Opgelost)

SELECT * FROM tbloptredens ORDER BY optredenDatum DESC

SELECT * FROM tbloptredens ORDER BY optredenDatum DESC

public function getEerstOptreden()
	{
		$lijst		= array();
		$sql		= "SELECT * FROM tbloptredens ORDER BY optredendatum DESC";
		$dbh		= new PDO($this->dbConn, $this->dbUsername, $this->dbPassword);
		$resultSet	= $dbh->query($sql);
		$dbh		= null;
		print_r ($resultSet);
	}

public function getEerstOptreden()
	{
		$lijst		= array();
		$sql		= "SELECT * FROM tbloptredens ORDER BY optredendatum DESC";
		$dbh		= new PDO($this->dbConn, $this->dbUsername, $this->dbPassword);
		$resultSet	= $dbh->query($sql);
		$dbh		= null;
		print_r ($resultSet);
	}

<?php

    $strServer = "localhost"; // Database server 
    $strDbUser = "root"; // Database username
    $strDbPassword = "YourPass"; // Database user password
    $strDbName = "DatabaseName"; // Name of the MySQL database

    if(mysql_connect($strServer, $strDbUser, $strDbPassword))
    {
        if(mysql_select_db($strDbName))
        {
            $query = "SELECT * FROM tbloptredens ORDER BY optredendatum DESC"; // Query to execute
            $result = mysql_query($query) or die(mysql_error()); // Execute Query
            if(mysql_num_rows($result) == 0) 
            {
                echo "No table records";
            }
            else
            {
                print_r(mysql_fetch_array($result)); // Print the result
            }                
        }
        else
        {
            echo "Database not found";
        }            
    }
    else
    {
        echo "Database authorisation failed";
    }

?>

<?php
 
    $strServer = "localhost"; // Database server 
    $strDbUser = "root"; // Database username
    $strDbPassword = "YourPass"; // Database user password
    $strDbName = "DatabaseName"; // Name of the MySQL database
 
    if(mysql_connect($strServer, $strDbUser, $strDbPassword))
    {
        if(mysql_select_db($strDbName))
        {
            $query = "SELECT * FROM tbloptredens ORDER BY optredendatum DESC"; // Query to execute
            $result = mysql_query($query) or die(mysql_error()); // Execute Query
            if(mysql_num_rows($result) == 0) 
            {
                echo "No table records";
            }
            else
            {
                print_r(mysql_fetch_array($result)); // Print the result
            }                
        }
        else
        {
            echo "Database not found";
        }            
    }
    else
    {
        echo "Database authorisation failed";
    }
 
?>

SELECT * FROM `tbloptredens` ORDER BY `optredenDatum` DESC LIMIT 1

SELECT * FROM `tbloptredens` ORDER BY `optredenDatum` DESC LIMIT 1

print_r(mysql_fetch_array($result)); // Print the result

print_r(mysql_fetch_array($result)); // Print the result

print_r(mysql_fetch_assoc($result)); // Print the result

print_r(mysql_fetch_assoc($result)); // Print the result