Mysql Module

[Aaron_H]

Hi all,

I am currently develeping a module like the File Upload, accept i have developed all the scripts, i want one of the tabs in the admin section to allow admins to upload files to a directory but at the same time insert data they fill in, into a mysql table, the mysql INSERT side of thing does not seem to be working tho?

Basicly:

Form Variables -> Php Handler -> Database

Thanks

[alby]

Form Variables -> Php Handler -> Database

I don't see any problem, many modules do it: Cataloger, Album, ....
Look in these code

Alby

[Aaron_H]

Hi,

I have tried the script from the news system, cutting out the mysql insert, no look though,

any more help greatly appreciated, thanks.

[alby]

I have tried the script from the news system, cutting out the mysql insert, no look though,

In general you put many die statement and go for debug or if you have sql problem only check in sql tool (ex: phpmyadmin your query)

Alby

[Aaron_H]

Thanks for the advice,

I am not the best programmer, i havent been doing it at a advacned level realy,

Is it:

$query = 'INSERT INTO '.cms_db_prefix().'module_homework (class, type) VALUES ('.$img.','.$img.')';
$db->Execute($query);

its probaly rong so help would be nice.

Thanks

[alby]

$query = 'INSERT INTO '.cms_db_prefix().'module_homework (class, type) VALUES ('.$img.','.$img.')';

No,
$query = "INSERT INTO ".cms_db_prefix()."module_homework (class, type) VALUES ('$img','$img')";

Alby

[Aaron_H]

Alby thanks alot for your help,

i have had it working now, however some new help is needed, one one of the tabs i want a file manager, so they can view the homework files they uploaded and manage them, now is it possible to copy part of the file manager script into new files in my homework module, if not how would i got about doing the file manager.

THankss