Posted by Ric on 12/31/06 11:12

PHPBABY3 schrieb:
> Hi,
>
> 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".


$sql = "SELECT A.LAST_NAME A.FIRST_NAME B.NAME FROM EMP A left join DEPT
B on A.DEPTNM = B.NUM WHERE A.LAST_NAME LIKE '%$FIND%';";






>
> 2. What if I have to add another field to the display, department
> budget, from table:
>
> ACCOUNTS: DEPTNM, BUDGET

add another left join as shown above

>
> 3. Display the results 10 at a time.

Add links to your page that contain the some sort of count, like:

<a href="yourpage.php?count=11>Next 10</a>

and use LIMIT to only display from 11 to 20 if someone cicks next etc.:
http://dev.mysql.com/doc/refman/5.0/en/limit-optimization.html

>
> 4. Position the results on the page using CSS.

just add a class="cssname" to your div etc.

<div class="myoutput">
Whatever you want to display here a table , option list etc.
</div>

css:

#myoutput {
RIGHT: 10%; LEFT: 10%; WIDTH: 80%; POSITION: absolute; TOP: 100px;
}

>
> Thanks,
>
> Peter
>

[Back to original message]