Search found 26 matches

by acellec
Thu Aug 23, 2012 9:44 pm
Forum: PHP coding => General
Topic: sum of array
Replies: 1
Views: 299

Re: sum of array

my second post i hope someone will hep :(
by acellec
Thu Aug 23, 2012 4:30 pm
Forum: PHP coding => General
Topic: sum of array
Replies: 1
Views: 299

sum of array

i have my code below for ($x = 1; $x <= 29; $x++) { $SQLstringx=QueryDBSumV('tbl'.$depttable[$x],$from,$to); $queryx = mysql_query($SQLstringx) or die("Fatal error: ".error_reporting(0)); $count = mysql_num_rows(mysql_query($SQLstringx)); if ($count > 0) { $setx=array(); while ($recordx = mysql_fetc...
by acellec
Wed Aug 15, 2012 12:02 am
Forum: PHP coding => General
Topic: Help Me Create a Report Please...
Replies: 1
Views: 322

Re: Help Me Create a Report Please...

i Have this code for a start. $query="Select tblamountalloc.agencycode,tblamountalloc.nproject,tblamountalloc.projectname, tblamountalloc.Location1,tblamountalloc.Location2,tblamountalloc.Location3,tblnojobs.Location1, tblnojobs.Location2,tblnojobs.Location3 from tblamountalloc Inner join tblnojobs ...
by acellec
Wed Aug 08, 2012 4:59 pm
Forum: PHP coding => General
Topic: Help Me Create a Report Please...
Replies: 1
Views: 322

Help Me Create a Report Please...

can you help me create a report that will look like below? Dates are dynamic, it can display date ranges from jan. to december or it can display only january or february. Project Name Amount Allocated No. of Jobs Total Jan. Feb. Mar. Total Jan. Feb. Mar. Project 1 900.00 2,250 Location 1 500.00 100....
by acellec
Tue Jul 10, 2012 5:01 pm
Forum: PHP coding => General
Topic: automatic query
Replies: 2
Views: 565

automatic query

Can you help me how to automatically query a table? For example, if a user opens my website. It will query a particular table depending on the present month and year. if the month and year today is july. It will automatically query and display all records in july 2012. Please Help???? i need it toda...
by acellec
Thu Jul 05, 2012 7:13 pm
Forum: PHP coding => General
Topic: Statistical Summary
Replies: 1
Views: 317

Re: Statistical Summary

Please Help Me :(
by acellec
Thu Jul 05, 2012 6:03 pm
Forum: PHP coding => General
Topic: Statistical Summary
Replies: 1
Views: 317

Statistical Summary

Can you help me make a work around for Statistical Summary? This statistical summary will appear in the log in page, data that will appear will be updated automatically monthly.
by acellec
Sun Jun 24, 2012 5:00 pm
Forum: PHP coding => General
Topic: multiple select option
Replies: 4
Views: 734

Re: multiple select option

Please anyone help me?
by acellec
Sun Jun 24, 2012 8:02 am
Forum: PHP coding => General
Topic: multiple select option
Replies: 4
Views: 734

Re: multiple select option

i dont get it..how to do that?
by acellec
Sat Jun 23, 2012 10:37 am
Forum: PHP coding => General
Topic: multiple select option
Replies: 4
Views: 734

multiple select option

how can i display 3 option chosen in my multiple select option box with below code. $query6="SELECT * FROM $TableNamee"; $result6 = mysql_query ($query6); echo "<select name=\"Fund\" multiple=\"multiple\" id=\"Fund$incTextBox\">"; // printing the list box select command while($nt=mysql_fetch_array($...
by acellec
Sun Jun 10, 2012 4:44 pm
Forum: PHP coding => General
Topic: page loader
Replies: 2
Views: 478

Re: page loader

can you help me make a page loader? like if i click a menu, a spinner image will appear until page is properly loaded. Please?
by acellec
Thu Jun 07, 2012 3:49 pm
Forum: PHP coding => General
Topic: page loader
Replies: 2
Views: 478

Re: page loader

can you help me please?
by acellec
Wed Jun 06, 2012 5:36 pm
Forum: PHP coding => General
Topic: page loader
Replies: 2
Views: 478

page loader

can you help me. i have separate files for my menu and my main page. below are my codes; my problem is if i click any of my menu my page loader keeps on loading can you help me? how to make a page loader? mainmenu.php <script type="text/javascript"> stm_ai("p1i0",[1,"New Quarterly Report","","",-1,-...
by acellec
Tue Jun 05, 2012 4:39 pm
Forum: PHP coding => General
Topic: Monthly Cut Off for a web system
Replies: 4
Views: 934

Re: Monthly Cut Off for a web system

thanks for the help. I will try that :)
by acellec
Mon Jun 04, 2012 4:05 pm
Forum: PHP coding => General
Topic: Monthly Cut Off for a web system
Replies: 4
Views: 934

Re: Monthly Cut Off for a web system

if(date("d",strtotime("now")) == 4){ echo "You cannot submit today"; }else{ echo "You can submit today"; } how about if for example, i created a submission for this month of june if i dont submit before july 4 then my submission will expire and cannot be submitted. this goes also if for example i c...
by acellec
Sun Jun 03, 2012 5:41 pm
Forum: PHP coding => General
Topic: Monthly Cut Off for a web system
Replies: 4
Views: 934

Monthly Cut Off for a web system

Can you help me implement a monthly cut off using php mysql?

What i want to do is to every 4th of the month a user cannot submit or create any submission.

Help me Please?
by acellec
Sun May 27, 2012 6:23 pm
Forum: PHP coding => General
Topic: Designing my system with different department
Replies: 4
Views: 807

Re: Designing my system with different department

Hi acellec, I don't see how your example would be a problem. I believe that in a single threaded application like PHP your major concern for contention should be in calls to functions that have arguments and significant logic to process or static methods with arguments and lots of logic to process....
by acellec
Sat May 26, 2012 6:24 am
Forum: PHP coding => General
Topic: Designing my system with different department
Replies: 4
Views: 807

Re: Designing my system with different department

hello please advice. this is a critical for my my job pleae
by acellec
Fri May 25, 2012 10:26 pm
Forum: PHP coding => General
Topic: Designing my system with different department
Replies: 4
Views: 807

Designing my system with different department

Can you help me in my system design? I have more than 20 users with different departments. What i did is this 20 users will access one interface or php form. For example main.php, this main.php will determine each user and their departments and save it into session. Then each form in my system will ...
by acellec
Tue May 22, 2012 4:11 pm
Forum: phpMyAdmin
Topic: How to Export All Tables?
Replies: 4
Views: 4182

Re: How to Export All Tables?

egami wrote:I'm not sure about PHPmyAdmin, but you can do the whole thing in one smooth swoop through your shell account.


mysql -pPassword {databasename} > filename.ext
what do you mean shell account?
by acellec
Mon May 21, 2012 11:10 pm
Forum: phpMyAdmin
Topic: How to Export All Tables?
Replies: 4
Views: 4182

How to Export All Tables?

I have 352 tables how can i export all these tables and import it? It seems that it doesn't export all tables.
by acellec
Mon May 21, 2012 4:54 am
Forum: PHP coding => General
Topic: Group Records in While Loop
Replies: 4
Views: 1409

Re: Group Records in While Loop

SELECT Project_Name, Nature, SUM(Amount) AS Amount FROM table GROUP BY Project_Name if i will do that, i will not be getting the sum for the nature of project. I need to sum it in the while loop. Sum all the projects with the same project name. Please help me it's been month that I am solviing this...
by acellec
Sun May 20, 2012 4:28 pm
Forum: PHP coding => General
Topic: Group Records in While Loop
Replies: 4
Views: 1409

Re: Group Records in While Loop

how will i display it in html? so that it will be like the report above (image attached)? where Project name will appear once, and the sum of project name with the same nature of project, and the sum of projects with the same project name?
by acellec
Thu May 17, 2012 6:16 pm
Forum: PHP coding => General
Topic: Group Records in While Loop
Replies: 4
Views: 1409

Re: Group Records in While Loop

Reports copy.jpg
Reports copy.jpg (38.54 KiB) Viewed 1406 times