Search results for query: *

I used php & mysql The data are from mysql, I hope someone can help me how to do this chart with that combination Am I in wrong forum?

Hello Expert! Can anyone guide me how to create dynamic organization / pyramid chart which look like this: http://www.elagenda.com/pyramid.bmp I found similar sample http://www.tek-tips.com/viewthread.cfm?qid=316739 -- the sample format is from right to left, furthermore it has no line...

Hello Expert! I need help to I translate this data... Table "LeaveDetail" StaffNo | StartDate | EndDate | LeaveType | 1 | 23/04/2006 | 26/04/2006 | AL | 2 | 24/04/2006 | 25/04/2006 | MC | 3 | 26/04/2006 | 27/04/2006 | EL | 1 | 30/04/2006 |...

Thanks [medal]PHV[medal], It Works! I Hope to contribute more STAR to you for the excellent guide.. TwoOdd & Pampers – Thanks for the idea, it's good but I have to skip your suggestion. Take care, Regards.

Hello Expert! I want to filter out Public Holiday from Employee’s attendance table. Take note: Public Holiday differ from state to state I’ve created 2 tables for this, they are as following: 1. PublicHoliday 2. EmpAttendance Table “PublicHoliday” contain information as following: No State...

Thanks dhookom, It Works! Hope I can contribute more STAR for you for the excellent guide.. BTW, sorry for the inconsistency Take care, Regards.

dhookom, Here the result... I've to change the column header to "Day" intead of "Month" and I've create tblDay which contain from day 1 --> 31 So now the query look like this... TRANSFORM First(nLeaveTypeNo) AS FirstOfLeaveType SELECT LeaveDetail.nEmpNo FROM tblDays, LeaveDetail WHERE...

OK I'll try...

Hello, Expert! I need help on how do I translate this data... Table "LeaveDetail" StaffNo | StartDate | EndDate | LeaveType | 1 | 01/11/2005 | 04/11/2005 | AL | 2 | 02/11/2005 | 03/11/2005 | MC | 3 | 04/11/2005 | 05/11/2005 | EL | 1 |...

Oh well, I knew this will come... BTW, a star for both of you, excellent helper... Take care, Regards.

DELETE Table1 FROM Table1,Table2 WHERE Table1.StatusId = Table2.StatusId AND Table1.ApproveById = Table2.ApproveById AND Table1.EmpNo = Table2.EmpNo #1064 - You have an error in your SQL syntax near 'Table1 FROM Table1, Table2 WHERE Table1.StatusId' at line 1 DELETE FROM Table1 USING...

I have tried that, but still not working... I also do as following but still not working.. DELETE FROM Table1 USING Table1,Table2 WHERE Table1.StatusId = Table2.StatusId AND Table1.ApproveById = Table2.ApproveById AND Table1.EmpNo = Table2.EmpNo Anyone have other solution?? TIA

Hi, I want to delete all data from Table1 based on data from Table2. So do as following: DELETE Table1 FROM Table1 INNER JOIN Table2 ON Table1.StatusId = Table2.StatusId AND Table1.ApproveById = Table2.ApproveById AND Table1.EmpNo = Table2.EmpNo Using MySQL 4.0 on my PC it works perfectly...

Hi DRJ478, thank u very much, the solution given is exactly what I want, u make my day! -- A star for you... Dear unborn, thank you, appreciate your time & efforts Take care, Regards.

Sorry unborn, the problem NOT solve.. [sadeyes]

Dear PHP Experts, I have problem with hidden field contains quotes. This is what I key-in in the text box: " ~ ! @ # $ % ^ & * ( ) _ + ` - = | } { [ ] : ; ' ? > < , . / \ As u can see it’s all special characters. To confirm what user has keyed-in, I display it and I stored it as a hidden...

r937, Again, thank you for the solution... Another star for you! Take care, Regards.

r937, Thank you for the solution, it help a lot! Can I ask another question about the same subject?? How to convert this sub query?? This query has 2 processes:- 1) Categories “nTotalDay” with a new field name, based on “nLeaveTypeNo” 2) SUM the new fields SELECT nEmpNo, tYear...

Dear MySql Expert, I've to downgrade my mysql statement from sub query(mysql 4x) --to-> non-sub query(mysql 3.32) I manage to changed below sub-query --> non subquery... Sub-query ========= $qsLeaveSUM = "SELECT * FROM LeaveSum WHERE (nEmpNo = $EmpNo) AND...

Hi TonyGroves, Thank you very much, as u suggested, I think I should use PHP code instead. BTW, FYI, the code produced an error when used with MySQL 3.23. An additional knowledge to me! Regards. Ps: A star for you too..