| 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