SQL error: [MySQL][ODBC 3.51 Driver][mysqld-4.0.18-nt] Opcje

[Zbłąkany]

Nawiazanie do watku: sciagnalem odbc connectora 3.51 dla mysql 4.18 napisalem taki kod:
[php:1:80cc1114e7]<?php
set_time_limit(0);
$hostms="localhost";
$hostmy="sklep";
$userms="sa";
$usermy="root";
$passms="";
$passmy="czarownik";
$tablems="sl_GrupaTw";
$tablemy="sl_grupatw";
$valuesms="grt_Id,grt_Nazwa";
$valuesmy="grt_id,grt_nazwa";
/* $connectmy=odbc_pconnect($hostmy, $usermy, $passmy);
$querymy="CREATE TABLE $tablemy (grt_Id INT NOT NULL, grt_Nazwa VARCHAR(30) NOT NULL)";
$execmy=odbc_exec($connectmy, $querymy); */
$connectms=odbc_pconnect($hostms, $userms, $passms);
$queryms="SELECT $valuesms FROM $tablems";
$execms=odbc_exec($connectms, $queryms);
while(odbc_fetch_row($execms)){
$ms_grt_Id=odbc_result($execms,1);
$ms_grt_Nazwa=odbc_result($execms,2);
$connectmy=odbc_pconnect($hostmy, $usermy, $passmy);
$querymy="INSERT INTO $tablemy(grt_id, grt_nazwa) VALUES($ms_grt_Id, $ms_grt_Nazwa)";
$execmy=odbc_exec($connectmy, $querymy);
echo("$ms_grt_Id, $ms_grt_Nazwa<br>");
}
?>[/php:1:80cc1114e7]
I tu pojawia sie problem:

Kod

Warning: odbc_exec(): SQL error: [MySQL][ODBC 3.51 Driver][mysqld-4.0.18-nt]Unknown column 'Podstawowa' in 'field list', SQL state S0022 in SQLExecDirect in C:Program FilesApache GroupApache2htdocsstronamojpublic_htmlupdate2.php on line 24

1, Podstawowa



Warning: odbc_exec(): SQL error: [MySQL][ODBC 3.51 Driver][mysqld-4.0.18-nt]Unknown column 'Dezodoranty' in 'field list', SQL state S0022 in SQLExecDirect in C:Program FilesApache GroupApache2htdocsstronamojpublic_htmlupdate2.php on line 24

2, Dezodoranty



Warning: odbc_exec(): SQL error: [MySQL][ODBC 3.51 Driver][mysqld-4.0.18-nt]Unknown column 'Perfumy' in 'field list', SQL state S0022 in SQLExecDirect in C:Program FilesApache GroupApache2htdocsstronamojpublic_htmlupdate2.php on line 24

3, Perfumy



Warning: odbc_exec(): SQL error: [MySQL][ODBC 3.51 Driver][mysqld-4.0.18-nt]Unknown column 'Pomadki' in 'field list', SQL state S0022 in SQLExecDirect in C:Program FilesApache GroupApache2htdocsstronamojpublic_htmlupdate2.php on line 24

4, Pomadki



Warning: odbc_exec(): SQL error: [MySQL][ODBC 3.51 Driver][mysqld-4.0.18-nt]Unknown column 'Pudry' in 'field list', SQL state S0022 in SQLExecDirect in C:Program FilesApache GroupApache2htdocsstronamojpublic_htmlupdate2.php on line 24

5, Pudry



Warning: odbc_exec(): SQL error: [MySQL][ODBC 3.51 Driver][mysqld-4.0.18-nt]Unknown column 'Wody' in 'field list', SQL state S0022 in SQLExecDirect in C:Program FilesApache GroupApache2htdocsstronamojpublic_htmlupdate2.php on line 24

6, Wody



Warning: odbc_exec(): SQL error: [MySQL][ODBC 3.51 Driver][mysqld-4.0.18-nt]Unknown column 'Zestawy' in 'field list', SQL state S0022 in SQLExecDirect in C:Program FilesApache GroupApache2htdocsstronamojpublic_htmlupdate2.php on line 24

7, Zestawy



Warning: odbc_exec(): SQL error: [MySQL][ODBC 3.51 Driver][mysqld-4.0.18-nt]Unknown column 'Komputery' in 'field list', SQL state S0022 in SQLExecDirect in C:Program FilesApache GroupApache2htdocsstronamojpublic_htmlupdate2.php on line 24

8, Komputery

Tabela jest utworzona poprawnie zapytanie jest zrobione jako komentarz szukalem na necie podobnych bledow ale niestety nic nie znalazlem