Sponsored by NuSphere - PHP Software for PHP Application Developers - On Sale This Week for $100



Go Back   PHP-Editors > Linux, Apache, MySQL > MySQL Help

MySQL Help Post any question relating to MySQL here and hopefully someone can help

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 2007-07-15, 03:22 PM
Junior Member
 
Join Date: Mar 2007
Posts: 10
00king00 is on a distinguished road
Exclamation How to edit the database manually?

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
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 2007-07-16, 08:53 PM
Member
 
Join Date: Jan 2007
Location: SPb, Russia
Posts: 30
powerdesign is on a distinguished road
Default

I suggest you must check the sctipt that output users
not enough information to help you
Reply With Quote
  #3 (permalink)  
Old 2007-08-02, 11:59 AM
Member
 
Join Date: Oct 2006
Location: London
Posts: 33
JustPHP is on a distinguished road
Send a message via MSN to JustPHP Send a message via Yahoo to JustPHP Send a message via Skype™ to JustPHP
Default

Looks like the users have not been completely deleted from the database,(user names have been deleted not their id or unique/primary key) they exist in another table, and or your sql statement which retrieves the data from the database is using a join.
Reply With Quote
Must read Review for Serious PHP Developers


NuSphere PhpED 5.0 : The Staff of php-editors.com recently spent a few days working with NuSphere PhpED 5.0 (a popular PHP IDE) and NuCoder 1.4 (a PHP Encoding Utility), read up on all the details.

Sponsored Links
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 10:32 AM.


Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
LinkBacks Enabled by vBSEO 3.1.0
© Copyright 2003-2008 www.php-editors.com. The ultimate PHP Editor and PHP IDE site.