I have a data table which is populated with data unrelated to drupal content (from a third party system). The data relates to photos which must be approved / flagged as inappropriate. So I'm writing a Drupal admin module which should moderate this content. So far, I have built a table using theme('table',...) which shows 1 photo per row...
Given a DAG, in which each node belongs to a category, how can this graph be transformed into a table with a column for each category? The transformation doesn't have to be reversible, but should preserve useful information about the structure of the graph; and should be a 'natural' transformation, in the sense that a person looking at t...
I'm looking for a good way to get cells X-Y position in a table. (do not confuse it with css-position, I am looking for X and Y coordinate in Cartesian coordinate system). As we know, we can get particular cell in a table using ex: $('#grid')[0].rows[5].cells[7]. But, what if I want to get the value 5x7 when I click on particular cell,...
I'm making a website that has to fit in the entire screen regardless of screen-size. I'm using a table to use this at the moment but I ran into a problem. The web page is divided into 3 columns: the left column stays at the left of the screen and has a fixed size with a background. the right column stays at the right of the screen and ...
If I want to delete all the tables in my database like this, will it take care of the foreign key constraint? If not, how do I take care of that first? GO IF OBJECT_ID('dbo.[Course]','U') IS NOT NULL DROP TABLE dbo.[Course] GO IF OBJECT_ID('dbo.[Student]','U') IS NOT NULL DROP TABLE dbo.[Student] ...
I've got an ejabberd server with a good amount of custom modules running. I have several mnesia tables and I know these can be easily copied between nodes without any change to the code at all. I was wondering if there's a similar way with ets tables? Ideally it'd be nice to be able to have several machines running with exactly the sa...
I want to SELECT all rows except for the first 5 rows in a table. How do I do that? Why cant I just type $query = "SELECT * FROM ages OFFSET 5 ORDER BY id ASC"; ...
im using html SELECT to make 3 dropdown menues. one for a list of countries, one for regions and one for cities. they all have different tables in the database and they are linked to each other with foreign keys. i want to force the user to first select a country while the other two menues are locked. when he has selected a country he ...
Hi Guys, i'm a total noob when it comes to Jquery and i've been trying to learn it but as of now i still don't know how to query this one out. I have a table structure that looks like this: <table class="wba_main_table" align="center" border="0" cellpadding="0" cellspacing="0" width=""> <tbody> <tr> <td style="d...
hello, I'm new to programming jquery, I'm trying to make a table from a query in an Oracle database. The code to create the table is something like this: <form method="get" name="SC" > <table id="tabla1" width="1129" height="32" id="tabla" border="3" align="center" bordercolor="#FFFFFF"> <thead> <tr> <th width="77" height="22" ...
I have a form where users are entering 35 different fields. I have a Content Management System where I want to display the results of an order on the form. I've thought about adding a horizontal scrollbar inside the table, or limiting the table to the 10 most important columns and then making it so the administrator has to click on an...
hi all How can I send session[table] to database in php ? like that. session_start(); session_register('table'); $qty=$_POST[txtQty]; $pid=$_REQUEST[pid]; $data=@mysql_query("SELECT * from products where productid=".$pid,$con) or die(mysql_error()); $table=$_SESSION[table]; while($row=@mysql_fetch_array($data)) { $table.='<tr>...
SELECT db1_t1.userid as userid , db1_t1.customer_id as vw_customer , db2_t1.customers_id as customer , db2_t1.orders_id as order FROM database1.table1 db1_t1 LEFT JOIN database2.table1 db2_t1 ON db1_t1.customer_id = db2_t1.customers_id It gives me this error: You have an er...
This is my current query $sel = "SELECT db1t1.userid, db1t1.customer_id, db2t1.customers_id, db2t1.orders_id, db2t2.products_price FROM database1.table1 db1t1 LEFT JOIN database2.table1 db2t1 ON db1t1.customer_id = db2t1.customers_id LEFT JOIN database2.table2 db2t2 ON db2t1.orders_id = db2t2.orders_id WHERE db1t1.use...
Hi guys, I am thinking this is impossible but I wanted to make sure. Is there a way for me to know when a table was locked and maybe for how long? I know that I can see whether a table is currently locked, but I would like to have a "history" of locks. ...
I'm relatively new to PHP MySQL and have tasked myself on learning with the "hands on" approach. Luckily, I currently have a (very) large database all relating to coin data with one table to work with. It currently has the following columns (each row representing a single item [coin]): Group ItemNo ListNo TypeCode DenomCode PeriodCode A...
How do I create a custom table in C#, where i'd be able to set up row titles? Is there a built-in component to do that? I'm currently migrating from Delphi, where there was a StringGrid component. So I wonder if there's such equivalent in .net. As for now, I've tried to play DataGridView, but as far as I understood, it lacks row heade...
I need to retrieve the last record in a mysql database table - is there a command for this? ...
Hi, I would like to display data, two columns per row during my foreach. I would like my result to look like the following: <table> <tr><td>VALUE1</td><td>VALUE2</td></tr> <tr><td>VALUE3</td><td>VALUE4</td></tr> <tr><td>VALUE5</td><td>VALUE6</td></tr> </table> Any help would be greatly appreciated. Thanks ...
I want to know the best way to mark up tabular data on a web page when data rows contain complex data that can't fit within a single table row. Here's a concrete example. The first line has a list of extra information attached to it about arms and legs. Shadrach M Banana 12 Arms Blue 2 Legs Yellow 3 Meshgah M Apple ...