Re: [PHP-DB] Re: filter search
On Tue, Apr 19, 2011 at 7:41 PM, Jim Giner wrote:O > No follow-up? I must have made complete sense!! :) Either that or (based on the initial post) he had *no* idea what you were talking about. Ken -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Fwd: [PHP-DB] Books
This question is asked all the time -- the trouble is that the answer is too personal to be of any use to you. People's recommendations will change based on: -- experience (no programming vs. some vs. a lot), -- history (programmed in X, not in Y and vice-versa) -- age (young farts vs. we wise sages) -- educational background (technical vs. not and more) What I used to tell me students (when there were only books) was this: go to the book store: -- pick up a book that is coded to your self-assesses skill: beginner, etc. -- Look at the Table of Contents: does the language meld with yours? -- Go to the index: Try to look up something you are wondering about, or a problem you have. If you can find pertinent information -- buy it Try another one... Ken -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Is this syntax is correct?
Amit Tandon wrote: SELECT d.username, r.password FROM data join registration r on r.username SELECT username FROM data, password FROM registration WHERE username=%s AND password=%s" Oh, boy -- "r on r"?? Obviously the guy is a rookie. Let's be simple: SELECT data.username,registration.password FROM data inner join registration ON data. = registration. WHERE username=%s AND password=%s" is the name of the common field in each table, such as "user_id". Comments: 1. "data" is a really bad name for a table. You will confuse the heck out of yourself and others who follow you. Change it. 2. As Amit kind of said, no password should be stored in a table (available on a web server) without encrypting the password information. Ken -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php