Professional Web Applications Themes

Missing Table Entries - MySQL

Very weird problem here. We have an HTML form/PHP script which writes comany listings to a database. Everything was working fine. One of my coworkers who is not in today, setup a new user. This new user can enter listings into the database. The PHP script also has the option to search the database and display the results. The new user can search for the company she just entered and it shows up on the PHP page. However, a search of the database itself doesn't show the company that was just added. I have to do a very specific search ...

  1. #1

    Default Missing Table Entries

    Very weird problem here. We have an HTML form/PHP script which writes
    comany listings to a database. Everything was working fine. One of my
    coworkers who is not in today, setup a new user. This new user can
    enter listings into the database. The PHP script also has the option to
    search the database and display the results. The new user can search
    for the company she just entered and it shows up on the PHP page.

    However, a search of the database itself doesn't show the company that
    was just added. I have to do a very specific search for one of the
    columns before the listing will show up. But it doesn't show up in any
    "SELECT * FROM table()" or "SELECT * FROM table() WHERE
    company="company name" statements. I am just wondering if there is some
    sort of "Hide" option for a row that would cause it not to be a part of
    a normal query. Or has anyone run into this problem before. I am using
    MySQL 5.

    Again, the only query that will find the company, is if you define the
    specific value in a column called reserved_1. I can look on the PHP
    form to see what that value is for the company and then search in SQL
    using "SELECT * FROM table() WHERE reserved_1="some number". That is
    the only way to find the company in the database.

    Jerim79 Guest

  2. #2

    Default Re: Missing Table Entries

    Jerim79 wrote: 

    No, there isn't any way to "hide" information like this. A SELECT *
    statement will return all rows in the table.

    Are you sure you aren't maybe selecting from a view? And have you tried
    it from a MySQL command line prompt, just to make sure?

    Also, SELECT * FROM table() is invalid syntax, but I suspect that was
    just a typo on your part.

    This one is strange.

    --
    ==================
    Remove the "x" from my email address
    Jerry Stuckle
    JDS Computer Training Corp.
    net
    ==================
    Jerry Guest

  3. #3

    Default Re: Missing Table Entries

    >Very weird problem here. We have an HTML form/PHP script which writes 

    Could this be an issue of the connection that inserted the data can
    see an as-yet-uncommitted transaction but the others can't, because
    it isn't committed yet?

    Gordon Guest

Similar Threads

  1. Replies: 1
    Last Post: July 10th, 11:08 AM
  2. Multiple Sub Table Entries
    By sbowker in forum Dreamweaver AppDev
    Replies: 0
    Last Post: February 27th, 10:21 PM
  3. Replies: 0
    Last Post: February 17th, 08:46 PM
  4. Replies: 0
    Last Post: October 18th, 05:36 PM
  5. Form - table entries
    By Jim Kennedy in forum Microsoft Access
    Replies: 3
    Last Post: July 10th, 06:47 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139