Posted by Tim Roberts on 01/01/07 07:22

"PHPBABY3" <shymathguy@gmail.com> wrote:
>
>1. I have two SQL tables. I will call them employees and departments:
>
>EMP: LAST_NAME, FIRST_NAME, DEPTNM
>DEPT: NUM, NAME
>
>Input: text string FIND
>
>Output: the LAST_NAME, FIRST_NAME and department name NAME (link DEPTNM
>in EMP to NUM in DEPT) of all employees whose LAST_NAME or whose
>FIRST_NAME contains the string FIND in a case-insensitive manner.
>Example: Employees with LAST_NAME = "Sandleburg" are listed when
>input FIND = "BURG".
>
>2. What if I have to add another field to the display, department
>budget, from table:
>
>ACCOUNTS: DEPTNM, BUDGET
>
>3. Display the results 10 at a time.
>
>4. Position the results on the page using CSS.

It is *NOT* the job of the folks on this newsgroup to do your homework for
you, and those who replied should be ashamed at being suckered into doing
so.
--
Tim Roberts, timr@probo.com
Providenza & Boekelheide, Inc.

[Back to original message]