Databases: Need help with INSERT

Databases: Need help with INSERT

Javier Martínez Alfonso írta időpontban
Válaszok szám: 3
Hi everybody!

I have a php file which, among other things, has the following:

execute_sql("INSERT INTO mdl_p_resumenes (id, nombre, area, evaluador) VALUES ('$id_autor', '$original', '$destino', '$evaluador2')");

As you can see, I´m trying to insert a new row in the table mdl_p_resumenes, but it doesn´t work! It returns an error szomorú.

But if I try it with some certain values it works and it adds a new row:

execute_sql("INSERT INTO mdl_p_resumenes (id, nombre, area, evaluador) VALUES ('10', 'archivo.txt', 'area del congreso', '15')");

I also check $id_autor, $original... before doing that, and they all have the right values.

Can somebody help me please???

Értékelések átlaga: -
Válasz erre: Javier Martínez Alfonso

Re: Databases: Need help with INSERT

Javier Martínez Alfonso írta időpontban
I´ve just solved it, the problem wasn´t there
Értékelések átlaga: -
Válasz erre: Javier Martínez Alfonso

Re: Databases: Need help with INSERT

Tim Hunt írta időpontban
Kép Kép Kép Kép Kép
But you probably ought to be using the insert_record function instead.
Értékelések átlaga: -
Válasz erre: Tim Hunt

Re: Databases: Need help with INSERT

Ger Tielemans írta időpontban

In the old version of Moodle I hacked the rights of the admin in such a way that course creators could adress a course to a teacher EVEN when the were not a teacher of that course themselves.

I gave up this dangeruous hacking and try now to use this function, but it seems not to work:

add_teacher($userid, $courseid, $editall=1, $role="teacher", $timestart=0, $timeend=0, $enrol="manual");

I populate userid and courseid, but..

any idea?

Értékelések átlaga: -