www.webdeveloper.com
Results 1 to 5 of 5

Thread: Application form problem (mySQL)

  1. #1
    Join Date
    Feb 2010
    Posts
    47

    Application form problem (mySQL)

    Dear all,

    I have created an application form with PHP and MySQL.

    Each time someone submits the form, the data goes to my server. When I search for the person who has 'applied'... sometimes hes/shes name goes to the end or to the middle of the pages, even though I have sorted them by IDs.

    At the beginning, I thought that my database couldn't held all the numbers of the people who 'applied', so I started deleting them.

    But, seems that this was not the case, since the problem showed up again.

    Does anybody know why this is happening?

    Thanks in advance.

  2. #2
    Join Date
    Aug 2004
    Location
    Ankh-Morpork
    Posts
    19,325
    Quote Originally Posted by rreze View Post
    ...
    Does anybody know why this is happening?
    ...
    No idea without any idea what your database or code looks like, what your query is sorting on, etc.
    "Please give us a simple answer, so that we don't have to think, because if we think, we might find answers that don't fit the way we want the world to be."
    ~ Terry Pratchett in Nation

    eBookworm.us

  3. #3
    Join Date
    Feb 2010
    Posts
    47
    Here are some details that can help:

    MySQL client version: 5.1.30
    See attach.
    Attached Images Attached Images
    • File Type: gif 1.gif (36.0 KB, 111 views)
    • File Type: gif 2.gif (3.6 KB, 117 views)

  4. #4
    Join Date
    Feb 2010
    Posts
    47
    Do you need more info?!

  5. #5
    Join Date
    Aug 2004
    Location
    Ankh-Morpork
    Posts
    19,325
    I don't know precisely why you are seeing that behavior, but if I were doing it, I would sort on your "date" (timestamp) column, as it is more semantically meaningful for that context anyway. It is generally best to use an auto-increment integer column only as an identifier, not for any other purpose (such as sorting).
    "Please give us a simple answer, so that we don't have to think, because if we think, we might find answers that don't fit the way we want the world to be."
    ~ Terry Pratchett in Nation

    eBookworm.us

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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



Recent Articles