456 Topics
|
|
How to create submit button on each row ? If i press the button on that row, the information on that row will be confirmed. What is the problem? [CODE] ;<input name="<?php echo $row['id']; ?>" type="submit" id="<?php echo $row['id']; ?>" value="Confrim">&[/CODE] The whole code [CODE] <?php $host="localhost"; // Host name … |
|
[ATTACH=RIGHT]20145[/ATTACH][B]Building your first DYNAMIC Database application. This is Part One of a four part tutorial on how to install and use your database, Part Two will teach you how to build successful connections and Part Three will teach you how to build database interaction and management of your databases.[/B] There … |
|
I needed a script that would grab all the folders in the directory and add them to a dropdown list and allow the user to upload to there choosen folder. This is what i came up with. (upload script is not mine) Thought i would share. |
|
Hi, I am new to php and html, so I need some help with a problem: I am trying to make a form where you can select from a dropbox, but thae data from the dropbox should be retrieved from a sql database. If I save the code bellow as … |
|
I have spent a lot of time on this question, namely, how to programatically use a PHP script to send a PDF document to the printer without launching the Adobe print dialog that results from using arcord32.exe (the adobe reader). PHP has some useful classes for creating PDF's, i.e., the … |
|
Hi. im developing a loan processing system using mvc c# asp.net. One of the requirements of the system is to perform a credit history check on the customer applying for a loan. so this is how it works: -the customer applies for a loan. the customers id number gets stored … |
|
I am trying to select all rows from all tables in the database when a column equal a given name. I have like many tables with same structure and columns. I have written this piece of code but it throws an error. SELECT GROUP_CONCAT(qry SEPARATOR ' UNION ') INTO @sql … |
|
I have two tables. MODELS and AUTOMOBILES. And procedure which export all models with name that user inputs and their price(stored in AUTOMOBILES). create or REPLACE procedure modelzz( VAR_MODEL IN MODELS.NAME_MODEL%TYPE, VAR_PRICE OUT AUTOMOBILES.A_PRICE%TYPE ) as begin SELECT a.A_PRICE INTO VAR_PRICE FROM AUTOMOBILES a join MODELS m on a.MODELS_ID_MODEL=m.ID_MODEL where … |
|
**problem** How to get cost per hotel and flight then add it in duration cost table based on flight date automatically . **Details** suppose i write flight date 26/07/2017 alexia 8days 04/08/2017 it must automatically get cost from hotel price table and price from flight then add it in duration … |
|
HI, I have recently upgraded my mysql database to version 5.1.72 community log. I am having an issue that all my select queries are showing the columns as NULL if there is no entry added for a specific column. For exmaple I have a table table_employee and the employee name … |
|
As it seems to come up often enough I figured I'd throw together a quick snippet outlining basic methods for data manipulation in SQL Server using C#. In all examples the coder will need to substitute their own connection string details and variables. I utilised parameters for 3 of the … |
|
Hi hope you can help me. I have studied a lot to make my website using php and mysql and I know how to insert data in a table from a form, how to select and display data on page etc. Lately I got involved with wordpress which is a … |
|
Hi all, I'm working on a SQL procedure to insert a row for new clients based on a template account that already exists in the database. I thought about Declaring a variable and selecting the value from the table one at a time, but with many columns needed, this seems … |
|
Well if you were like me and Python is your first language. You are trying to learn programming and many people suggested that learn Python as a first language. You take their advice, your download Python and get all set up. Maybe you take a tutorial or two in order … |
|
I want to retrive data from two tables. I used below code : (SELECT sum(total_amount) as tr from loan where loan_status = 'not finish') union (SELECT sum(amount) as tt from settlement where sett_status = 'Active') But It load data by one column and these two values load under the another … |
|
i am able to populate data in chain select drop down list but the problem is when page is refreshing selected data is lost how to fix that .. here is the code.. <?php require_once 'include/config.php'; require_once 'include/opendb.php'; ?> <?php if(isset($_POST['model'])){ //This is for the third and final drop down … |
|
The Code Given is for only beginners in HTML 1.The code implements a simple login form 2.It checks whether the password and usernames are matching or not 3.While you are using replace the predefined username and password that I'v given that is replace "myuserid" and "mypswrd" with your own userid … |
|
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 am in major need of some help here and before I go off and write a SP to handle this for me, I though I would ask here for advice first. I am writing a report to display on our asp.net site using the ReportViewer component and … |
|
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 = … |
|
hey, Previously I post my question. But it wasn't helped. So I tried own and make sum query. It's not generate 0 value records. can anyone hep me ? select loan.loan_id as 'Loan ID' ,loan.customer_name as 'Customer Name' ,loan.total_amount as 'Total Amount' ,ifnull(sum(settlement.amount),0) as 'Total Received' ,((loan.total_amount)-ifnull(sum(settlement.amount), 0))as 'Total Due' … |
hello everyone... can you please help me with the project that im building... my project has a combobox with the items of january-december... a listview with a 14 column. in the first column is name, the second is year and the rest is the month starting from january to december, … |
|
SELECT blabla FROM a INNER JOIN b ON a.a = b.b Is what I have. However I'd like to sort the results DESC by ID. I'd like to select last [`variable` x 10] of items sorted by ID DESC. Variable provided by PHP (I'll sort things out, I just need … |
|
i have a problem in showing two columns which is reff_number and Name in a combobox/select box, and now i can only display one column with it, if i have 9000 customer(in bahasa = pelanggan) , it will take an effort to find for user, and it will be easy … |
|
I think this is called "foreign key" and "local key" ? I have a table `users`, these users have `rank`. It's an `int`. There is a table named `rank`, this table has field where hexadecimal string is placed `FF0000`. Is there a way to `SELECT * FROM users` and `SELECT … |
|
How do i get the most repeated value that is inserted just today from 23:59 till 00:00 i have this sql but i dont know how to filter it by date any help will be apreciated. $sql = "SELECT `MatchTitle`, COUNT(`MatchTitle`) AS `mostPlayed` FROM `matches` GROUP BY `MatchTitle` ORDER BY … |
|
Hey ! I'm looking for sql 'like' command help.... I had mysql database and it had settlement table. On that table there is column named 'settlement'. In the settlement column there are so many amounts..... Now I want to find recors '0 values' Can anybody help me ? |
|
Hello, I was looking for some help with the below query. I need to only return the first 'Carton.CartonNumber'. I tried adding something like ( Select Min(Carton.CartonNumber) as FirstCarton from Cartons group by Carton.ID) dispite much Googling but cant get it right because of all the other joins confusing me. … |
|
hi thrr is no one who can help me this is the prog which when i run faces problem of session. [B][U]session_start(): Cannot send session cookie - headers already sent [/U][/B] pls plssssssssss help me to solve the problem below is the code any one this is simple prog but … |
The End.