955 Topics
| |
Hy. I'm trying to do a select from multiple databases and tables for an occurence. let's say i have databases db1, db2 and db3. Each have the following tables t1, t2, t3. And in each table there is a field named id which i want to select and a field … | |
hello all i am using a query [ICODE]select 'hour','filename','tot_sent_count','tot_success','tot_prm_fail','tot_switchedoff','tot_other_error' UNION select hour,filename,sum(tot_sent_count),sum(tot_success),sum(tot_prm_fail),sum(tot_switchedoff),sum(tot_other_error) INTO OUTFILE '/tmp/hourlyFileMis(2011-03-09)' FIELDS TERMINATED BY ',' LINES TERMINATED BY '\r\n' from tbl_mis where date_format(date_time,'%Y-%m-%d')='2011-03-09' group by hour,filename order by hour;[/ICODE] output is ok but one thing is not coming properly that header fields are coming at the … | |
Good day.. I'm having problem on how to store or create a table on my database using vb.net i'm having hard time to create a table on my existing dbase here my code; coould you tell me what's wrong!!! Dim ntable As OleDb.OleDbDataAdapter Dim mtable As New DataTable con.ConnectionString = … | |
I'm making a fairly easy to edit and change public dictionary and am working on the viewer hooked to an SQL server. The problem I'm having is, isn't really a problem but I'm looking for a better solution, due to it possibly devolving into a huge mess of sorting a … | |
I have a set of code that builds a table as the user enters information. This information may be changed more than once before it is considered complete. After the user is done, I want them to click a button, and have that information entered into the SQL database where … | |
hi guys, i wanted a table to get created with the table name submitted from the form. how shall i go about this, i have tried it with my basic knowledge its here bellow but it dint work well, please help me anyone. [CODE] <?php if (isset($_POST['update'])) { mysql_connect('localhost', 'root', … | |
I have a php script that echoes results from a search. Generally I have no problem getting the results in a table but for some reason I can't get these scripts to do that. I figure its a small error. I'm going to put in the code but if you … | |
Hi Guys, Can anybody spot the error on this code? it gives me error: SQL Server Database Error: Incorrect syntax near the keyword 'inner'. 5 0 [CODE]Select e.event_number,e.start_date ,event_desc, venue_desc,s.location from events e inner join venues v on v.venue=e.venue inner join sessions s on s.event_number=e.event_number and session_type='0' (inner join contact_categories … | |
hi, guys i have a problem here. i have a form which creates a new table for each new user and that user will have a monthly update of his salary now im confused how to go about this. do i need to create a new table or how to … | |
I currently have a linked table from two tables in one database. I would like to add information from a third table contained in another database. The code for the current table is: [CODE] <?php $con = mysql_connect("","",""); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("", $con); … | |
Hello, I'm curious as to what the "key" for a DataTable Row collection is. And if there is a better way of executing what I'm trying to do. My situation is this. I have a DataTable populated with different data from multiple databases, for the sake of this thread let's … | |
This is a database dictionary page which has two drop-down boxes. [COLOR="Red"]first [/COLOR]- for the tables in the database(it displays all the table names in the dropdown. Second - for the columns of the table selected in the previous dropdown n then on selecting the column name it should display … | |
[CODE] <table width="100" border="1" cellpadding="0" cellspacing="0"> <tr> <td width="118" rowspan="2" valign="top"><p>Grupės pavadinimas</p></td> <td colspan="5" valign="top"><p>Maitinimo išlaidos Lt (už 1vaiko lankytą, nelankytą ir nepateisintą dieną) </p></td> <td width="104" valign="top"><p>Kitos išlaidos per mėnesį (išlaidos darbo užmokesčiui ir įmokoms soc.draudimui, kt. prekėms ir paslaugoms)</p></td> </tr> <tr> <td width="111" valign="top"><p>Pusryčiai</p></td> <td width="67" valign="top"><p>Pietūs</p></td> <td … | |
| |
hello all. i wasnt sure if this should go in the php or javascript forum but here we go. i have a php table pulling info from a mysql table. each row contains the name of a user. the users names are links which should take you to a bio … | |
Hi all! I have a question about PyQT4. How can I get an index of current cell, in which the cursor is whitout clicking on it? According to official documentation of QT there are only signals that send current index when you click on it. But if you just enter … | |
I'm trying to display a picture stored in a msyql database. I have the following script, picscript.php, to call the picture from the database: [CODE] <?php $username = ''; $password = ''; $host = ''; $database = ''; mysql_connect($host, $username, $password) or die("Can not connect to database: ".mysql_error()); mysql_select_db($database) or … | |
I'm a php noob and I have a feeling that there is a simple solution to my question. I have a php mysql table search that returns a result sucessfully. What I would like to be able to do is select one of the results to be inserted into a … | |
I'm trying to search a mysql table column for a number. However when I enter a number into the search form I get told that no query has been entered. Here is my code. Database connection information left out on purpose. [CODE] <?php if(isset($_POST['submit'])){ if(isset($_GET['go'])){ if(preg_match("/^[ a-zA-Z]+/", $_POST['search'])){ $search=$_POST['search']; $db=mysql_connect … | |
I am trying to create an Excel sheet and save it in server... Once it is saved, I display a link to the user "download excel". He can click it and then download it.. The pblm is I cant save the excel it says "The file could not be accessed." … | |
I am setting up a database currently and I want frequently used values stored in a Code table on my database. The Code table is setup with the following columns: Type_CD" , "Code" , "Description". For example, if I wanted to pull a list of states, I would want all … | |
[ICODE]#include<iostream> #include<conio.h> #define height 10 using std::cout; using std::cin; using std::endl; int main () { //int num=0; int n,m,width; int count = 0; int nums[count]; int div=0; cout<<"Enter the number you wish to enter: "; cin>>width; int jologs [height][width]; cout<<endl<<width<<endl; for (int i=0, m=width; i < width; m--,i++) { cout<<endl<<endl<<"Number(s) … | |
Hey, I have a table on my site in which I want to <th> to have a background-color of black and the <td> to have a background-color of grey. Also to have a border at the bottom of the cell and none on the top of sides. Now I have … | |
Hi , I am a Newbie using SQL server and vb.net in VS2010. I am re-writing an exisitng application which is written in an old programming language. I have a table with invoice records waiting to be assigned an invioce number and invoice date. I have two ways of uupdating … | |
Hi, I am a beginner, and would like to do something like: I have a mysql table with date column. I would like to select all the rows from table, and print them out in tables. One table per month. E.g. January: ... ... ... February: ... ... ... etc. … | |
Hi all, i wonder is it possible to display my images from database into table with 4 rows and 4 column? How can i do that? [CODE] $dbConn = mysqli_connect(DBSERVER, DBUSER, DBPASS, DBNAME) or die(mysqli_connect_error()); $sql = "select * from products"; $result = mysqli_query($dbConn, $sql) or die(mysqli_error($dbConn)); echo "<table border … | |
i am writing a program and i need to increment a table row. How would i increment a table row on the click of a button? | |
I want a table that is auto computing like the ability of the microsoft excel that when I input a data in cell B1, C1 and D1( just an example on the features of excel ) it will compute an average in cell E1 which does not need to press … | |
Im a newbie and im working with 4 forms, first form is a main menu which has 6 buttons, if one of the button is clicked, a view only form is shown. this view only form has add edit and delete buttons. if edit or add is clicked, a single … | |
Okay, So I want an array to get userinformation by the username that is provided. But in the other tables, it only has a ID field to link with... [CODE]$sql = "mos_users.id as userid, block, username, email, lastvisitDate, firstname, lastname, avatar, cb_age, userip FROM mos_users, mos_comprofiler, mos_comprofiler_plug_iplog WHERE mos_users.username = … |
The End.