This issue may kill me, delete from array

vividona

I have data of usernames in my database
like this:

uid | Username |
1 | John, Farida, Mimi, George, Jack, Susan |

I tried to fetch the username column like an array using (explode).
I do that according to (Get link) like this:

http://www.xxxxxx.com/index.php?action=delete&uid=1

I need to delete only one username from username and the other usernames remain as shape that shown above

Krik

$username = explode(',' $_GET['uid']);

$newusername = '';
foreach ($i = 0; $i <= count($username); $i++) {

if ($username[$i] != trim($deleteusername)) {
    $newusername .= $username[$i] . ',';
}
}

Now I put the user ids that were not to be deleted into a string instead of an array as you are storing them as a string. If you need them in the an array for some other operation

$newusername = array();
foreach ($i = 0; $i <= count($username); $i++) {

if ($username[$i] != trim($deleteusername)) {
    $newusername[] = $username[$i];
}
}

NogDog

Possibly a better solution would be a database redesign so that you are not storing multiple, discrete values in one field. 😉

bradgrafelman

NogDog;10958975 wrote:
Possibly a better solution would be a database redesign so that you are not storing multiple, discrete values in one field. 😉

I heartily agree with NogDog's advice. I'd also recommend reading some good articles on "Database Normalization" before you make any changes to your DB (or designing any others :p).