Mysql save/upgrade problem

[equinox]

Hello!

I have a problem with the so_sql function.
I have this code:

$content['nr'] = $count;
$content['subject'] = $content['_psubject'.$count];
$content['teacher'] = $content['_psubject'.$count.'_teacher'];
$content['mark'] = $content['_psubject'.$count.'_mark'];
$content['problems'] = $content['_psubject'.$count.'_problems'];
$content['index'] = $content['index1'];
$this->save($content);

When I execute this the first time, the entries get saved correctly, but when I execute this a second time and it wants to update this error appears:

Invalid SQL: UPDATE egw_schuelerakte_journal_subjects SET id=70,subject='k',nr=1,teacher='k',mark='k',problems='kk' WHERE index=7:
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 'index=7' at line 1

Greetings equinox

[Leithoff_Klaus]

UPDATE egw_schuelerakte_journal_subjects SET id=70,subject=‘k’,nr=1,teacher=‘k’,mark=‘k’,problems=‘kk’ WHERE index=7
its probably as the mysql server says, something wrong with the index=7
index itself may not be used as a columnname. no problem if you do something like tablename.index=7
My suggestion is: rename the column to id, or something similar.

Stylite AG

Morschheimer Strasse 15 | D-67292 Kirchheimbolanden

fon +49 (0)6352 . 70629-0 | fax +49 (0)6352 . 70629-30
email: kl@stylite.de 

Managing Directors: Andre Keller | Ralf Becker | Gudrun Mueller
Chairman of the supervisory board: Prof. Dr. Birger Leon Kropshofer


Commerzbank BLZ 55040022 | Account 218111300
IBAN DE33 5504 0022 0218 1113 00 | BIC COBADEFFXXX
VAT DE214280951 | Registered HRB 31158 Kaiserslautern
Germany

Email written with EGroupware: The software for advanced business communication

[equinox]

thank you!
Now I have an other problem.

I have changed the code to this one:

$content[‘nr’] = 1;
$content[‘subject’] = $content[’_psubject1’];
$content[‘teacher’] = $content[’_psubject1_teacher’];
$content[‘mark’] = $content[’_psubject1_mark’];
$content[‘problems’] = $content[’_psubject1_problems’];
$content[‘egw_schuelerakte_journal_subjects.index’] = $content[‘index1’];
$this->save($content);

But now it doesnt upgrade, it saves only a second entry, when I run it the second time.