Søgefunktion ud fra form
Hejsa...Jeg står og mangler en søgefunktion som går ind i databasen "../../database/main.mdb" og søger i tabel "Elever".
Min form ser sådan her ud:
<table cellpadding="0" cellspacing="0" border="0" width="100%">
<tr>
<td width="50%">
<table cellpadding="0" cellspacing="0" border="0" width="100%">
<tr onmouseover="this.className='gMouseOver';" onmouseout="this.className='gMouseOut';">
<td width="35%" class=fCha> <strong>Elev nr.</strong></td> <td><input type="text" name="nr" class="niceinput" style="width:60px"></td>
</tr>
<TR><TD bgColor=#cccccc colSpan=2 height=1></TD></TR>
<tr onmouseover="this.className='gMouseOver';" onmouseout="this.className='gMouseOut';">
<td class=fCha> <strong>Elev navn</strong></td> <td><input name="nr" class="niceinput" style="width:200px"></td>
</tr>
<TR><TD bgColor=#cccccc colSpan=2 height=1></TD></TR>
<tr onmouseover="this.className='gMouseOver';" onmouseout="this.className='gMouseOut';">
<td class=fCha> <strong>Elev mobil</strong></td> <td><input type="text" name="nr" class="niceinput" style="width:200px"></td>
</tr>
<TR><TD bgColor=#cccccc colSpan=2 height=1></TD></TR>
<tr onmouseover="this.className='gMouseOver';" onmouseout="this.className='gMouseOut';">
<td class=fCha> <strong>Elev telefon</strong></td> <td><input type="text" name="nr" class="niceinput" style="width:200px"></td>
</tr>
<TR><TD bgColor=#cccccc colSpan=2 height=1></TD></TR>
</table>
</td>
<td width="50%">
<table cellpadding="0" cellspacing="0" border="0" width="100%">
<tr onmouseover="this.className='gMouseOver';" onmouseout="this.className='gMouseOut';">
<td width="35%" class=fCha> <strong>Elev CPR nr.</strong></td> <td><input type="text" name="nr" class="niceinput" style="width:200px"></td>
</tr>
<TR><TD bgColor=#cccccc colSpan=2 height=1></TD></TR>
<tr onmouseover="this.className='gMouseOver';" onmouseout="this.className='gMouseOut';">
<td class=fCha> <strong>Elev e-mail</strong></td> <td><input type="text" name="nr" class="niceinput" style="width:200px"></td>
</tr>
<TR><TD bgColor=#cccccc colSpan=2 height=1></TD></TR>
<tr onmouseover="this.className='gMouseOver';" onmouseout="this.className='gMouseOut';">
<td class=fCha> <strong>Elev adresse</strong></td> <td><input type="text" name="nr" class="niceinput" style="width:200px"></td>
</tr>
<TR><TD bgColor=#cccccc colSpan=2 height=1></TD></TR>
<tr onmouseover="this.className='gMouseOver';" onmouseout="this.className='gMouseOut';">
<td class=fCha> <strong>Elev post nr. / By</strong></td> <td><input type="text" name="nr" class="niceinput" style="width:40px" maxlength="4"> <input name="nr" class="niceinput" style="width:157px"></td>
</tr>
<TR><TD bgColor=#cccccc colSpan=2 height=1></TD></TR>
</table>
Feldterne i databasen som der skal søges i er:
ElevID
Fuldenavn
Mobil
Telefon
CPRnr
Adresse
Postnr
By
Scriptet skal vise aktuelle elever på en liste ned af...
Håber der er nogen der kan hjælpe...
