[PHP-DB] Username/Password retrieval

2001-01-12 Thread Randy Johnson
Is the following statement the best way to handle a username/password validation $username and $password are form fields $result=""; $result= mysql_query (" Select password from ACCT_TBLE where (ACCT_NUM = '$username' and PASSWORD='$password')"); Now my question is will result be equal to "" if

[PHP-DB] query error

2001-01-25 Thread Randy Johnson
When I run any kind of query this is the value of result Resource id #2 Example $result= mysql_query (" Select * from ACCT_TBL ") or die ("Error".mysql_error()); print result; any ideas? randy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For

[PHP-DB] RE: Doing multiple updates

2001-01-30 Thread Randy Johnson
Does the Connection ID change if I use persistent connection through PHP using mysql_pconnect()? Is it possible to retrieve CONNECTION_ID() this though PHP? -Original Message- From: The Tilghman [mailto:[EMAIL PROTECTED]] Sent: Monday, January 29, 2001 4:31 PM To: 'Randy Jo

[PHP-DB] PHP/MySQl Consultation

2001-08-24 Thread Randy Johnson
I am in need of someone that is very good at PHP and MySQL to view my scripts and discuss with me in detail on how to speed up my scripts and how to speed up mysql some. if you are interested please send me credentials and rates ASAP please send them to [EMAIL PROTECTED] Thank you, Randy --