Hi Mukesh, I'm missing the sql to put a record into the ft02tbl, if you send it, then I can send you a working program As for making the code more unreadable - try having variables like llllllllllll1, lllllllllll1l, llllllllll1ll,l1lll1lllll1l,lllllllllllll1 - i.e. mix lower case 'L's and numeric 1's - and have lengths of, say, 23, 24, and 25 characters - or replace them with guids.
:-) Ian On 10/21/05, Mukesh Kumar <[EMAIL PROTECTED]> wrote: > > 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] > > > > 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 > > > > SPONSORED LINKS > Php > mysql<http://groups.yahoo.com/gads?t=ms&k=Php+mysql&w1=Php+mysql&w2=Job+postings&c=2&s=33&.sig=FLGkJVBUdDMln4PBO26sng> > Job > postings<http://groups.yahoo.com/gads?t=ms&k=Job+postings&w1=Php+mysql&w2=Job+postings&c=2&s=33&.sig=cV3rp9pSpCxahJy7imon_w> > ------------------------------ > YAHOO! GROUPS LINKS > > > - Visit your group "php-list<http://groups.yahoo.com/group/php-list>" > on the web. > - To unsubscribe from this group, send an email to: > [EMAIL PROTECTED]<[EMAIL PROTECTED]> > - Your use of Yahoo! Groups is subject to the Yahoo! Terms of > Service <http://docs.yahoo.com/info/terms/>. > > > ------------------------------ > [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/
