703 Topics
|
|
|
I have a table in mysql with the following data: | StartDateTime | FinishDateTime | | 2016-08-18 10:00:00 | 2016-08-18 11:00:00 | | 2016-08-18 12:00:00 | 2016-08-18 14:00:00 | | 2016-08-31 17:00:00 | 2016-09-01 09:00:00 | What I would like to get as the output is | Month | Duration … 
|
|
My Error info isnt being clear enough for me to understand the problemIs there anything worng here so i can continue on lookng for the probelm: $sql = "INSERT INTO boards ( title, genre, creator, tagline, intro, remessage, visability, recruitment, reqsheet, reqdice, reqgroup, ppweek) VALUES ( $title, $genre, $creator, ". …
|
|
Hi I using jquery in my page and i have a combox . Now i need to save the combobox value in an single session storage each time when i select the values from combo box and then use these values in other page . Can any one help to … 
|
|
I have a problem that in my sql is always updating the last records. I need to loop in every row and update each record in that row i tried this code underneath but only last record is updating . <tr> <td value="<?php echo $_SESSION['flowertypename'];?>"><?php echo $_SESSION['flowertypename']?></td> <?php $query7 = …
|
|
Dear all I am a beginner in web development. Please help to resolve the below problem. Right now I am creating a Workers Directory with sql database. This is including worker name, Location, Work and mobile numbers. > When customer select the specific job we need to filter particular job …
|
|
: CREATE TABLE CUSTOMERS ( CUSTOMER_ID numeric(3) not null, LASTNAME varchar(50) not null, FIRSTNAME varchar(50) not null, STREET_ADDRESS varchar(50) not null, CITY varchar(50) not null, STATE char(2) not null, ZIPCODE char(5) not null, E_Mail varchar(50) null, Primary_Phone char(12) null, CURRENT_BALANCE real(8,2) not null, CREDIT_LIMIT real(8,3) not null, SALES_REP_ID numeric(3) not …
|
|
Hi! Having a hard time figuring out how to solve this problem at hand. basically i have several tables that are inter connected in some manners but i need to full all this data and format it in a manner that it will show the total number of trips and … 
|
|
|
I am banging my head again, and appologise if such a qestion has been posted and answered - i searched and could not see any results matching my question. I have a datagridview1 full of data, one column has a date and another a qty. datagridview1 Date Qty 2015-11-05 | … 
|
|
Hi everyone, I have a submit form on my website that display's to the user once is has been submitted, The problem I have is the text is being displayed as Chris & Amy\&#39;s 30th It should be displayed as Chris & Amy's 30th What is the best way to …
|
|
|
Hello. Allow me to apologize in advance regarding any abnormal phrasing. There is a certain table, hereby dubbed IPT, containing 4 keys and a variety of values. I wish to select several values spread throughout IPT, anchored via the first three keys and a varying fourth. Currently, this is achieved … |
|
|
How to retrieve data from another database using PHP, mySQL? 
|
|
I have a SQL Server bank account table which contains ... ID (Identity) Trdate (Date), Description (Varchar), Debit (Money), Credit (Money), Balance (Money) Details (Varchar) I want to list a subset of the transactions between two dates (the period of an Australian Financial year) and the query below works correctly …
|
|
|
I used below select query to select information from two tables. But it show one record. How to change this code to view all records ? select loan.loan_id, loan.customer_name, loan.total_amount, ifnull(sum(settlement.amount), 0) as 'Total Received', ((loan.total_amount) - ifnull(sum(settlement.amount), 0)) as 'Total Due' from loan left join settlement on settlement.loan_id = … 
|
|
|
What's the current status of the API following the update to tags? For searching, can ony see: `http://www.daniweb.com/api/articles/search?query=blah` which gives the same results regardless of the query text (and the 'members' equivalent, which seems to work). Was there not a tags endpoint before? Can't remember. Anyhow, was thinking of a …
|
|
|
Hi Guys, I need your help to create query dynamically, how to populate data value from formula in other table. Sample Below Table A ID Amount 1 50 2 40 3 50 Table B ID FormulaID VALUE X 1+2+3 Y 1-2+3 Result Expectation ID FormulaID VALUE X 1+2+3 140 Y … 
|
|
|
Good day I have a table which I have already uploaded a list on however I want to return all the records which are duplicated and have a year between 2014 and 2015, i.e if I have a table like this Year IDNumber FirstName Surname Email 2014 8809254 Tom Jackson …
|
|
|
I have a member table from which I'm trying to create a query using these fields mem_id / username / create_date / mem_status / ref_id / qualify_id A new member is mem_status 'F' with ref_id equal to the mem_id of their referrer and qualify_id of zero When the member upgrades, …
|
|
|
I have been working on this to replace every code that is shared on post in my website but is not working for me. I need everything that appear inside `<pre><code></code></pre>`to replay all the tags and give it a color using css. please if there is any simple way to … |
|
|
Hey everyone, I have a question about a database design that I have right now. The template I was given from someone is the first attached that you will see. I looked at it and figured that the database design of that is not the best, so I decided to …
|
|
|
Hi, I have a page for sending SMS by selecting anyone organization, By selecting organization, it will calculate how many customers are there to send SMS, It will display the SMS Count along with all managers names using JQUERY AJAX. For counting this value,it takes so much time in online, …
|
|
I'm trying to do something, but it doesn't work out, the primary suspect is incorrect query, but I don't know whether it's correct or not. I could try running it in phpMyAdmin, but then I don't know how these are escaped. The result is: `array(5) { ["current_field"]=> NULL ["field_count"]=> NULL …
|
|
|
Sorry i dont know how to explain this properly, but what i'm trying to get across is how do i get sql to select a data type (i dont think thats wording it properly, sorry) which only appears once? Thanks ;p
|
|
|
Probably just overlooking something small but its 5:30 am here so please forgive me. $sql = "SELECT * FROM accounts WHERE username = $testuser"; $result = mysqli_query($conn, $sql); if (!$result || mysqli_num_rows($result) > 0) { // output data of each row while($row = mysqli_fetch_assoc($result)) { echo "id: " . $row["id"]. …
|
|
|
> i have bind 10 random post form json file in to marquee but the problem is arising , its show like list and showing as marquee works kindly check the code and the output , do some suggestion what to do . Thanks in advance <html> <head> <meta charset="UTF-8"> … |
|
|
Hello , I wanted to ask if for these statements in mongo: collection.find({},{}).toArray(function(err, result) { collection.find({email : req.user.email},{}).toArray(function(err, result) { the equivalents in postgresql are: client.query( "SELECT * FROM theTable ", function(err,result) { client.query( "SELECT * FROM theTable WHERE email = 'req.user.email' ", function(err, result) { result should be automatically …
|
|
|
I have the query below: $insert2query="INSERT INTO output_search(ref_code, title, author, channel_id) VALUES (select refcode,title, authors, $idquery as cid from chemoJ where title LIKE '%$search%' and refcode NOT IN (select exc_refid_fk FROM exclusions))"; It is giving me an error near the parenthesis, what is wrong with my sintax? I ran the …
|
|
|
I want to make countdown timer in multiple choice. I want to display question one by one. But when I click next for the next question, the time is start from 10 minutes again, not continue. How to make an alert if the time was over, it would be directly … |
|
|
$res=mysql_query("SELECT * FROM users WHERE username={$_SESSION['user']}"); This line is giving me a lot of trouble. It returns blank when it should be returning something. Anyone have an idea?
|
|
|
Hello ,I want to ask how can I succeed an analogous from mongodb to postgresql. app.post('/myjob', function(req, res) { var collection = db.collection('theDB'); collection.insert({ "my_id" : myID, .... }, function (err, mes) { if (err) { res.send("There was an error"); } else { console.log("Ok with ID "+myID); res.send({ "Done!", ID … |
|
|
Hi, I am new to SQL Server and what I am trying to do is convert my working SELECT Query to an UPDATE Query to update the data from a vb.net datgridview. I have looked for a tool or examples but cant find any information that can point me to …
|
The End.