Lightbox only loading for first 10 rows
Lightbox only loading for first 10 rows
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.
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.