table

html table - which column will give ?

when you have a table where you define explicitically the width per <td> and the total is greater than the existing width that you have to play with. what determines which column will shrink and which will enforce the td width? ...

MySQL error 150, cannot create table.

I'm having trouble creating a table and I don't understand what's wrong. phpMyAdmin sets the error indicator next to the PRIMARY KEY declaration... I don't get why this is wrong... This table is a child table, which has a one-to-many identifying relationship with another table. CREATE TABLE IF NOT EXISTS `ruilen`.`Voorwerpen` ( `voorwe...

Why do Google and Twitter use table layout?

Possible Duplicate: Does it make sense to use the <table> tag on a modern website? Everywhere I go I see don't use table layout, it's evil, even Google says that, so why one of the most visited websites, Google and Twitter, use it for their homepage? I don't think it is any kind of mistake, or any other stupid problem. The on...

Allowing users to bump an input they submitted every hour?

So, I want people to be able to "bump" what they've wrote in my database but at the same time only allow the input to be in the table ONCE at a time. For Example: Jim's code is 5555. Jim enters his code and it shoots to the very bottom of the table. After 34 minutes he tries to enter his code in again (Because various other people h...

The best way to "clear: both"

Hi For long now, I've been using a CSS class called clear, which only has the rule clear: both. I use it in the following way (shown in Django-syntax, but it is unimportant): {% for item in collection %} <ul class="horiz"><!-- horizontal list --> <li>{{ item }}</li> <li>{{ item }}</li> </ul> <div class="clear"></div> {% e...

[PHP] Inserting an array of lines into an SQL table

Hello everyone, I would really appreciate if you would take a look at this piece of code: <?php if(isset($_POST['add'])) { $self = $_SERVER['PHP_SELF']; //the $self variable equals this file $ipaddress = ("$_SERVER[REMOTE_ADDR]"); //the $ipaddress var equals users IP //connect $connect = mysql_connect($host,$username,$password) or di...

Clone a Table's definition with Hibernate (hbm2ddl)

In my hibernate application there is annotation driven object: AuditEvent. Its very simple and has no foreign key relationships. I archive old entries in this table by moving them to another table OldAuditEvent, which is a clone of the AuditEvent table. Right now we generate the DDL for the entire application using hbm2ddl (on our a...

mySQL MATCH across multiple tables

Hi, I have a set of 4 tables that I want to search across, each has a full text index, and here is my query; SELECT categories.name AS category, categories.id AS category_id, host_types.name AS host_type, host_types.id AS host_type_id, hosts.name AS host, hosts.id AS host_id, products.name as name, products.id AS ...

How do I span columns with a div based table?

I would like to have a cell go across two columns with two cells below it. How do I do this in CSS with Div tags? It shoudl be equivalent to: <table> <tr> <td colspan="2">Major column</td> </tr> <tr> <td>C1</td> <td>C2</td> </tr> </table> EDIT Please note that C1 and C2 are not necessarily going to be 50% each. ...

Applying borders to a single table cell when using border-collapse

I have a table with the following CSS rules applied: table { border-collapse: collapse; } td { border: 2px solid Gray; } I want certain cells to have a red border, instead. td.special { border: 2px solid Red; } This doesn't work as I'd expect. In FireFox 3 and IE8 it looks like this: In IE7 Compatibility mode (Running in IE8) i...

html grid, and I need to submit the data from the one row the user clicked to a cgi

I need to create a grid of data many rows by 8 columns. When the user clicks on a row I need to submit the data from only that row to a php program. I'm not sure how to proceed. Do I make each row a separate form? Do I create a hidden form and copy the row data into it, and submit that? I'm not sure how to determine which row the user ...

How can I highlight a row in a gtk.Table?

I want to highlight specific rows in a gtk.Table. I also want a mouseover to highlight it w/ a different color (like on a link in a web browser). I thought of just packing each cell with an eventBox and changing the STATE_NORMAL and STATE_PRELIGHT bg colors, which does work, but mousing over the eventbox doesn't work. Is there a better w...

How to delete completely the initial table in android

I created a table with the name SONGS in the assets/folder. And after that I create a new project, my project run to create a database name "data" with table name "BOOKS". But I found that the table "SONGS" also created in my new database? And now my database have two table "BOOKS" and "SONGS". I don't know why? How can I delete complete...

Progressively Enhance HTML table with jqGrid?

I can't find an example of jqGrid being used to "paint" an existing clean HTML table. Is this possible? I am currently using datatables http://www.datatables.net/ because it is easy to implement on existing HTML but would prefer jqGrid's theme support and hooks. ...

Making a MySQL view easier to update & load

I'm having a view that's actually a combination of 2 other views, which in they turn are the split of Table1 join Table2. The split in the 2 view is based on whether the column of the table1 EnterDate=curDate(), which determines the way a new column is calculated ( NewColumn=(Table2.Cpx-Table1.Px)*Table1.Size if EnterDate=curdate() and N...

Updating an UNPIVOTted SQL Table

Okay, I've been beating my head against this, and I'm sure I'm just missing something obvious, but... I have a table in a customer's database, that's basically: Item_Set_Key int Item_1 bit Notes_1 nvarchar(80) Item_2 bit Notes_2 nvarchar(80) Item_3 bit Notes_3 nvarchar(80) ... There's 99 items in ea...

HTML Tables using JPG images as borders

I'm trying to create a "certificate" for use in an email capmaign. We are trying to maintain compatability with Outlook 2007 and that limits us from using the background property to just load a single picture to display behind the text. I've chopped my borders up in 4 pieces (left, top, right, bottom) and placed them in spanned columns ...

ASP.NET System.Web.UI.WebControls.Table control

How can I bind data to a System.Web.UI.WebControls.Table - control? and, How can I populate it from a List? ...

Most efficient way to determine if a Lua table is empty (contains no entries)?

What's the most efficient way to determine if a table is empty (that is, currently contains neither array-style values nor dict-style values)? Currently, I'm using next(): if not next(myTable) then -- Table is empty end Is there a more efficient way? Note: The # operator does not suffice here, as it only operates on the array-st...

jQuery removing columns and rows..

Hi all, I've got a table which I'm pulling in from an external website, but I need to be able to hide the first 2 columns, add a class to the 3rd column, add a class to the 6th row and delete the 7th row. I've managed to do the columns, but I'm having problems with the rows.. I'm using the following code to hide the first 2 columns and ...