Cksonline

Thankz Pat I got the solution here is the query that I want SELECT sm.form_no, sm.date_entry_user, sm.upload_img_user, sm.update_user, um.id, um.username, um1.id as id1, um1.username as username1, um2.id as id2, um2.username as username2 FROM `sform_master` sm left join user_master um on (sm.date_entry_user=um.id) left join user_master um1 on(sm.upload_img_user=um1.id) left join user_master um2 on(sm.update_user=um2.id) where sm.date_entry_user!=0 Thankx again pat for your reply Br cksonline

still same

I am trying following query but it also doesn't work SELECT sm.form_no, sm.data_entry_user, sm.upload_img_user, sm.update_user, um.id, um.username, um1.id as id1, um1.username as username1, um2.id as id2, um2.username as username2 FROM `sform_master` sm left outer join (user_master um,user_master um1,user_master um2) on ( sm.date_entry_user=um.id and (sm.upload_img_user=um1.id or sm.upload_img_user IS NULL) and (sm.update_user=um2.id or sm.update_user IS NULL) ) where sm.date_entry_user!=0 form_no data_entry_user upload_img_user update_user id username id1 username1 id2 username2 1000 12 0 0 NULL NULL NULL NULL NULL NULL 1001 12 0 0 NULL NULL NULL NULL NULL NULL 1002 1 0 0 NULL NULL NULL NULL NULL NULL 1003 1 0 0 NULL NULL NULL NULL NULL NULL 1004 2 12 2 2 AB User 12 xyz12 2 AB User 1005 13 12 11 13 abcdef 12 xyz12 11 cksonline 1006 12 0 0 NULL NULL NULL NULL NULL NULL 1007 12 0 0 NULL NULL NULL NULL NULL NULL 1008 12 0 0 NULL NULL NULL NULL NULL NULL 1009 12 0 0 NULL NULL NULL NULL NULL NULL 1010 12 0 0 NULL NULL NULL NULL NULL NULL 1026 13 13 0 NULL NULL NULL NULL NULL NULL 1027 13 0 0 NULL NULL NULL NULL NULL NULL

Ok I try to make it clear Fields for my first table [sform_master] are form_id form_no . . . data_entry_user_id // User who make data entry update_user_id // User who update the form data image_upload_user_id // User who upload image for the forms Fields for second table [user_master] are id username Output I want form No-----------------Data Entry User-------------------Updated By------------------Image Upload By 100----------------------Abc---------------------------------Bcd 101----------------------Abc 102----------------------Abc----------------------------------------------------------------Xyz 103----------------------Abc---------------------------------Xyz 104----------------------Abc---------------------------------Bcd-------------------------- Xyz When I use the query that I use it show only form no 104 and I want all the form details. As form no 101,102,103 has some blank fields so query skip them and show only 104 That's all what I want.... Br cksonline

Thankx Mihai for advice but plz can U help me what I want Is there any body who can help meeeeeeeeeee plzzzzzzzzzzzzzzz Br cksonline

Anyone have any ideas?

Hi all I am trying to fetch data from two tables First one contains form data like form number, ..... data_entry_user, update_user, image_upload_user Second has details about users like user_id, username... What I want to do is to show the details of all forms like when and which user make the data entry or when it get updated and who upload images for it etc... So I need to fetch data form form's table and three usernames from user's table. I am trying multi join but it doesot work Following is the code that I use 'select sm.id,sm.form_no,sm.type,sm.date_of_creation,sm.date_entry_user,sm.update_user,u m_entry.id,um_entry.username as um_entry_username, sm.date_entry_date_time,um_upload.id,um_upload.username as um_upload_username, sm.update_data_time from ' . SFORM_MASTER . ' sm, ' . USER_MASTER . ' um_entry, ' . USER_MASTER . ' um_upload where sm.date_entry_user = um_entry.id and sm.update_user = um_upload.id and .......... order by sm.form_no DESC'; Is there any way to optimize this query? What I think it will be very slow if both the tables have lots of data in it........ br Cksonline

I had protected my PHP code with Zend encoder and testing it on my localhost as there is PHP Optimizer is already installed there but when I run the program it says Zend Optimizer not installed This file was encoded by the Zend Guard. In order to run it, please install the Zend Optimizer (available without charge), version 3.0.0 or later. But when I check PHPInfo() it has the following details This program makes use of the Zend Scripting Language Engine: Zend Engine v2.2.0, Copyright © 1998-2007 Zend Technologies with Zend Extension Manager v1.2.0, Copyright © 2003-2007, by Zend Technologies with Zend Optimizer v3.3.3, Copyright © 1998-2007, by Zend Technologies Zend Optimizer Optimization Pass 1 enabled Optimization Pass 2 enabled Optimization Pass 3 enabled Optimization Pass 4 enabled Optimization Pass 9 disabled Zend Loader disabled License Path no value Obfuscation level 0 Plz help me and let me know where I'm going wrong Br cksonline

Thanks all for your helpful replies, first of all I want to inform U that I am making logo for a web design/development company. It’s a new one. I want to give it a decent look (simple look). Will U plz suggest me what should be there in place of the brushstrokes because I like the font and layout of N10SOLUTIONS. Thankx BrownWarrior I will study this… Thankx Cksonline

Thanks to all I’ve made a new Logo according to your suggestions plz check it and vote which ever U like? If U still want some changes.....welcome..... Br Cksonline

Thankz all I will try to come up with new concept soon Rachael & scaz182 BROs I agree with U both thankx Br Cksonline

Hi buddies, I am trying to make logo for my new website www.n10solutions.com. I am attaching some sample logos, I am totally confused with the designs. Please help me to give a professional look to the logo Thankx Cksonline

Plz check the following link it may help and simply your prob. http://p.sohei.org/jquery-plugins/clickmenu/ For this you need JQuery and your job will be so easy! What I think Br Cksonline

Thanks daviswebdesigns for your reply but what I think it may not be a big issue that we use class or id for our div. Is it effect our div properties? And next I want flexible box with any height and width I am for the time being using the jpg file instead of .png files and the matter solved BUT I STILL WANT TO USE PNG IMAGES AS TO GIVE A TRANSPARENT LOOK TO BOX WITH SHADOW

I am using a different div Plz check it here http://www.nxtdesigns.com/prob/ Thankx Cksonline

Hi all I am new in css and div. I am using two background images first one is with no-repeat attr (for footer of my box), and second Image is with repeat-y for box background. AS the footer image is of 97px so it got overlaped with the box background image. I want that the box body background image should not overlap the footer image ie I want that My box background image should be 100%-97px if possible like this. I can't find any help from my GOOGLE Uncle Thankx Cksonline

Thankx for quick reply I will try Any other why liking using our own classes etc... Br Cksonline

Hi, I want to encrypt my PHP code before giving to my clients. I don’t want software like sourceguardian.com because these kind software need to be installed on the client’s server. And what I think it is not possible in shared hosting? So plz help me so that I can encrypt my PHP files using my own encryption methods. Thanks

Hi ELITE Its my first post to this forum So plz don’t mind if I am wrong What I will try is just save a session variable and initialize it to 0 first and then increase it. And apply condition that when its 1 the code execute Br Cksonline