How to edit the database manually?

[00king00]

Hi there,

I delete some users from the database related to a script I am working at it.

But, after I deleted those (users) the script memberlist shows (blank spaces) insted of clear list of users in the script.

For example:

((Before the delete from the database)) the memberlist view like this:

1. User A
2. User B
3. User C
4. User D
5. User F
6. User G


((After the delete from the database )) the memberlist view like this:

1. blank
2. User B
3. blank
4. User D
5. blank
6. blank

I know I must delete the users from the script admin itself, but I dosen't know that the blank space will remain the script members list?

My Quesation, How I can delete the (blank space) in the member list? and how I can edit the database manually?!

Thanx

 

[Peter]

It is difficult to say as we do not know what the cause of the problem is.

There are several reasons why this might happen, the most obvious is when using joins in the SQL,

 

[Kate]

It's difficult to say without knowing the script or seeing some code but I suspect the memberlist is based on a SQL statement with more than one table (JOIN), there is data in one table that doesn't match the other end and the script displays Blank as a substitue for NULL.

 

[AndrewRae]

If you use CPANEL you should have phpmyadmin and that will allow you to easily sort results by name and the blank entries will appear at the top.

Otherwise, a lesson needs to be learned here: ALWAYS BACKUP