|
|
Posted by Ric on 01/01/07 20:52
Tim Roberts schrieb:
> "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.
Instead of posting useless comments to this ng you should invest your
time in a redesign of your corporate (probo) pages, next time try to
'not' copy a popular design.
Also mind your meta section "keywords", did you know that it's
forbidden to use trademarks from other companies as keywords in your
meta section?
By the way for statics, you don't need php :-)
Navigation:
[Reply to this message]
|