Re: [php-list] Login System

2006-07-21 Thread Amit Sharma
Check this out http://forums.munk.nu/forumdisplay.php?fid=1 It has simple auth script which uses mysql database to verify a user and then start a session for the user. Very easy to implement and ease of use On 7/15/06, Mohamed Moustafa <[EMAIL PROTECTED]> wrote: > >Hello Guys, > I'm look

Re: [php-list] Empty values in MySql DBs

2006-07-21 Thread Bob
- Original Message - From: Mike Brandonisio I'll take a wild guess. Maybe $email needs more testing like: if ( strlen($email) >2) $email might be an empty string but still exist. Also if you have a default value set for the field in mysql, you do not need to set the field to get the

Re: [php-list] Empty values in MySql DBs

2006-07-21 Thread Mike Brandonisio
Hi, I'll take a wild guess. Maybe $email needs more testing like: if ( strlen($email) >2) $email might be an empty string but still exist. Also if you have a default value set for the field in mysql, you do not need to set the field to get the default do not assign a value. Also do not assi

[php-list] Empty values in MySql DBs

2006-07-21 Thread Bob
I'm having trouble understanding mysql (version 3.23) and I'm using php4. In my home grown message board, if someone leaves a question, it gives them the option of leaving an email. If someone replies to their question, it emails them that someone has replied. In the query, I use: if ($email) {

Re: [php-list] Login System

2006-07-21 Thread Pete
In message <[EMAIL PROTECTED]>, Brian E Boothe <[EMAIL PROTECTED]> writes >HI all , > I,m needing Database validation, I don't see any validation here... > that whenever Someone Enters >something into my Currennt database , i need to check if it exsists >first, and if it does it just add's On

Re: [php-list] Login System

2006-07-21 Thread Wade Smart
07212006 0832 GMT-6 PHP For the World by Web by Larry Ullman Chapter 8, page 212 On Fri, 2006-07-21 at 08:19 -0500, Brian E Boothe wrote: > HI all , >I,m needing Database validation, that whenever Someone Enters > something into my Currennt database , i need to check if it exsists > first,

Re: [php-list] Login System

2006-07-21 Thread Brian E Boothe
HI all , I,m needing Database validation, that whenever Someone Enters something into my Currennt database , i need to check if it exsists first, and if it does it just add's One to the qty, thanks > > Yahoo! Groups Sponsor ---

Re: [php-list] MYSQL

2006-07-21 Thread Phill Sparks
It's often good practice with multiple tables to reference them when you refer to the fields also, eg table1.field1, table2.field3, e.t.c.; I'm not sure whether the brackets are needed, or indeed in the right place however the rest looks okay. With MySQL it may be useful to note that... SELECT f

[php-list] MYSQL

2006-07-21 Thread Prinze Adam
Hello, Is this the right way to join 4 tables? SELECT f1, f2, f3, f4 FROM ( ( FIRST LEFT JOIN SECOND ON idf1= idf2 ) LEFT JOIN third ON idf2= idf3 ) LEFT JOIN fourth ON idf2 = idf4 LIMIT 30 - Yahoo! Music Unlimited - Access ove