OriginalSunny Posted March 25, 2006 Share Posted March 25, 2006 Hi, I am using the following .inc file:[i]$sql = "DELETE FROM Orders where ID = '$ID'"; mysql_query($sql);[/i]and the following code in my .php file [i]<tr><td align="right"><b>ID</b></td> <td><input type="text" name="ID" value="<?php echo @$ID ?>" size="10" maxlength="10"></td></tr> <tr><td align="center" colspan="2"> <input type="submit" value="Remove"></td></tr>[/i]and instead of removing the row from the database, a new row is added to the database only storing the ID. Does anyone know why this is happening?? It seems strange. Link to comment https://forums.phpfreaks.com/topic/5767-adding-data-to-the-database-when-it-should-be-deleting/ Share on other sites More sharing options...
OriginalSunny Posted March 25, 2006 Author Share Posted March 25, 2006 It shouldnt make a difference but just thought i would mention ID is a primary key and is auto incremented. Link to comment https://forums.phpfreaks.com/topic/5767-adding-data-to-the-database-when-it-should-be-deleting/#findComment-20547 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.