*************

SQL code: Upload dump Copy Format Clear

CREATE TABLE `trundschreiben` ( `rsID` int(11) NOT NULL, `rsMTGLemail` varchar(255) COLLATE latin1_german1_ci NOT NULL, `rsVersendet` tinyint(1) DEFAULT NULL, `rsVersanddatum` date DEFAULT NULL, `rsAbsender` varchar(255) COLLATE latin1_german1_ci DEFAULT NULL, `rssprache` varchar(3) COLLATE latin1_german1_ci NOT NULL, `rskurse` text COLLATE latin1_german1_ci NOT NULL, `rskurseplain` text COLLATE latin1_german1_ci NOT NULL, `rsfirmenname` varchar(255) COLLATE latin1_german1_ci DEFAULT NULL, `rstyp` int(10) UNSIGNED NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci; INSERT INTO `trundschreiben` (`rsID`, `rsMTGLemail`, `rssprache`, `rskurse`, `rskurseplain`, `rstyp`) VALUES (123, 'rsMTGLemail', 'abc', '`rskurse`', '`rskurseplain`', 123);

SQL Server: Preserve result

Result: Copy Clear

PHP code: Copy Format Clear

<?php $db_link = &$mysqli; $sql = "SELECT MAX(rsID) as rsid FROM trundschreiben"; $result = mysqli_query($db_link, $sql); $nrRS = mysqli_fetch_array($result, MYSQLI_ASSOC); var_dump($nrRS);

PHP version:

Show: Warnings Notice

Result: Copy Clear

PHPize Online / SQLize Online / SQLtest Online