Jump to content

ivan

New Members
  • Posts

    2
  • Joined

  • Last visited

    Never

Contact Methods

  • AIM
    ford7702

Profile Information

  • Gender
    Not Telling

ivan's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. | 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
  2. 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
×
×
  • 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.