Hi Ian Bambury, Ha, Ha.................
I do manage in the same manner It infact assist me when I need to hand over the programme to different person, so that I'd be important person in any modification of the software. Since while working in ASP, PHP I need to distribute the source code to run the programme. Even in future another application is communicating with the database I'd be called to do. If you know better way to encrypt the programme please advice me. Any way last sql for 2 table worked fine. I'd replied you, perhapes you overlooked that. That is working fine. In fact the problem was in my script. When I used your script then worked fine. I tried in te same manner and took assistance from My SQL.com The sql is givng me out put but not right what desired to. So if you can then please. I'm able to solve the problem through script, but if I can solve through SQL then it would be best. Thank you with regards, Mukesh Kumar ----- Original Message ----- From: "Ian Bambury" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Thursday, October 20, 2005 7:50 PM Subject: Re: [php-list] Re: select Sql required > Wow! What have you got against readability? Rule 1: Give things meaningful > names! How would you cope with life if your dining table was called > "thing1", the door "thing23", and your childres "thing97", thing128a" and > "thing128b" (the twins)? > Also: Did you look at the example I sent? Each table you add needs a > separate 'JOIN'. I didn't use an 'and' anywhere. > With respect, I think that you are out of your depth here. But if you want > to keep trying, try to get 3 tables working by replacing a, b, and c with > your table names, and use SELECT * so you don't have to mess around with all > the names. Then try to add the 4th table. If I understand you attempt, you > don't need any parentheses at all. And really you'd be better off setting up > foreign keys, but let's try to get it working like this first, okay? > Ian > > > [Non-text portions of this message have been removed] > > > > > Community email addresses: > Post message: [email protected] > Subscribe: [EMAIL PROTECTED] > Unsubscribe: [EMAIL PROTECTED] > List owner: [EMAIL PROTECTED] > > Shortcut URL to this page: > http://groups.yahoo.com/group/php-list > Yahoo! Groups Links > > > > > > > > > > > [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/HKFolB/TM --------------------------------------------------------------------~-> Community email addresses: Post message: [email protected] Subscribe: [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] List owner: [EMAIL PROTECTED] Shortcut URL to this page: http://groups.yahoo.com/group/php-list Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php-list/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
