Lightbox only loading for first 10 rows

Lightbox only loading for first 10 rows

asdrubalasdrubal Posts: 16Questions: 0Answers: 0
edited February 2012 in General
Hello,

What I'm tyring to achieve here is to have Edit/Delete shown in the overlay window (using Lightbox). I've got everything working but only for the first 10 rows. The table generates how I want it, when I click Edit/Delete I get a form with existing data in Lightbox window but only for first 10 rows. Any idea how to get this working for all rows. Here is my code:
[code]<?php
$con = mysql_connect("localhost", "*****", "*****");

if (!$con) {

die("Error: " . mysql_error());

}
mysql_select_db("******", $con);

$result = mysql_query("SELECT * FROM pracownik");

?>













@import "/tables/media/css/demo_table_jui.css";
#addmenu {
margin-left: 5px;
margin-top: 5px;
}
#addmenu li {
float: left;
list-style: none;
margin: 1px;
padding: 3px;
background: #FFFFFF;
font-weight: bold;


}
#addmenu li:hover{
background: #F6F6F6;
}
#addmenu a {
color: #EB8F00;
}
#addmenu li:first-child {
border-radius: 8px 0px 0px 8px;
-webkit-border-radius: 8px 0px 0px 8px;
-moz-border-radius: 8px 0px 0px 8px;

}
#addmenu li:last-child {
border-radius: 0px 8px 8px 0px;
-webkit-border-radius: 0px 8px 8px 0px;
-moz-border-radius: 0px 8px 8px 0px;
}
.width {
width: 30px;
padding: 0px;
margin: 0px;

}



$.noConflict();
jQuery(document).ready(function($){
$('#example').dataTable({

"sPaginationType":"full_numbers",
"aaSorting":[[0, "asc"]],
"bJQueryUI":true

});

} );











Add New Row
Export to CSV
Import from CSV






Employee Number
Firstname
Lastname
Start date at ************
Leave date
Status
Telephone
Project ID
Edit
Delete



<?php
while ($row = mysql_fetch_array($result)) {
?>

<?php echo $row['nrPracownika']; ?>
<?php echo $row['imie']; ?>
<?php echo $row['nazwisko']; ?>
<?php echo $row['data_zatrudnienia']; ?>
<?php echo $row['data_odejscia']; ?>
<?php echo $row['status_p']; ?>
<?php echo $row['telefon']; ?>
<?php echo $row['other1']; ?>



<?php
}
;?>



[/code]


Any suggestions much appreciates.
This discussion has been closed.