Access db php, kan ikke connecte!
Hvad er fejlen?:_________________________________________________________________
<html>
<head>
<title>Visning af illustratoroplysninger</title>
<LINK REL="stylesheet" TYPE="text/css" HREF="style.css" >
</head>
<body >
<?php
//*********************************************************************************************************
// Find illustratoroplysninger i kunstnertabel
//
//*********************************************************************************************************
$connect=odbc_connect("klim1","","");
$query="SELECT * FROM kunstnertabel WHERE illustratorid='$var1'";
$result=odbc_do($connect,$query);
while(odbc_fetch_into($result,&$fields));
print '
Visning af illustratoroplysninger
<br><br>
<table border="0" width="600">
<tr>
<td width="150">illustratorid</td>
<td width="*">'.$fields[3].'
</tr>
<tr>
<td width="150">Fornavn</td>
<td width="*">'.$fields[5].'
</tr><tr>
<td width="150">Mellemnavn</td>
<td width="*">'.$fields[6].'
</tr><tr>
<td width="150">Efternavn</td>
<td width="*">'.$fields[7].'
</tr><tr>
<td width="150">Pseudonym</td>
<td width="*">'.$fields[8].'
</tr>
<tr>
<td width="150">Fødsel</td>
<td width="*">'.$fields[9].'
</tr>
<tr>
<td width="150">Død</td>
<td width="*">'.$fields[10].'
</tr><tr>
<td width="150">Natioanalitet</td>
<td width="*">'.$fields[11].'
</tr>
<tr>
<td width="150">Beskrivelse</td>
<td width="*">'.$fields[12].'
</tr>
<tr>
<td width="150">Billede J/N</td>
<td width="*">'.$fields[13].'
</tr>
</table>
<br>
<br>
<a href="illustratorret1.php?var1='.$fields[3].'">ret illustrator</a><br>
<a href="illustratorslet1.php?var1='.$fields[3].'">slet illustrator</a><br>
';
?>
<br>
<br>
<a href=illustratorvis.php>tilbage til illustratoroversigt</a>
</body>
</html>
________________________________________________________________
Visning af illustrator
FornavnEfternavnNationalitet '; while(odbc_fetch_into($result,&$fields)) { if(strlen($fields[3])>2){ print' '.$fields[5].' '.$fields[7].' '.$fields[11].' '; } }; print''; ?>
Oprettelse af illustratoroplysninger
