Started by MeltingIce, February 14, 2007, 04:22:58 am
Quote from: 3DGuy on February 14, 2007, 03:17:28 pmThat is correct:SELECT password from up_users where username='MeltingIce'You need to put the username in quotes.I would advise you not to store the passwords though and certainly not in cleartext. Always only store password hashes. Hashes can't be reverse engineerd to the original password. Instead when a user enters his name and password, hash the password and compare that to the stored hash. If you continue, make sure you look into SQL injection prevention techniques.Instead of reinventing the wheel, you might look at something like Coppermine. I use it on my own site with a customised template. It allows user galleries with private and public images etc.edit: whoops link fixed.
Quote from: 3DGuy on February 14, 2007, 03:53:24 pmPoint is to not store passwords. Not even crypted
Quote from: old_blaggard on February 14, 2007, 09:40:09 amI've done some PHP and MySQL, although I've never taken a class in it or read a book . I really like your temporary page, by the way; it looks very clean and sharp, just like the rest of your site.