Database Table Update/Delete Issue

Hi,

I know this issue might have been brought up way too many times, but I have tried most solutions posted, but to no avail.

I have a form that allows users to update information in the database. The following php codes are placed in "On Submit code - after":

$sql = "UPDATE  #__events SET organiser='$_POST[organiser]' WHERE name='$select';";
$database->setQuery($sql);
$database->query();

These codes have been simplified. I have included codes to throw me error messages, but no error messages are thrown and the table is simply not getting updated.

I tried another solution, which was to delete and re-insert the whole row of data again. Inserting was not an issue (it had never been), but the same problem occurs when I try to delete. The row of data is not deleted and no error message are thrown.

Any help will be greatly appreciated!

Eric

Hi Eric,

Please post the 'unsimplified' code. It's impossible to tell what's wrong from this snippet. At the very least it should look something like this

<?php
$database =& JFactory::DBO();
$sql = "UPDATE  #__events SET organiser='$_POST[organiser]' WHERE name='$select';";
$database->setQuery($sql);
$database->query();
?>

and I still have no idea where '$select' comes from??

Bob

Hi Bob,

I have solved my problem all thanks to the one question that you asked....
"and I still have no idea where '$select' comes from??"

Thank you!

Regards,
Eric