[PHP][MySQL] Blad Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource Opcje

[carlo497]

Moze ktos powiedziec gdzie tu jest blad? Dostaje komunikat Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /apache/apache-common/virt/virtuals/virt-699640/witryna/select.php on line 12

[PHP] pobierz, plaintext 
<?php
$connect = mysql_connect("xxx") or die ("Sprawdź połączenie z serwerem.");
 
mysql_select_db("xxx");
 
$query = "SELECT nazwa. brutto " .
"FROM 2009p " .
"WHERE producent = BOSCH " .
$results = mysql_query($query)
or die (mysql_error());
 
while ($row = mysql_fetch_assoc($results)) {
foreach ($row as $vall) {
echo $vall;
echo " - ";
}
echo "<br>";
}
 
?>
[PHP] pobierz, plaintext 

[carlo497]

komunikat You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '2009 WHERE producent = 'Amica'' at line 1. Nazwa tabeli to 2009