Answered
Delete Record
I have created a user list that when I click on a link to
delete a record it goes to a page where I have created a button
called delete user in a form tag.
My issue is that I have been going over this issue where I cannot seem to delete a user and when I click on my button called delete user I get an error that states "Incorrect table name". I really do not know why I am getting this error.
In my user list the link that goes to the deletion page is as follows...
delete.php?userID=<?php echo $row_userIDs['userID']; ?>
My delete.php page has the record set as follows...
SELECT *
FROM `user`
WHERE userID = colname
Name: colname
Type: Numeric
Default value: -1
Runtime value: $_GET['userID']
I do have a hidden field.
<input name="userID" type="hidden" id="userID" value="<?php echo $row_getUser['userID']; ?>" />
For my delete record it states as follows...
First check if variable is defined: Primary key value
Connection: conMyConnection
Table: user
Primary key column: userID [Check Box active] Numeric
Primary key value: Form Variable [userID]
After deleting , go to: index.php
I do not know what I am doing wrong. I tried different settings for the delete record wizard but still not luck. I am wondering if it is a DWCS3 setup because when I used to work on DWMX2004 and I am doing the same steps I would not get an error. So right now I am at a lost trying to figure out am I missing something here, maybe the position of the codes.
Has anyone experienced this issue and resolved it.
My issue is that I have been going over this issue where I cannot seem to delete a user and when I click on my button called delete user I get an error that states "Incorrect table name". I really do not know why I am getting this error.
In my user list the link that goes to the deletion page is as follows...
delete.php?userID=<?php echo $row_userIDs['userID']; ?>
My delete.php page has the record set as follows...
SELECT *
FROM `user`
WHERE userID = colname
Name: colname
Type: Numeric
Default value: -1
Runtime value: $_GET['userID']
I do have a hidden field.
<input name="userID" type="hidden" id="userID" value="<?php echo $row_getUser['userID']; ?>" />
For my delete record it states as follows...
First check if variable is defined: Primary key value
Connection: conMyConnection
Table: user
Primary key column: userID [Check Box active] Numeric
Primary key value: Form Variable [userID]
After deleting , go to: index.php
I do not know what I am doing wrong. I tried different settings for the delete record wizard but still not luck. I am wondering if it is a DWCS3 setup because when I used to work on DWMX2004 and I am doing the same steps I would not get an error. So right now I am at a lost trying to figure out am I missing something here, maybe the position of the codes.
Has anyone experienced this issue and resolved it.
AdChoices