Jump to content


Photo

Can't view new data


  • Please log in to reply
2 replies to this topic

#1 ivan

ivan
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 06 October 2003 - 03:53 PM

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

#2 effigy

effigy
  • Staff Alumni
  • Advanced Member
  • 3,600 posts
  • LocationIL

Posted 06 October 2003 - 11:00 PM

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.
Regexp | Unicode Article | Letter Database
/\A(e)?((1)?ff(?:(?:ig)?y)?|f(?:ig)?)\z/

#3 ivan

ivan
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 07 October 2003 - 02:48 PM

| 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




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users