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. Quote Link to comment 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.