Forum Topics Tagged [column]

I've just started working with PHP and MySQL, and I'm trying to create a table in MySQL. If I've got this right, I'm trying to do so by going to my host's SQL MyAdmin page and typing in mysql_query("CREATE TABLE example( id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), name VARCHAR(30), age INT)") in the query tab. I get an error saying that my syntax is wrong. Any advice?

Hi, i want to delete a column from a file. the file is like : 1|2|3|4|5|6|7|8|9|0 1|2|3|4|5|6|7|8|9|0 1|2|3|4|5|6|7|8|9|0 1|2|3|4|5|6|7|8|9|0 1|2|3|4|5|6|7|8|9|0 1|2|3|4|5|6|7|8|9|0 if i want to remove any column the outout should be like ( suppose 4): 1|2|3|5|6|7|8|9|0 1|2|3|5|6|7|8|9|0 1|2|3|5|6|7|8|9|0 1|2|3|5|6|7|8|9|0 1|2|3|5|6|7|8|9|0 1|2|3|5|6|7|8|9|0 i have used swk command, but its not giving the desired output: its giving some extra delimeters: awk 'BEGIN{FS=OFS="|"}{$4="";gsub(FS,"")}1' file please help

How to get min/Max value of a all column in a two-dimensional arra so for example, lets say you have the following 2d array: 1 2 3 4 5 6 7 8 9 Than the out put should be: -- col 1 -- min value at col 1 is 1 max value at col 1 is 7 -- col 2 -- min value at col 2 is 2 max value at col 2 is 8 -- col 3 -- min value at col 3 is 3 max value at col 3 is 9 public static void col(int[][] array) { for …

Hi folks. The short question: (A) **Can I set the colour on each individual item/element/point/column in a chart with column series? Or even have gradient on it?** (B) **I want to put names on each column, visible under the X-axix. Now they are simply numbered.** (C) data source? (see below) The longer explanation why I ask: (A) Im trying to make a nice chart for my eight batteries that i'm supervising via the serial port. Normally, the elments of one series in the chart always have the same colour. But I want the column to change colour if the voltage …

I'm facing this strange problem while working with DataGridView. In my application that i'm building, there is a form with some tabs, and im using the dataGridView Controls in some of the tabs. These dataGridView controls have already been configured, with a number of columns already added, and has been working perfectly fine for a long time. Today when i open the project, i see that one of the dataGridView has all the columns mysteriously deleted! I had to re create the entire control all over again. As soon as i finish that, i see that its happened to another …

Hello. There is an html table in admin page, with head columns (POST ID | POST TITLE | POST AUTHOR | ACTION). And in each row, will contain a post id, a post title, a post author that gets from database. And in the Action column, there is a "delete" word that is a link with href="#" for now. I want the script when i click on the delete word in each rows, erase that row of data from the table of the database and from the html table. I don't know how should i do that. Just need guidance …

I am in need of help on this one :( i cannot seem to figure out what i have done wrong, i set up my code just like in teh examples i read and i dont really see anything wrong with the logic (as far as i can tell) but the code will RETURN as data added successfully but i know better cause nothing shows up in teh database. heres the html <input type="hidden" name="cnotes" values="<?php echo $u ?>"/> <textarea class="field span12" id="note_text" name="note_text" type="text" rows="9" maxlength="10000"></textarea> <input id="add_note" type="submit" class="pull-right" name="add_note" value="Add Note"></submit> this code is what i used …

hey guys. i have this table that lists contacts that are stored in database. the data is selected from 2 tables using join which i have already got working: SELECT c.contact_id,c.salutation,c.fname,c.lname,c.dob,c.houseadd,c.personalno,c.officeno,c.email,c.spouse,c.child, s.spouse_id,s.s_salutation,s.s_fname,s.s_lname,s.my_spouse FROM contact1 c LEFT JOIN spouse1 s ON c.contact_id = s.my_spouse what im having trouble with is selecting another column based on data in one column. okay so this is my contact1 table: id|salutation|othersalutation|fname|lname|dob|houseadd|personalno|officeno|email|spouse|child| column 'othersalutation' i just added it in today as requested by my supervisor. 'salutation' is only for one salutation like 'Mr.' or 'Mrs.' etc(its a dropdown in the html form) while 'othersalutation' allows user …

Dear fellows, i have a problem here, is there anyway to implement the drag and drop function for users to reorder the column sequence? i have tried several ways but it still not working, any hints can enlighten me? bottom is part of my code, thanks in advance. [CODE] DataGridView1.AllowUserToOrderColumns = True DataGridView1.SelectionMode = DataGridViewSelectionMode.FullColumnSelect Private Sub DataGridView2_DragOver(ByVal sender As System.Object, ByVal e As System.Windows.Forms.DragEventArgs) Handles DataGridView2.DragOver 'Just to Show a mouse icon to denote drop is allowed here e.Effect = DragDropEffects.Move End Sub [/CODE]

Hey guys, so im wondering if theres a way to insert 2 input values into one column in PDO? coz in mysql_* i just did something like this and it worked: INSERT INTO tablename VALUES ('input1 input 2', 'input3'); pdo i tried : $event = $dbh->prepare("INSERT INTO event(event_name,start_event,end_event,event_venue) VALUES('$name', CONCAT_WS('$dstart', '$tstart'), CONCAT_WS('$dend', '$tend'), '$venue')"); read that CONCAT_WS suppose to work but only the second parameter got inserted i.e : $tstart when its suppose to be $dstart $tstart TIA!

Why does the size autoresize and how can I stop it? <!DOCTYPE html> <style>td{border:1px solid black;width:100px;}</style> <table> <tr> <td></td><td></td><td></td><td></td><td></td> <td></td><td></td><td></td><td></td><td></td> <td></td><td></td><td></td><td></td><td></td> <td></td><td></td><td></td><td></td><td></td> <td></td><td></td><td></td><td></td><td></td> </tr> </table> If there only one `<td></td>` then it displays as 100px but when they exceed the screensize they just bulk up by size reduction. Like why is the top row resized in this http://jsfiddle.net/gj95X/3/ But I don't want any of them to resize.

Hello, I have my password column with varchar(50) datatype. now i have created a new column NewPassword binary(16). I want to convert password varchar data to binary(16) format in NewPassword column. How can i do it? Thanks.

Hi People.... I have a table named 'csv_data_table' and it has a varchar(255) column named 'EMAIL' This EMAIL column has multiple records with white spaces (at front and end) I tried this way to eliminate the white space UPDATE csv_data_table SET EMAIL = trim(EMAIL); But it won't work.... the email values still have trailing blank spaces. anyone know of a solution?

I need to write a code that is gonna remove a whole row/column in a matrix(either static or dynamic matrix)

I have a 5 listview listview1 has two columns listview2 has one column listview3 has one column listview4 has one column listview5 has five column now i want this scenario in every column of listview5 in listview5 columns first column of listview5 is equal to listview1 first column the second column of listview5 is equal to listview1 second column the third column of listview5 is equal to listview2 first column the fourth column of listview5 is equal to listview3 first column the fifth and last column of listview5 is equal to listview4 first column is it possible?? considering that every …

Good day What I would like to do is to alter a mysql table with data in it then add manipulated string data to that created column i.e I first add an extra column to my table then add a reverse string coded from data that had already been inserted. I have an email field in my database so what I would actually do is to take the email address reverse string it then insert it into the newly added mysql column. My reverse string works perfectly its just that I can't seem to add the extra column to my …

Hello I am using jxls quite fine. I'm sort of on my last lap with exporting my data to a file. However all I want to know is, how do I display my collection in the same row please? I've manage to do this downwards in the same column, but I'm not sure how to display them across in the same row. There website telss me how to do multiple collections across, but not one. Oy. I hope someone has an idea, because it "seems" simple enough.....seeems, but I judt don't tknow the syntax.

please help i am trying to extract data from database into multiple columns but i can't get it. All your helps is very needed. Thank you! this will be the output (actual value of my serial table) 1233BED13DS01132 1233BED13DS00878 1233BED13DS00012 1233BED13DS00097 1233BED13DS01315 1233BED13DS00461 1233BED13DS00835 1233BED13DS00010 1233BED13DS01313

Hello, guys.. I am actually working on a project. I can't figure out how to limit the displayed content on a table of a particular data. I have a table (tblservices) that have fields (service_id, service_name, service_content, date_created).. *the service_name* is the title of the service, *service_content* is the whole description and guideline of the service. Now, I want to display all the data on tblservices (SELECT * FROM tblservices) in a table. I succesfully displayed all the data on the table, but on the column of service_content, I just want to display a short part of the service_content not …

[CODE] SELECT count(*) FROM information_schema.`COLUMNS` C WHERE table_name = 'your_table_name' AND TABLE_SCHEMA = "your_db_name" [/CODE] TABLE_SCHEMA is required only if table name exists in more than one db

I am a beginner I am using with CORSIKA software. cosika's outputs are text files with 8 or 7 column and more than 2000 row(like matrix) . Arrays of this matrix are number in Scientific notation like fallowing image  I want to read data in 7th column and calculate some parameters like average, maximum, minimum in one column. I have this code to read and display text file but i dont know how use numbers and calculate some parameters. #include<iostream.h>
#include<stdio.h> #include<conio.h> int main() { FILE *k; char c; k=fopen("c:\\fff.txt","r"); c=getc(k); while(c!=EOF) { cout<<c; c=getc(k); } getch(); …

Greetings! I'm building a PHP table from data I'm pulling from a MySQL database. I'm querying data from two tables where the common field between them is a customer ID. Table A contains customer ID and a customer score. Table B contains customer ID and a mailing code. The easy part is querying the data in such a way as to show me how many customers with a certain mailing code have a particular score. So, here's my query: select score,count(score) as qty from custscore where customer_id in (select customer_id from all_buyers where keycode = '12345678') group by score The …

Hi. I'm confuse on how I will create my temporary table. Need some clarification here. I want to create a temporary table that will hold some column and values. And later on I would alter/update the table to add another column and data with respect to the existing columns. ammm... how will I do this? Is it better to create my table were first at hand I will define the columns it needs and just update it or let the select statement define its columns which means I need to alter the temporary table to add the new column?

Sorry guys, asking simple question for which i don't have the solution. please help me. Can you modify my query to return single column with both name and sname ?(rename the column if required) select name, sname from claim,CV where claim.num=cv.cnum

public void kraGridView_RowDataBound(object sender, GridViewRowEventArgs e) int totalPercent = 0; if (e.Row.RowType == DataControlRowType.DataRow) { Label lblWeigh = (Label)e.Row.FindControl("lblWeigh"); // totalPercent += Convert.ToInt32(DataBinder.Eval(e.Row.DataItem, "lblWeigh")); int total = int.Parse(lblWeigh.Text); totalPercent += total; } else if (e.Row.RowType == DataControlRowType.Footer) { Label lblTotalPercentage = (Label)e.Row.FindControl("lblTotalPercentage"); // e.Row.Cells[5].Text = totalPercent.ToString(); lblTotalPercentage.Text = totalPercent.ToString(); } }

I have a mysql database that includes the fields first_name, last_name, email. I have an input form to enter in the above information. If the e-mail address already exists, then I have a message page that lets the user know this and display the first and last name that already exists. Duplicate first and last names are OK. The code below is not catching the duplicate e-mail address that is entered in the input form. How do I get it to work? $result = mysql_query("SELECT * FROM mail_list_db where '$email_address' = email") or die(mysql_error()); $count = mysql_num_rows($result); echo "Count = …

I am working in a dataware house and few things are not clear to me that is why I wanna discus here. For example, I have 10 MS Access files, and each of they have more than 5000658 number of rows, and data is in such a format like **Plz check attached image currentState.png** Whereas I have to import this large amount of data into MSSQL which can support large amount of data, where as MS access can support only up to 2 GB. And when I will import all of the data into MSSQL then total number of rows …

I have a table that shows tabular data across 7-8 columns, which works very well on a standard monitor. However, on a smartphone or even a tablet, it's a little less functional. Is there a way to automatically condense the data into fewer columns when the page is being view mobile devices? I can detect the user-agent OK, and can use CSS to set off the different data elements. What I don't know is how to set up the columns differently, I'd really like to set it in 1-2 columns on a mobile device. Perhaps this belongs in the PHP …

hi, it is possible that one column in a row has a data ? and how to code it in vb6 if possible, please help example NAME: rasha bonquel Age : 20 SUbject : Math , English, Science Grades : 78, 78, 78 NAME | Age | Subject | Grade Rasha Bonquel | 20 | Math | 78 | | English | 78 | | Science | 78

Hello good day. I am designing two JTables; one on top of the other. The first one has nine columns. And the second one has 8 columns (The first column spans the first columns of the topmost table). What I wish to do now is to make the bottom table reactive to the movement of the margins in the topmost table. I wish for them to stay aligned. How do I accomplish this please?