Kod radi, ali ne bas ono sto bih hteo.
Hvala na pomoci!
Code:
<style type="text/css">
<!--
body {
background-color: #E6E6E6;
}
.style8 {color: #FFFFFF; font-size: small; font-family: Arial, Helvetica, sans-serif; }
.style3 {
font-family: Arial, Helvetica, sans-serif;
font-size: 12px;
color: #FFFFFF;
font-style: italic;
}
.style10 {font-family: Arial, Helvetica, sans-serif; font-size: small; }
.style2 {
font-family: "Arial Narrow";
font-size: 12px;
font-style: normal;
color: #003399;
}
.style3Copy {
font-family: Arial, Helvetica, sans-serif;
font-size: 10px;
color: #FFFFFF;
font-style: italic;
}
.style3Copy2 {
font-family: Arial, Helvetica, sans-serif;
font-size: 11px;
color: #FFFFFF;
font-style: italic;
}
body,td,th {
color: #FFFFFF;
}
-->
</style>
<table width="910" border="1" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF">
<tr>
<th bgcolor="#0000FF" width="60" scope="col"><span class="style3Copy">Passport no</span></th>
<th width="90" bgcolor="#0000FF" class="style3" scope="col"><span class="style3">Last name</span></th>
<th width="88" bgcolor="#0000FF" class="style3" scope="col"><span class="style3">First name</span></th>
<th width="70" bgcolor="#0000FF" class="style3" scope="col"><span class="style3">DOB</span></th>
<th width="50" bgcolor="#0000FF" class="style3" scope="col"><span class="style3">Gender</span></th>
<th width="87" bgcolor="#0000FF" class="style3" scope="col"><span class="style3">Home phone</span></th>
<th width="90" bgcolor="#0000FF" class="style3" scope="col"><span class="style3">LOE Number</span></th>
<th width="80" bgcolor="#0000FF" class="style3" scope="col"><span class="style3">Embarkation date</span></th>
<th width="160" bgcolor="#0000FF" class="style3" scope="col"><span class="style3">Company</span></th>
<th width="130" bgcolor="#0000FF" class="style3" scope="col"><span class="style3">Position</span></th>
</tr>
</table>
<?
$link = mysql_connect("localhost", "root", "")
or die("Could not connect : " . mysql_error());
mysql_select_db("kalendar") or die("Could not select database");
$dData['all_entries'] = mysql_query("SELECT passportno, lastname, cellphonenumber, firstname, dateofbirth, gender, homephone, loenumber, embarkationdate, hiredtoworkforcompany, positiongained FROM jedan;");
$Broj_pasosa=NULL;
$Prezime=NULL;
$Mobilni=NULL;
$DatumRodjenja=NULL;
$Ime=NULL;
$Pol=NULL;
$KucniBroj=NULL;
$BrojLOE=NULL;
$DatumUkrcaja=NULL;
$ZaposlenKod=NULL;
$Zanimanje=NULL;
for ($x = 0; $x < mysql_numrows($dData['all_entries']); $x++) {
$Broj_pasosa = mysql_result($dData['all_entries'], $x, "passportno").".";
$Prezime = mysql_result($dData['all_entries'], $x, "lastname");
$Ime = mysql_result($dData['all_entries'], $x, "firstname");
$DatumRodjenja = mysql_result($dData['all_entries'], $x, "dateofbirth");
$Pol = mysql_result($dData['all_entries'], $x, "gender");
$KucniBroj = mysql_result($dData['all_entries'], $x, "homephone");
$BrojLOE = mysql_result($dData['all_entries'], $x, "loenumber");
$DatumUkrcaja = mysql_result($dData['all_entries'], $x, "embarkationdate");
$ZaposlenKod = mysql_result($dData['all_entries'], $x, "hiredtoworkforcompany");
$Zanimanje = mysql_result($dData['all_entries'], $x, "positiongained");
print "<table width=\"910\" border=\"1\" cellpadding=\"0\" cellspacing=\"0\" bordercolor=\"#E6E6E6\">";
print "<th width=\"60\" height=\"25\" scope=\"col\"><div align=\"center\" class=\"style2 \" >$Broj_pasosa</div></th>";
print "<th width=\"90\" scope=\"col\"><div align=\"center\" class=\"style2 \" > $Prezime</div></th>";
print "<th width=\"90\" scope=\"col\"><div align=\"center\" class=\"style2 \" > $Ime</div></th>";
print "<th width=\"70\" scope=\"col\"><div align=\"center\" class=\"style2 \" > $DatumRodjenja</div></th>";
print "<th width=\"50\" scope=\"col\"><div align=\"center\" class=\"style2 \" > $Pol</div></th>";
print "<th width=\"90\" scope=\"col\"><div align=\"center\" class=\"style2 \" > $KucniBroj</div></th>";
print "<th width=\"90\" scope=\"col\"><div align=\"center\" class=\"style2 \" > $BrojLOE</div></th>";
print "<th width=\"80\" scope=\"col\"><div align=\"center\" class=\"style2 \" > $DatumUkrcaja</div></th>";
print "<th width=\"160\" scope=\"col\"><div align=\"center\" class=\"style2 \" > $ZaposlenKod</div></th>";
print "<th width=\"130\" scope=\"col\"><div align=\"center\" class=\"style2 \" > $Zanimanje</div></th>";
print "</table>";
}
?>
DejanV