Re: [PHP-DB] Re: [PHP] Best practices for using MySQL index

2008-05-10 Thread Gergely Hodicska
Hi! While this is not a MySQL mailing list, I try to give you some hints and keep it short. There is maybe one important thing which should considered: clustered index. If use InnoDB you can think about to not using a surrogate key but a natural one which best support the query which you

[PHP-DB] Inner joining 3 tables

2008-05-10 Thread Ron Piggott
How do I inner join 3 tables together? What would the syntax look like for this situation: Table 1 and table 2 have a common field; Table 2 and table 3 have a common field Ron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Inner joining 3 tables

2008-05-10 Thread Yves Sucaet
select * from table1 inner join table2 on (table1.common1 = table2.common2) inner join table3 on (table2.common2 = table3.common3) HTH, Yves - Original Message - From: Ron Piggott [EMAIL PROTECTED] To: PHP DB php-db@lists.php.net Sent: Saturday, May 10, 2008 4:33 PM Subject:

[PHP-DB] input field validation

2008-05-10 Thread arafat uddin
hi, i want to input only integer in my field.if without integer any input put in the field it will show warning messege. such as 12 will be accept but 12sds will not accept . fhe34 will not accept plz help me by any javascript code. -- PHP Database Mailing List (http://www.php.net/) To