Hello I have an SQL query that i want to concatenate the fields and display it in a way that those concatenated fields will be displayed first row will have 4 columns,second row will also have 4 columns....etc. for instance the query `SELECT imageurl, caption, template FROM template; The Result imageurl caption template image001 cap001 temp001 image002 cap002 temp002 image003 cap003 temp003 image004 cap004 temp004 image005 cap005 temp005 image006 cap006 temp006 image007 cap007 temp007 image008 cap008 temp008 I want it to be displayed this way cap001 cap002 cap003 cap004 image001 image002 image003 image004 temp001 temp002 temp003 temp004 cap005 cap006 cap007 …

Member Avatar
Member Avatar
+0 forum 4

Im new to PHP, i just want to know if theres any rule in php in terms of single statement multiple lines. for example in VB.Net we uses "&_"(w/o the quote) to tell vb.net that it is a single statment and it has a continuation. is there any in php? *Heres the sample in In VB.Net* "INSERT INTO table(field1," &_ field2)VALUES(value1," &_ "Value2)" in php= ???? It will be a big help for a newbie like me. Thanks

Member Avatar
Member Avatar
+0 forum 5

Hi again guys please forgive my unknowing, i tried but simpply got errors. I downloaded this upload script ( [Click Here](http://www.phpkode.com/scripts/item/es-simple-uploader/) ), it works great except it's for single file uploads, not multi-file uploads The website I'm working on requires the ability to upload multiple files at the same time, can anyone please help me convert this file to be able to support multi-file uploads. (code cleaned so just the neccessary code is showing, for full code (styles etc) see the link above This is the index.php file, config file sinply sets the directories and passwords and size limit. <? …

Member Avatar
Member Avatar
+0 forum 2

This is what i want 2 form in my navigation bar. First is for Search Box second is for username and password.login button problem is if i put search box and login in same form then it gives weird look and formation error. Second Now I want to use buttons in master page That needs to be run on server but can't run without 2nd form running on server. Is there any alternative to use Textbox control button link button searchbox control without using <Form> Running on server.? Here is the code I'm using Bootstrap <%@ Master Language="C#" AutoEventWireup="true" CodeFile="MasterPage.master.cs" …

Member Avatar
Member Avatar
+0 forum 2

I have huge csv file that i need to load into database using sql loader. In the file, there are columns enclosed by ", but some of them is not and in these columns there are single quotes and I would like to know how to deal with them (I can't change csv file): LP31388-9.LP31392-1,4,LP31392-1,LP15305-3,5'-Nucleotidase LP31388-9.LP31392-1.LP15305-3,1,LP15305-3,LP45022-8,5'-nucleotidase | Amniotic Fluid LP31388-9.LP31392-1.LP15305-3,2,LP15305-3,LP45028-5,5'-nucleotidase | Bld-Ser-Plas LP31388-9.LP31392-1.LP15333-5.LP44699-4,2,LP44699-4,1743-4,ALT SerPl w P-5'-P-cCnc LP31389-7.LP18116-1.LP16832-5.LP175708,7,LP175708,LP181867-5,"2,3',4,4',5-Pentachlorobiphenyl (PCB) | Bld-Ser-Plas" my sql loader control file OPTIONS (errors=0, SKIP=1, SILENT=(FEEDBACK)) LOAD DATA CHARACTERSET UTF8 INFILE 'data/hierarchy.csv' INTO TABLE hierarchy FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( path_to_root …

Member Avatar
Member Avatar
+0 forum 2

I'm trying to display some records which meet some certain criteria. That works fine, but I also want to retrieve the total amount of orders. These are all located in the field 'Amount' from the Orders table. So if record 1 has got '22' in it's amount field, and record 5 has got '55' in it's amount field.. the total should be 77. My sql coding looks like this: SELECT Orders.OrderID, Customers.CustomerName, Orders.OrderDate, sum(Orders.Amount) as total FROM Orders INNER JOIN Customers ON Orders.CustomerID=Customers.CustomerID where customers.country='Germany' order by Orders.Orderdate But it only retrieves 1 record (due to the summage), when I …

Member Avatar
Member Avatar
+0 forum 4

Hello, Self taught guy here. Thanks for reading my post. I've made a app to track the sales of floating rubber ducks for a duck race. I have a database which contains data similar to this: id soldby package ------------------------ 1 John 6 2 John 25 3 John 1 4 John 6 5 John 25 6 John 1 7 Tammy 6 8 Tammy 25 9 Tammy 1 10 Tammy 1 11 Tammy 6 12 Tammy 25 13 Tammy 25 The number in the package field refers to the number of ducks purchased. Each package 1,6 and 25 has a dollar …

Member Avatar
Member Avatar
+0 forum 8

Hello everyone, I'm trying to basically get a cmd variable to pass into commands.getstatusoutput. The problem is that the command has a lot of single and double quotes in it and I can't seem to get it to store as a variable. When I print the cmd it comes out as I want it to (since I tried \ escaping one of the single quotes.. here is an example of what I'm trying to do: cmd1 = "convert -pointsize %i -fill %s -draw " % (pointsize, fill) cmd2 = ''text %d,%d "%s Hour: %i"' %s %s_cap.jpg' % (half_image, up_buff, out_month, …

Member Avatar
Member Avatar
+0 forum 5

If I boot the system in single user mode, can we directly edit the file?

Member Avatar
Member Avatar
+0 forum 1

im trying to create a email signature, and i want the images inside the signature to be linked to a feed, for example tumblr. where the moment an image is uploaded to it, it is automatically placed inside the email signature. is this possible?

Member Avatar
Member Avatar
+0 forum 1

i'm storing 2 images at a time in my database table in a single row. 1st image was Applicant Photo Name as Image In Db & Second Image Was Applicant Sign Name as Sign in Db. So I'm retriving Both At single shot.But I'Want To Display Images Both At a Time.. Please Help Me. $sql = "SELECT image,sign FROM test WHERE id=" .$_GET['id'] . ";"; // the result of the query $result = mysql_query("$sql") or die("Invalid query: " . mysql_error()); // set the header for the image //header("Content-type: image/jpeg"); //echo mysql_result($result,0); // close the db link while($row=mysql_fetch_array($result)) { header("Content-type: image/jpeg"); …

Member Avatar
Member Avatar
+0 forum 1

hi everyone. I want to delay the click event in a vsFlexgrid so that the double click event will run 1st. I used a timer for the delay in the click event and managed to get the value of the double click speed in the windows library for the timer interval. however i still cant make it work the way I want to. Its still running the click event rather than running the double click event 1st. hope you can enlighten me with this. here's my code. ''General Declaration Declare Function GetDoubleClickTime Lib "user32" () As Long ''Form Declaration Private …

Member Avatar
Member Avatar
+0 forum 5

K! Any chance of having a option to not get notifications regarding a single thread updates????? "What are you eating/drinking right now?" have gone out of bound, that i keep getting the mail notifs...... Can i unfollow only that thread only........ Sofar the only option seems to be unsuscribe the entire daniweb notifs.........

Member Avatar
Member Avatar
+0 forum 5

So this is going to be the last project for my java class. Any input is appreciated and I'm generally posting it here because someone else might benefit from it. It is not done yet but when it is I'm going to post the full code. I made a video about this u can see it here: https://www.youtube.com/watch?v=wWmsXcuW6FE The ball class: /* * This is the Ball class */ public class Ball { //variables for the x and y position private int xPos,yPos; //the direction of the x and y position. Dy is set to -5 because, //remeber that the …

Member Avatar
+0 forum 0

hi all, In the book "Programming Languages-Pragmatics" second edition by Michael l. Scott and Morgan Kaufmann, there is a sentence while explaining about copy constructor: "In recognition of this intent, a single-argument constructor in C++ is called a copy constructor." This is about the constructor of the form foo::foo(const foo& object); I could understand about that constructor but couldn't understand the statement I have quoted above...I think we cannot state that every single-argument constructor is a copy constructor....If I'm wrong or I seems to be misunderstood the sentence...please help me.... Copy constructor: foo::foo(const foo& object); Normal single argument constructor: foo:foo(int …

Member Avatar
Member Avatar
+0 forum 4

I have 1 picturebox loaded with an image, what i'm trying to do is every time i click on loaded image the same picture loads into empty picturebox. Now for 1 picturebox is easy, all i do is picturebox1.Image = img; I'm trying to make an event that will load image to next empty picture box This code is in the picturebox.click event that is loaded with image int counter = 0; List<PictureBox> pbox= new List<PictureBox>(); //Holds list of PictureBoxes that will be loaded(currently there are 28) PictureBox img = ((PictureBox) sender); //Holds the image that i clicked foreach (Control …

Member Avatar
Member Avatar
+0 forum 5

I want to select multiple files at a time and upload them by single click. Thanks & Regards, Sunil

Member Avatar
Member Avatar
+0 forum 1

So i have this table: numb_1 | numb_2 | numb_3 ------------------------ 5 | 5 | 5 1 | 5 | 5 2 | 2 | 3 5 | 3 | 6 5 | 4 | 7 how do i find the most common value in the 3 fields? so for the example above it would give me 5

Member Avatar
Member Avatar
+0 forum 3

Right guys, I'm really new to this but I'm getting along ok, but I've hit a block. I need to be able to know how to search a text file in VB for a particular line and then display it. the files I'm trying to use are set up as: ID, Name, Address, Birthday, Pay-Roll Type So I need to know how to search the file for the ID number and then display the rest of that line I can read a file from beginning to end but this I am clueless about, thanks It's for a system to add, …

Member Avatar
Member Avatar
+0 forum 16

Right guys, I'm really new to this but I'm getting along ok, but I've hit a block. I need to be able to know how to search a text file in VB for a particular line and then display it. the files I'm trying to use are set up as: ID, Name, Address, Birthday, Pay-Roll Type So I need to know how to search the file for the ID number and then display the rest of that line I can read a file from beginning to end but this I am clueless about, thanks It's for a system to add, …

Member Avatar
Member Avatar
+0 forum 4

I have an assignment question that asks us, given a test phrase, [CODE]// the first comment public class Test { // another comment public static void main( String[] args ) { // the main method String slashes = "//"; // ignore // in quotes System.out.println( slashes + " hi " + slashes ); } // end of main }[/CODE] ^ Test Phrase We have to go through the code and remove all the 1 line comments. Taking what was given as an aid to the problem i modified to look like this [CODE]import java.io.IOException; import java.io.BufferedReader; import java.io.FileReader; import java.io.Reader; …

Member Avatar
Member Avatar
+0 forum 11

Hi all, I've been using this type of code to pull out a single value from my SQL database but I can't help thinking that there's a simple command I'm not using: [CODE] strSQL = "SELECT MAX(Stage) FROM Visits WHERE ScheduleRef = 22" FinalStage = dl.getPRISMdata(strSQL).Tables(0).Rows(0).Item(0)[/CODE] [CODE]Public Function getPRISMdata(ByVal strSQL As String) As DataSet Dim conn As New SqlConnection(ConnectionStringPRISM) Dim ds As New DataSet conn.Open() Dim da As New SqlDataAdapter(strSQL, ConnectionStringPRISM) da.Fill(ds) Return ds End Function[/CODE] It's the tables(0).rows(0).item(0) that bothers me. It works, but should I be doing something different here? Something more efficient in the function perhaps? Thanks!

Member Avatar
Member Avatar
+0 forum 2

Hi everyone! This problem has me stumped. I haven't had to work with php for about a year and I have sure gotten rusty. I have created my array, but beyond that was just doodling ideas to try and put something together...can you offer advice? Here is the problem I was given: A hypothetical program computes for three seconds then outputs a variable length record to be printed. The printer takes from 0.75 to 4.75 seconds (average time is 2.75 seconds) to print each output record. (Use a random number generator) The hypothetical program loops 500 times for each case …

Member Avatar
Member Avatar
+0 forum 3

I am making a project for my client who needs a system that has to have a user interface (an Asp website) and a Manager interface (a C# app). the twist is that no matter how many new users sign up or edit their account via website or the manager adds the himself the new members, these changes are to be updated both for manager and the users database. Is it possible if using Ms Visual Studio 2010 and MySql ? How i can accomplish it?

Member Avatar
Member Avatar
+0 forum 1

how to update single row from table by using a single sql query. here im using library system.when a book is issued to the user,it should be updated to database, only which book is issued

Member Avatar
Member Avatar
+0 forum 1

Hey All! I'm having trouble getting the nodeValue of a specific set of nodes. The xml looks like this: [ICODE] <root> <SpecialParameter>Some Text</SpecialParameter> <SpecialInfo someNumber="123456789"></SpecialInfo> <book> <title>Rusty Bedsprings</title> <author>I. P. Knightly</title> </book> <book> <title>Rush To The Out House</title> <author>Willie Makeit</title> </book> </root> [/ICODE] What I need to get are the <SpecialParameter> and the number in <SpecialInfo> so what I have is this: [CODE] $sp = $doc->getElementsByTagName( "SpecialParameter" ); $directive = $sp->item(0)->nodeValue; $si = $doc->getElementsByTagName( "SpecialInfo" ); $directive = $si->item(0)->nodeValue; [/CODE] Both return objects but the objects are empty... What's the secret to accessing the first two nodes? Or, for that …

Member Avatar
Member Avatar
+0 forum 8

Hi All I am trying to get vb.net to select a single node by id. I then want get all of the childnodes within the id and place them in to textboxes. Please see code below: Xml doc [code] <Subject> <Items> <Item id="1"> <CustName>john</CustName> <Filename> </Filename> <StartDate> </StartDate> <FinishDate> </FinishDate> <Cost> </Cost> <PayFrequency> </PayFrequency> <Type>Video</Type> <File>c:\test.avi</File> <Time>6</Time> <TimeFrom>181</TimeFrom> </Item> <Item id="2"> <CustName> </CustName> <Filename>........................................... [/code] Vb code [code] Dim doc As New XmlDocument() doc.Load(module1.path) Dim n As XmlNode = doc.SelectSingleNode("/Subject/Items/Item[@ID='1']") TextBox1.Text = n("CustName").InnerText [/code] Have scoured google and Daniweb forums but cannot find the answer im looking for. Thanks for …

Member Avatar
Member Avatar
+0 forum 2

Hi, I'm trying to write a script where I can click an image to hide a table, then hide the table and change the image. Then if I click the image again, it should show the table and change the image to the initial image. Below is the code I have so far: [CODE] <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <title></title> </head> <body> <script LANGUAGE="JavaScript"> function showHideTable() { if (document.getElementById.("showHide").src == "Hide Table.bmp") { document.getElementById("TableRow").style.display = ''; document.getElementById("showHide").src = "Show Table.bmp"; } else { document.getElementById("TableRow").style.display = 'none'; document.getElementById("showHide").src = "Hide Table.bmp"; } } </script> <img id="showHide" …

Member Avatar
Member Avatar
+0 forum 10

Hi all, I'm trying to write query in MSSQL which will return a single value, but the problem is, I want to get the result by a position in results, e.g. [code=sql]SELECT [ID] FROM dbo.Users WHERE Status = 1[/code] -- and then some code to get let's say fifth record from the result. So far, what I've met is the TOP command that allows you to get top range of results. So is it possible to retrieve a value by its position?

Member Avatar
Member Avatar
+0 forum 1

i would like to know the way we can make user enter a number in a menu reply perhaps so that he doesnt have to press the enter key...........i.e. the program automatically proceeds with the give value and doesnt wait for an enter key to be pressed. its easy in foxpro but i dont know the way to do it in C.

Member Avatar
Member Avatar
+0 forum 3

The End.