SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Member
    Join Date
    Aug 2000
    0 Post(s)
    0 Thread(s)
    hi. i am doing our school alumni online registry. I want to know how you get to break search results into 20 and if the total search results found is more than 20, it'll display [Next>>]? I am also wondering how to check the password entered by the user? (in mysql database the password was entered with password($password)). thanks

  2. #2
    SitePoint Author Kevin Yank's Avatar
    Join Date
    Apr 2000
    Melbourne, Australia
    2 Post(s)
    0 Thread(s)
    Splitting up of query results was covered in Part 9: "Advanced SQL" of my series, "Building a Database-Driven Web Site using PHP and MySQL" on The relevant section is entitled "Setting LIMITs".

    As for checking passwords, you can retrieve the encrypted password using a normal SQL SELECT query. Next, get MySQL to encrypt the password the user entered with the following query:

    SELECT PASSWORD("thePassword")

    Finally, compare the two encrypted values. If they are equal, then the password entered is correct!

    -Kevin Yank.
    Helping Small Business Grow Online!


Posting Permissions

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