456 Topics

Member Avatar for
Member Avatar for cliffcc

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 …

Member Avatar for Kimanzi
0
18K
Member Avatar for AndreRet

[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 …

Member Avatar for twexpresscars
1
2K
Member Avatar for Tko_1

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.

Member Avatar for rproffitt
0
4K
Member Avatar for Nicolas_1

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 …

Member Avatar for kosikondo
0
6K
Member Avatar for akgreen

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 …

Member Avatar for Yogesh_22
7
22K
Member Avatar for 21303359

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 …

Member Avatar for Purvi_1
0
436
Member Avatar for Carlos_18

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 …

Member Avatar for White_4
0
12K
Member Avatar for Prosatanos

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 …

Member Avatar for urtrivedi
0
390
Member Avatar for _1_14

**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 …

Member Avatar for rubberman
0
354
Member Avatar for Saad_8

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 …

Member Avatar for diafol
0
375
Member Avatar for Lusiphur

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 …

Member Avatar for sarvesh_3
2
21K
Member Avatar for Carlo_1

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 …

0
287
Member Avatar for JeremyJ

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 …

Member Avatar for kalxas
0
1K
Member Avatar for inkcoder

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 …

Member Avatar for Gabriel_9
1
47K
Member Avatar for Sashika_1

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 …

Member Avatar for Santanu.Das
0
934
Member Avatar for amaz4u

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 …

Member Avatar for diafol
0
3K
Member Avatar for rajesanthu

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 …

Member Avatar for nate_2
0
137K
Member Avatar for Oxley_1

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 | …

Member Avatar for rproffitt
0
272
Member Avatar for zachattack05

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 …

Member Avatar for zachattack05
0
329
Member Avatar for Glyn_2

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 …

Member Avatar for Glyn_2
0
357
Member Avatar for සශික

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 = …

Member Avatar for Bukola_1
0
266
Member Avatar for සශික

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' …

Member Avatar for hmondy
0
268
Member Avatar for Smooth_1

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, …

Member Avatar for Smooth_1
0
245
Member Avatar for Aeonix

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 …

Member Avatar for hielo
0
306
Member Avatar for rayearth_1

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 …

Member Avatar for rayearth_1
0
2K
Member Avatar for Aeonix

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 …

Member Avatar for Aeonix
0
445
Member Avatar for Stefce

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 …

Member Avatar for cereal
0
226
Member Avatar for sashiksu

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 ?

Member Avatar for AndrisP
0
356
Member Avatar for tig2810

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. …

Member Avatar for dinesh.isuranga
0
361
Member Avatar for manish812

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 …

Member Avatar for Putu_1
0
763

The End.