Jump to content


Photo

Adding data to the database when it should be deleting


  • Please log in to reply
1 reply to this topic

#1 OriginalSunny

OriginalSunny
  • Members
  • PipPipPip
  • Advanced Member
  • 95 posts

Posted 25 March 2006 - 02:20 PM

Hi,
I am using the following .inc file:

$sql = "DELETE FROM Orders where ID = '$ID'";
mysql_query($sql);


and the following code in my .php file

<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>


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.

#2 OriginalSunny

OriginalSunny
  • Members
  • PipPipPip
  • Advanced Member
  • 95 posts

Posted 25 March 2006 - 02:51 PM

It shouldnt make a difference but just thought i would mention ID is a primary key and is auto incremented.





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users