@ guelphdad - it does not make sense there is nothing special about that table that you would have to convert anything in order to del a row. Lets say i wanted to delete a user with the sha1 password of some encrypted value, it would not matter, all i have to do is say delete from table where password = "the encrypted value" hard coded and it delets the row.
So even if it is a sha1 value i would not matter.
i tried =".$val." and ="$val" and ='$val' and '.$val.' just to see if i could get something to register and nothing all it gave me was errors if i changed it to anything other than ='.$val;
i even tried WHERE id=3a226b173e49ffd3d32d416174455354;
and WHERE id="3a226b173e49ffd3d32d416174455354" which are both live connection values
all it gives me is whitespace and tstring tconstant errors.
This is the only thing it will accept, but it does not delete the row
$query = 'DELETE FROM '.$GLOBALS['fc_config']['db']['pref'].'connections WHERE id='.$rid;
and the echo of $rid is 3a226b173e49ffd3d32d416174455354
here is the echo of $query
DELETE FROM chat_ connections WHERE id=3a226b173e49ffd3d32d416174455354
yeah i see the space after _ i will fix that..
Update nope still nothing even after fixed the space issue.
what i might have to do is add another field to the table that is int and autoincrement and then do the query on that and see if that works
Another Update i did not get an error with this either just tried it the query echo is the same as above (minus the space)
But also did not delete the row
$query = "DELETE FROM ".$GLOBALS['fc_config']['db']['pref']."connections WHERE id="."$rid";