Can't view new data

[ivan]

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

[effigy]

very odd. can you show us the table structure? you can get it via: DESCRIBE table_name;

 

are you running these queries through php or directly in mysql? if php, show us your code.

[ivan]

| 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