Thread: [gelöst] Fragen bezüglich MySQL

SELECT id, titel FROM it_texte LIMIT 0, 5;

SELECT id, titel FROM it_texte LIMIT 0, 10;

SELECT id, titel FROM it_texte WHERE titel LIKE '%wort%und%noch%ein%wort%';

SELECT id, titel
FROM it_texte
ORDER BY id DESC
LIMIT 0, 5;

$i = 1;
foreach($array as $element)
{
echo \"Durchlauf: \".$i.\"<br />\";
echo $element;
$i++;
}

$start_time = microtime(true);
$dbqry = mysql_query($sql);
$end_time = microtime(true);
echo \"MySQL-Zeit: \".round($end_time - $start_time, 5);

$i = 1;
foreach($array as $element)
{
echo \"Durchlauf: \".$i.\"<br />\";
echo $element;
$i++;
}

$query1=\"
SELECT COUNT(*)
FROM tabelle;\";
 
$query2=\"
SELECT id, name, text
FROM tabelle
LIMIT 0,10;\";

$query1=\"
SELECT COUNT(*)
FROM tabelle;\";