Strange that it will work on items that do not have a space.
To trouble shoot the issue, lets write the SQL being executed to the screen,
change the following line of code:
$MM_editCmd = mysql_query($WA_Sql, $WA_connection) or die(mysql_error());
to:
die($WA_Sql);
$MM_editCmd = mysql_query($WA_Sql, $WA_connection) or die(mysql_error());
this should write SQL similar to:
DELETE FROM `bbc_service` WHERE serviceID = 'South Green'
to check the validity of the SQL, use a tool like PHPMyAdmin or SQLYog to access the database directly and run the query. Try changing it to a SELECT query instead:
SELECT * FROM `bbc_service` WHERE serviceID = 'South Green'
and try changing the where clause to lower case:
SELECT * FROM `bbc_service` WHERE serviceID = 'south green'
the key to a delete statement is in the where clause. Any records returned by the where clause will be deleted, so we need to determine why the where clause is not returning any results.
