mbh23
-
Posts
8 -
Joined
-
Last visited
Never
mbh23's Achievements
Newbie (1/5)
0
Reputation
-
I am trying to get the auto scroll on the <tbody> but it isnt working here is what i have so far <html> <head> <style type="text/css"> thead {color:green} tbody {color:blue;height:50px} </style> </head> <body> <table border="1"> <thead> <tr> <th>ID</th> <th>Part</th> </tr> </thead> <?php $query="select * from something "; $result = mysql_query($query) or die(mysql_error()); while($row = mysql_fetch_array($result)){ echo" <tbody style="height: 100px; overflow: auto;">" ; echo"<tr>" ."\n <td >{$row[division]}</td>" ."\n <td >{$row[partno]}</td>" ; echo" </tr>"; } ?> </tbody> </table> </body> </html>
-
im using the code and it doesn't throw up any errors but it is still no locking the headers?
-
I am trying to lock the headers in my table. I have gotten it to work in html but when i try and echo it in php i get an error Parse error: parse error, unexpected T_STRING, expecting ',' or ';' Any help <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <?php include ("login.php");?> <html> <head> <meta http-equiv="content-type" content="text/html; charset=iso-8859-1" /> <title>Lock Table Head</title> <style type='text/css'> /* DIV container around table to constrict the height for IE (IE ignores the tbody height style) */ div.FixedTableHead { overflow-y:auto; /* this fixes IE so container width is same as table width */ width: expression( (this.childNodes[0].clientWidth + 24) + 'px' ); /* This fixes IE so the container height is table height plus the height of the header */ height: expression( (parseInt(this.childNodes[0].style.height) + this.childNodes[0].childNodes[1].offsetTop + 1) +'px' ); } /* Scrollable Content */ .FixedTableHead table tbody { height:100%; overflow-x:hidden; overflow-y:auto; } .FixedTableHead table tbody tr { height: auto; white-space: nowrap; } /* Prevent Mozilla scrollbar from hiding right-most cell content */ .FixedTableHead table tbody tr td:last-child { padding-right: 20px; } /* Fixed Header */ /* In WinIE any element with a position property set to relative and is a child of */ /* an element that has an overflow property set, the relative value translates into fixed. */ /* Ex: parent element DIV with a class of tableContainer has an overflow property set to auto */ .FixedTableHead table thead tr { position: relative; height: auto; /* this fixes IE header jumping bug when mousing over rows in the tbody */ top: expression( this.parentNode.parentNode.parentNode.scrollTop + 'px' ); } /* Fixed Header */ .FixedTableHead table thead tr td { border-bottom:1px solid #000000; background-color:white; } </style> </head> <body> Lock Table Headings<br /> <?php echo"<div class="FixedTableHead">"; echo"<table cellspacing=0 style="height:100px;">"; echo" <thead>"; echo" <tr><td>ID</td></tr>"; echo" </thead>"; $query = "select id from master where period='09P3'"; $result = mysql_query($query) or die(mysql_error()); while($row = mysql_fetch_array($result)){ echo" <tbody> <tr><td > {$row[id]}</td></tr> </tbody>"; } echo" </table>"; echo"</div>"; ?> </body> </html>
-
Currently I have a site that shows items from a database and they can click on the cell and change the info, click save and it updates that cell. This is done with the code below if($_POST[action]=='updatedivision') { $query="update master set division='{$_POST[updatevalue]}' where id=$_POST[updateid]"; mysql_query($query) or die("Couldn't update part: ".mysql_error()); } function makeeditable(cell,id,action,isdisabled) { if(editmode == 1 || isdisabled==1 ) return; editmode = 1; cell.innerHTML = '<input type=text size=5 id="cell_'+id+'" value="'+cell.innerHTML+'">' + '<input type=button value="Save" onClick=\'updatecellcontents('+id+',"'+action+'")\'>'; } function updatecellcontents(id,action) { document.items.action.value = action; document.items.updateid.value = id; document.items.updatevalue.value = document.getElementById('cell_'+id).value; document.items.submit(); } <td onclick='makeeditable(this,$row[id],\"updatedivision\",$disableinfo);'>{$row[division]}</td>" How can I make it so they can edit multiple feilds then click on the save button and it will update all of them?
-
echo"\n<table border ='1' align=left >"; echo"\n<tr><th >Heading</th>"; $query="select info from something"; $result = mysql_query($query) or die(mysql_error()); while($row = mysql_fetch_array($result)){ echo "\n <tr style='text-align:Center'>" ."\n <td >".number_format($row[info],0,".",",")."</td>"; echo "\n</td></tr>"; } echo"\n<table border ='1' align=left >"; echo"\n<tr><th >Heading</th>"; $query="select info from something"; $result = mysql_query($query) or die(mysql_error()); while($row = mysql_fetch_array($result)){ echo "\n <tr style='text-align:Center'>" ."\n <td >".number_format($row[info],0,".",",")."</td>"; echo "\n</td></tr>"; } echo"\n<table border ='1' align=left >"; echo"\n<tr><th >Heading</th>"; $query="select info from something"; $result = mysql_query($query) or die(mysql_error()); while($row = mysql_fetch_array($result)){ echo "\n <tr style='text-align:Center'>" ."\n <td >".number_format($row[info],0,".",",")."</td>"; echo "\n</td></tr>"; }
-
I have a php table from mysql and i am trying to format the table so it appears like below heading | info heading | info Heading | info Right now the information is Heading | Heading | Heading | info | info | info | my alignment is echo"\n<table border ='1' align=left >";
-
I have a very large table that I am trying to show with php. I want the headers to stay locked when the users scrolls down. I have tried this with html frames but the problem is your can scroll horizontally to which throws off the headings. I want it to be like excel when you lock the rows?
-
I am pulling data from a mysql database and I want to know the syntax for adding comma's. For example 100000 would be 100,000. Also how to choose how many decimals the number rounds to.