select fra 2 tabeller vises 2 gange
Hvorfor virker det her ikke?? den udskriver det 2 gange<?php
$sqlResult = mysql_query("SELECT Display, Title FROM doc_properties, documents");
while($Row = mysql_fetch_array($sqlResult)) {
echo $Row["Display"];
echo $Row["Title"];
}
echo "</pre>";
/*
1 Om
1 Om
1 Gæstebog
1 Gæstebog
*/
?>
<?php
$sqlResult = mysql_query("SELECT Display, Title FROM doc_properties, documents");
$Row = mysql_fetch_array($sqlResult);
echo "<pre>";
print_r($Row);
echo "</pre>";
/*
Array
(
[0] => 1
[Display] => 1
[1] => Om
[Title] => Om
)
*/
?>
SQL Database
doc_properties
ID
DocID
Display
documents
ID
Title
Text
