mySql Delete only removes the data not the entire entry

Posted by Mick on Stack Overflow See other posts from Stack Overflow or by Mick
Published on 2010-04-03T21:40:36Z Indexed on 2010/04/03 21:43 UTC
Read the original article Hit count: 210

Filed under:
|
|

Hi all I have this line in my php code $insert = "DELETE FROM allocation_table WHERE job = '$jobnumber' " ; Mysql_query ($insert) ;

The problem is it will remove all the values from the the one line in my table but not the entry itself. as you can see in the picture if I delete where job = 315 , it does not delete the line but does delete all the entries

Yet in this code that preceeds it (a different table) . it works fine and the whole line is removed

$insert = "DELETE FROM event WHERE jobnumber = '$jobnumber' " ; 
mysql_query ($insert) ;enter code here

can anyone offer some advice please ?? alt text

© Stack Overflow or respective owner

Related posts about mysql

Related posts about myphpadmin