Jump to content

Can't view new data


ivan

Recommended Posts

At the moment I have 9 entries in my database. But I can only view the first 8.

 

Results that I get:

select ID from webTimeFox; Result = 8 entries

select * from webTimeFox; Result = 9 entries

select ID from webTimeFox WHERE ID = 9; Results = 0 entries

 

BUT, if I empty the table and then reload the data, all of the data is seen. But once again when I enter new data, the new entry is not seen. Only having problem with this table. I have other tables on other databases that work fine.

 

Has anyone ever seen this? Or does anyone have any suggestions or answers to my problem.

 

I hope what I wrote makes sense.

 

Thanks,

 

Ivan

Link to comment
Share on other sites

| Field | Type | Null | Key | Default | Extra |

| ID | int(11) | | PRI | NULL | auto_increment |

| entryName | varchar(60) | | | | |

| dateEntered | datetime | | | 0000-00-00 00:00:00 | |

| clientName | varchar(60) | | | | |

| clientContact | varchar(60) | | | | |

| clientPhone | varchar(20) | | | | |

| wbsNumber | varchar(20) | YES | | NULL | |

| chargeCode | varchar(20) | YES | | NULL | |

| costCenter | varchar(20) | YES | | NULL | |

| projectCode | varchar(20) | YES | | NULL | |

| projName | varchar(60) | | | | |

| scope | tinytext | YES | | NULL | |

| audience | varchar(60) | YES | | NULL | |

| disease | varchar(40) | YES | | NULL | |

| eCatalog | char(3) | YES | | NULL | |

| projManager | varchar(60) | | | | |

| artist | varchar(35) | YES | | NULL | |

| startDate | date | YES | | NULL | |

| dueDate | date | YES | | NULL | |

| descp | text | YES | | NULL | |

Max display rows exceeded.

Number of Results: 22

 

I\'m running these queries through php, but when i was getting this problem i decided to try them in the console through mysql itself and came up with the same problem.

 

This script works: select ID from webTimeFox WHERE ID = 9 OR projectCode=\'9\';

 

Of course projectCode is never going to equal 9, but ID will. Doing the query this way works. But not when you do it by itself: select ID from webTimeFox WHERE ID = 9;

 

I worked around it, but it still doesn\'t make sense. If i restart the machine, then I\'m able to see the new entry (latest entry). But when I add a new one, I can\'t see that one. Only happening with this table in this database.

 

WEIRD.

 

Fairly new to PHP and MySQL picking it up day by day and loving it. I guess also loving the fact that i can do it on my PowerBook G4.

 

Ivan

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.