[table] Forum Topics

hi, I am having doubt in peter_budo 's Mvc tutorial, in datbase design he has separate table for group mapping, Even we can add seperate feild (like group) in user table itself to acheive the same result, Is there any advantage in seperate that, Pls some one guide me. Sorry …

Hi, i'm trying to do a table with border:1px solid #000000 But i want border between rows and columns. Can someone help me, please? Here's my table if it helps or something: <table> <thead rowspan=1> <tr> <td>Nome da Banda</td> <td>Estilo</td> <td>Atividade</td> <td>Line Up Atual</td> <td>Line Up Tour</td> <td>Ex-Membros</td> <td>Linguagem</td> </tr> …

Hi, I've been working with Ruby on Rails to make a web application, but I've found something that I really cannot work out how to do with it, so it may be best if I do it manually. Basically, I've got a dropdown menu, that is populated with a list …

if i have roughly 25 identical tables is it possible to do the following SELECT tm_name, `tablename` as Activity from t1, t2 ,t3 where date = curdate or would it be better to add another column to the table thats hidden from the users and automatically populate with the tablename.

Struggling to get the following code to work. The code works if I just put an individual table in SELECT FROM, but I can't get anything when I try and do INSERT INTO table and then substitute it in. I am a complete noob at this and I know in …

I'd like to add a timestamp to articles I upload to my website, which reads the time and date the article was uploaded. I've got a database, as well as a working connect.php. In this database, I've created a table with a "date" field (type: date). What can I do …

Question: Does anyone have any recommendations that are likely to keep a large database healthy/speedy? I'm designing a database that is going to retrieve around thirty million data points a year, up to around three hundred million to a billion in a few years time when all of the sensors …

Hi, I'm having some trouble transfering a HTML website to Wordpress for a CMS. The HTML page which I'm transfering has a table in which I presumed I could simply copy and paste into the HTML view of Wordpress's page publisher. Inside the page publisher it looks great. You can …

in this code- CREATE TABLE `tablename` ( `id` int(10) unsigned NOT NULL auto_increment, `a` varchar(10) NOT NULL, `b` varchar(45) default NULL, `c` varchar(45) NOT NULL, `d` varchar(45) default NULL, PRIMARY KEY (`id`), KEY `Index_a` (`a`), KEY `Index_bcd` (`b`,`c`,`d`), KEY `Index_cd` (`c`,`d`) ) ....; what do the lines that start with …

Hi firends, hope you all dn well. Here i need one thing ! table1 - Which stores all user's posts ( `id`, `post`, `who` ) table2 - Which stores relations ( `id`, `from`, `to`, `status` ) ( `status` contains `accepted` and `hold` ) here i want to retreve the posts …

hi! I have 2 columns SWT table. but when I insert data (from Mysql query), it appear only in the first column. for make it show in the second, I have to change the size of the column and then the data appear. so right now, after every query, I …

Hi, Im trying to insert to a table in sql that is related to another by a foreign key. The first table has an ID, a suppliers id and a date; and the other table has an ID (that for some records should have the same id from the other …

i have a datagridview in my vb.net form displaying data from ms access file A , table A , is it possible for me to export the data in the data gridview to ms access file A table B?? i'm not using sql.

hello all i am new to web development, however i need to create a website, where a small group can have access to a table and edit/add entries then the table can be displayed and accessed by everyone who visits but also shows who edited what. and can be downloaded …

i have this code, it's purpose is to automatically add a colon when the index is 2, i have done it, but when replacing(overwrite) index 2 where (:) is, you can replace it with a different char, so basically colon will be removed. and also what if the user has …

Hi, Daniweb I'm working on a website where i did a search system and then i listed the results founded. And now i want to move them with JQuery Sortable. But i'm having dificults can someone help me please? Here's the code: <?php require_once('Connections/futura.php'); ?> <?PHP $prod=$_GET['q2']; $query_prod="SELECT * FROM …

Hello Friends, I have three table ->PatientDetails ->ParentDetails ->InsuranceDetails -Patient id is the common column in all the three tables... While saving the data in table using VB.Net there is a column in PatientDetails i.e. Insured If the patient is insured then only the values from text boxes and the …

hello every one i have created a code to create html table from php. simply user enter column and row no. and submit. this data will create a table for the same. now i want to put some names with this table. like each table column have a name from …

Hi,guys.Is that anyway to make sure the table inside a div is auto resize and 100% same as the width and height of the parent div when we resize the windows size by using css and html only?i am using height 100% and weight 100% for the table and the …

I need a really good tutorial on how to alter MySQL databases, and to know how far you can alter a database without loosing or changing the information in the database. Thanx in advance for any help

URGENT: guys i really need your help with this. I have been debugging my program for days but it doesn't seem to be improving this is the code for the table layout: <table border="1" id="COT_Table" onclick="getTableID(this)"> <td rowspan="3" scope="row">COT</td> <th colspan="4" scope="col">SFAL</th> </tr> <tr> <td colspan="2" scope="col">Temperature</td> <td rowspan="2" scope="row">vol …

i just need a clear explanation for this: var lastCol = getColumnCount()-1; var lastRow = getRowCount()-1; var table = document.getElementById(TableID); var rowSum; /*Summation of all the values in of rows*/ var columnValue; if(ths == 'on'){ for(var b=1;b<lastRow+1;b++){ rowSum = 0; for(var i=0;i<lastCol-1;i++){ columnValue = table.rows[i].cells[b].childNodes[0].value; if(columnValue != '' && !isNaN(columnValue)){ …

I am trying to insert values from a table to another table. The thing is I want it such that only a row in the source table that does not exist in the destination table should be inserted. I have set each table to have a column that automatically increments …

The hash table stores phone numbers and names, uses the names as the keys. The problem I have is when I use the terminal window to enter the names and numbers. The strange problem that occurs then is that all the names get the same phone number. But when i …

hi guys, this is my first javascript program so i'm certainly a noob. i just want to ask why doesn't this global variable not recognized by my functions .. ? the thing is i need to get the id of a certain table to count the number of rows and …

Really really need help with this one! I need to convert from php to mysql so that it reads language information from mysql, i made mysql table already but I just don't know how to change from php to mysql <?php session_start(); header('Cache-control: private'); if(isSet($_GET['lang'])) { $lang = $_GET['lang']; $_SESSION['lang'] …

Hi! I have started learn about Query and PHP, and i don't know what to do next. I have made table with query help i can show in table records from my Database, so far i have well, but next what i want to do is every record in table …

I brought the following text lines into Word 10 (aka 2002) & added the ~'s to the blank line paragraphs: How can I transform the address 'records' into tables sortable on name ? name phone adrs adrs ~ name phone adrs adrs ~ etc.... about 120 of these. If I …

Hi All, I hope someone can help me. I have loaded a page in my webBrowser control, the page has a table, please see attached for screenshot and partial page source code. I want to load specific column of that table to datagridview, how can I do that? Thanks in …

I am trying to change the data type of a primary key in table A from INT(11) to CHAR(11). However, this primary key is a foreign key in tables B and C. SQL is giving me an error whenever I try to change the value type of the primary key. …