This is puzzling

[Goonboonie]

Hi,

I have the following code which is supposed to delete a record when a delete button on the web page form is pushed.

if(isset($_POST['submit'])) {

$query = "Delete FROM registerINFO_table WHERE register_id='$register_id'";
mysql_query($query);

}

Why is the record not being deleted when this code is called?

Thanks

G

[LordShryku]

Use [man]mysql_error[/man]

[mtimdog]

Also, $register_id may have to be $_POST['register_id'] if it's being passed and register_globals is off.

[Goonboonie]

Hi,

Thanks. How would you set up : $_POST['register_id']
in the code?

[mtimdog]

$POST refers to the global array whose values it gets from forms that 'post'. In those forms, the names of the textboxes, textareas, selects, etc get put into the $POST array when the form is sent with action='post'.

I wasn't sure how you were setting up register_id. I assumed that you were posting it from the previous page.