Form using mysql problems

[look_at_me]

Hi !
I've got the following in my admin-section on a gallery site where ppl can submit their art:
http://kingsize.1go.dk/reports.txt

The problems are:

When i press the "delete report and blacklist" button (delblack function), the report is deleted. But the data isn't submitted to the "blacklist" table.

When a report is checked and you press the individual blacklist button for that report, the report is deleted but the only thing submitted to the "blacklist" table is the violation.

Any help is highly appreciated...

[ScubaKing22]

From what I can tell the problem is probably in the two queries that look as follows:

mysql_query("DELETE FROM gallery WHERE id='$row[id]'");

When you access the $row array, you should use either $row['id'] or $row[$id], depending on if id is a variable or field name. So from what I see, your query should probably look like this:

mysql_query("DELETE FROM gallery WHERE id='".$row['id']."'");

One more thing you can do is to check out mysql_error(). It will report any errors associated with, well, MySQL. Hope this helps 😉

[look_at_me]

Nahh, that's not where the problem is 🙁
there's something wrong in the delblack function (a == delblack), but i don't see why...the blacklist function works !

[look_at_me]

found the problem.... thanks for the help 🙂