Search found 13 matches

by Hillu
Thu Aug 20, 2009 9:03 am
Forum: Databases
Topic: counting from a database
Replies: 10
Views: 1156

Re: counting from a database

Hey, thanks a lot but I am not allowed to modify the database because there are other programmers working on other modules and some of the functionalities are already released.

Any other suggestions?
by Hillu
Thu Aug 20, 2009 3:08 am
Forum: Databases
Topic: counting from a database
Replies: 10
Views: 1156

counting from a database

Hi, I am working on a school database and I was trying to count the number of male and female regular students belonging to each academic year. In my database I have three tables: Student…….. Containing all student information Batch……….describing to which academic year a student belongs Student_hist...
by Hillu
Thu Jul 23, 2009 8:29 am
Forum: PHP - Code
Topic: extracting the middle values of a string
Replies: 2
Views: 1012

Re: extracting the middle values of a string

thanks a lot. It works.
by Hillu
Thu Jul 23, 2009 7:40 am
Forum: PHP - Code
Topic: extracting the middle values of a string
Replies: 2
Views: 1012

extracting the middle values of a string

Hi, I have a table which contains employees. Each employee has a code. The code indicates the department the employee belongs to the year he joined the organization and a unique number. The format is three digits alphabets, two digits indicating the year and two digits the unique number. Like ‘ABC05...
by Hillu
Sat Apr 25, 2009 2:12 am
Forum: Javascript
Topic: populating three related combo boxes from a database
Replies: 1
Views: 408

populating three related combo boxes from a database

Hi, I wanted to populate three combo boxes which are related from database values. The first combo box contains list of countries,the second regions and the third zones. I have the lists in a database. If a country is selected from the first combo box the second should provide only the regions belon...
by Hillu
Fri Dec 05, 2008 1:49 am
Forum: PHP - Code
Topic: date calculation
Replies: 3
Views: 244

Re: date calculation

I have the following declarations in another file which I included in the file in question: $currentdate = getdate(); $currentyear=$currentdate['year']; $currentmon=$currentdate['mon']; // month in number $currentday=$currentdate['mday']; I also have a 'DateDropDown' function which lists dates by co...
by Hillu
Fri Dec 05, 2008 1:18 am
Forum: PHP - Code
Topic: date calculation
Replies: 3
Views: 244

date calculation

Hi, I have events which last for 3 months. The recent event starts on Dec 2008 and ends on Mar 2009. I have the starting date in a combo box how do I calculate the ending date? Thanks
by Hillu
Thu Nov 20, 2008 3:50 am
Forum: PHP - Code
Topic: adding right click menu events
Replies: 0
Views: 341

adding right click menu events

Hi, I am working on a web page. I wanted to add right click events (update, delete,...)on a tree menu. I also wanted these events for the branch items. Can u help? Thanks.
by Hillu
Wed Oct 29, 2008 6:28 am
Forum: PHP - Code
Topic: How do I make menu
Replies: 1
Views: 160

How do I make menu

Hi, I have a website which contains 10 pages. I'm using HTML,JavaScript and PHP. I want to define the menu and the logo once and have it in all the pages. How do I do that?

Thanks.
by Hillu
Sat Oct 25, 2008 6:21 am
Forum: Miscellaneous
Topic: populating a combo box
Replies: 1
Views: 2161

populating a combo box

Hi, I have a combo box and I want to populate it by 'year' values. I want the option values to start from 10 years in the past and 10 years in the future. How do I do that? Thanks.
by Hillu
Fri Aug 01, 2008 8:41 am
Forum: PHP - Code
Topic: Connecting to two databases using PHP
Replies: 3
Views: 152

Re: Connecting to two databases using PHP

Okay. Thes are the two files I used. At first the two connections were defined in one file but the second connection kept overriding the second so I had to have 2 separate files. Can I make these two in one file. cls_connect_dbtestrms.php <?php class connectTestrms_db { private $MySQLDatabaseName='t...
by Hillu
Fri Aug 01, 2008 6:42 am
Forum: PHP - Code
Topic: Connecting to two databases using PHP
Replies: 3
Views: 152

Connecting to two databases using PHP

I was trying to connect to two databases which are on the same host using the same user name and password. I wanted to establish the connnection to read the data from one of the tables in the first database and insert it in one of the tables in the second database. I wrote 2 PHP pages to connect to ...
by Hillu
Sun Jul 27, 2008 3:40 am
Forum: General Discussion
Topic: Connecting to SQL server using PHP code
Replies: 3
Views: 532

Connecting to SQL server using PHP code

I wanted to connect to SQL server using PHP so that I can migrate the data I have in the SQL server to MySQL server. Any suggestions?
Thanks